MS Excel What does COUNTA () function do? Counts cells having number Counts empty cells Counts non-empty cells Counts cells having alphabets Counts cells having number Counts empty cells Counts non-empty cells Counts cells having alphabets ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following Excel screen components can NOT be turned on or off ? Formula Bar Status Bar None Tool Bar Formula Bar Status Bar None Tool Bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet? Press Ctrl + Home Press Alt + Home Press Home Press Shift + Home Press Ctrl + Home Press Alt + Home Press Home Press Shift + Home ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you select an entire column? Hold down the Ctrl key as you click anywhere in the column Hold down the shift key as you click anywhere in the column Click the column heading letter Select Edit > Select > Column from the menu Hold down the Ctrl key as you click anywhere in the column Hold down the shift key as you click anywhere in the column Click the column heading letter Select Edit > Select > Column from the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use the formula palette to Format cells containing numbers Copy a range of cells Create and edit formula containing functions Enter assumptions data Format cells containing numbers Copy a range of cells Create and edit formula containing functions Enter assumptions data ANSWER DOWNLOAD EXAMIANS APP
MS Excel The name box Shows the location of the previously active cell Appears below the menu bar Appears below the status bar Appears to the left of the formula bar Shows the location of the previously active cell Appears below the menu bar Appears below the status bar Appears to the left of the formula bar ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS