MS Excel To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the Freeze panes command on the window menu Hold titles command on the edit menu Unfreeze panes command on the window menu Split command on the window menu Freeze panes command on the window menu Hold titles command on the edit menu Unfreeze panes command on the window menu Split command on the window menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel What does COUNTA () function do? Counts cells having alphabets Counts non-empty cells Counts cells having number Counts empty cells Counts cells having alphabets Counts non-empty cells Counts cells having number Counts empty cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not the correct method of editing the cell content? Double click the cell Press the Alt key Click the formula bar Press the F2 key Double click the cell Press the Alt key Click the formula bar Press the F2 key ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel uniquely identifies cells within a worksheet with a cell name Column numbers and row letters Cell locator coordinates Cell names Column letters and row numbers Column numbers and row letters Cell locator coordinates Cell names Column letters and row numbers ANSWER DOWNLOAD EXAMIANS APP
MS Excel The auto calculate feature Automatically creates formulas and adds them to a worksheet Provides a quick way to view the result of an arithmetic operation on a range of cells Can only add values in a range of cells A and C Automatically creates formulas and adds them to a worksheet Provides a quick way to view the result of an arithmetic operation on a range of cells Can only add values in a range of cells A and C ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is the oldest spreadsheet package? VisiCalc Lotus 1-2-3 StarCalc Excel VisiCalc Lotus 1-2-3 StarCalc Excel ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS