MS Excel In the formula, which symbol specifies the fixed columns or rows ? * & $ % * & $ % ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you change automatic or manual calculation mode in Excel? None of above Both of above Double CAL indicator on status bar Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button None of above Both of above Double CAL indicator on status bar Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the short cut key to highlight the entire column? Ctrl + Enter Ctrl + C Ctrl + Space Bar Ctrl + Page Up Ctrl + Enter Ctrl + C Ctrl + Space Bar Ctrl + Page Up ANSWER DOWNLOAD EXAMIANS APP
MS Excel The auto calculate feature Can only add values in a range of cells Provides a quick way to view the result of an arithmetic operation on a range of cells Automatically creates formulas and adds them to a worksheet A and C Can only add values in a range of cells Provides a quick way to view the result of an arithmetic operation on a range of cells Automatically creates formulas and adds them to a worksheet A and C ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you select an entire column? Select Edit > Select > Column from the menu Click the column heading letter Hold down the shift key as you click anywhere in the column Hold down the Ctrl key as you click anywhere in the column Select Edit > Select > Column from the menu Click the column heading letter 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
EXAMIANS