MS Excel When you copy a formula Excel edits cell references in the newly copied formula Excel erases the original copy of the formula Excel doesn’t adjust relative cell references Excel adjusts absolute cell references Excel edits cell references in the newly copied formula Excel erases the original copy of the formula Excel doesn’t adjust relative cell references Excel adjusts absolute cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a term of MS-Excel? Columns Cells Document Rows Columns Cells Document Rows ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which elements of worksheet can be protected from accidental modification All of the listed here Objects Scenarios Contents All of the listed here Objects Scenarios Contents ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel uniquely identifies cells within a worksheet with a cell name Cell names Column numbers and row letters Cell locator coordinates Column letters and row numbers Cell names Column numbers and row letters Cell locator coordinates Column letters and row numbers ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you select an entire column? Click the column heading letter Select Edit > Select > Column from the menu Hold down the shift key as you click anywhere in the column Hold down the Ctrl key as you click anywhere in the column Click the column heading letter Select Edit > Select > Column from the menu Hold down the shift key as you click anywhere in the column Hold down the Ctrl key as you click anywhere in the column ANSWER DOWNLOAD EXAMIANS APP
MS Excel In the formula, which symbol specifies the fixed columns or rows ? & * % $ & * % $ ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS