MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) The status bar does not display the cell address Cell address will change when it is copied to another cell An absolute cell address is created The sheet tab is changed The status bar does not display the cell address Cell address will change when it is copied to another cell An absolute cell address is created The sheet tab is changed ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when you press Ctrl + X after selecting some cells in Excel? The cell content of selected cells disappear from cell and stored in clipboard The selected cells are deleted and the cells are shifted left The cells selected are marked for cutting The selected cells are deleted and cells are shifted up The cell content of selected cells disappear from cell and stored in clipboard The selected cells are deleted and the cells are shifted left The cells selected are marked for cutting The selected cells are deleted and cells are shifted up ANSWER DOWNLOAD EXAMIANS APP
MS Excel Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook? Macro sheet Work sheet Data sheet Chart sheet Macro sheet Work sheet Data sheet Chart sheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel erases the original copy of the formula Excel adjusts absolute cell references Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references Excel erases the original copy of the formula Excel adjusts absolute cell references Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel The name box Appears below the menu bar Shows the location of the previously active cell Appears below the status bar Appears to the left of the formula bar Appears below the menu bar Shows the location of the previously active cell Appears below the status bar Appears to the left of the formula bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)/(10-10) =SUM(A1:A5)*0.5 =SUM(Sales)-A3 =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) =SUM(A1:A5)*0.5 =SUM(Sales)-A3 =SUM(A1:A5)-10 ANSWER DOWNLOAD EXAMIANS APP