MS Excel What does COUNTA () function do? Counts cells having alphabets Counts empty cells Counts non-empty cells Counts cells having number Counts cells having alphabets Counts empty cells Counts non-empty cells Counts cells having number ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you change automatic or manual calculation mode in Excel? Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Double CAL indicator on status bar None of above Both of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Double CAL indicator on status bar None of above Both of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use the horizontal and vertical scroll bars to View different rows and columns edit the contents of a cell View different worksheets Split a worksheet into two panes Edit the contents of a cell View different rows and columns edit the contents of a cell View different worksheets Split a worksheet into two panes Edit the contents of a cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet1!A10 Sheet3!A10 A10 Sheet3.A10 Sheet1!A10 Sheet3!A10 A10 Sheet3.A10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use drag-and-drop to embed excel worksheet data in a word document None of the listed here By dragging a range of excel data to the word button on the taskbar while pressing Shift key By dragging a range of excel data to the word button on the taskbar while pressing Alt key By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key None of the listed here By dragging a range of excel data to the word button on the taskbar while pressing Shift key By dragging a range of excel data to the word button on the taskbar while pressing Alt key By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key ANSWER DOWNLOAD EXAMIANS APP
MS Excel In help menu of Excel, which of the following tabs are found? Index tab Answer Wizard tab Contents tab All of these Index tab Answer Wizard tab Contents tab All of these ANSWER DOWNLOAD EXAMIANS APP