MS Excel What does COUNTA () function do? Counts cells having alphabets Counts cells having number Counts non-empty cells Counts empty cells Counts cells having alphabets Counts cells having number Counts non-empty cells Counts empty cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel You cannot link excel worksheet data to a word document With the copy and paste buttons on the standard toolbar With the copy and paste special commands With a hyperlink With the right drag method With the copy and paste buttons on the standard toolbar With the copy and paste special commands With a hyperlink With the right drag method ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following action removes a sheet from workbook? None of above Select the sheet then choose Format > Sheet > Hide Select the sheet, then choose Edit > Delete Sheet Both of above None of above Select the sheet then choose Format > Sheet > Hide Select the sheet, then choose Edit > Delete Sheet Both of above 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 Shift + Home Press Home Press Alt + Home Press Ctrl + Home Press Shift + Home Press Home Press Alt + Home Press Ctrl + Home 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 Where can you change automatic or manual calculation mode in Excel? Double CAL indicator on status bar Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Both of above None of above Double CAL indicator on status bar Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Both of above None of above ANSWER DOWNLOAD EXAMIANS APP