MS Excel What does COUNTA () function do? Counts non-empty cells Counts cells having alphabets Counts cells having number Counts empty cells Counts non-empty cells Counts cells having alphabets Counts cells having number Counts empty cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which elements of worksheet can be protected from accidental modification All of the listed here Contents Scenarios Objects All of the listed here Contents Scenarios Objects ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the short cut key to highlight the entire column? Ctrl + Page Up Ctrl + C Ctrl + Enter Ctrl + Space Bar Ctrl + Page Up Ctrl + C Ctrl + Enter Ctrl + Space Bar 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 latters and row numbers Column numbers and row letters Cell locator coordinates Cell names Column latters and row numbers ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not information you can specify using the solver? Changing cells Input cells Target cell Constraints Changing cells Input cells Target cell Constraints ANSWER DOWNLOAD EXAMIANS APP
MS Excel What are the tabs that appear at the bottom of each workbook called? Sheet tabs Position tabs Location tabs Reference tabs Sheet tabs Position tabs Location tabs Reference tabs ANSWER DOWNLOAD EXAMIANS APP