MS Excel MCQs consist of Shortcut Keys, Functions, Formulas, Sheets, Workbook, Data Formatting, Charts, Graphs, Lines, Tables and Layouts.
A. Counts all cells in a given range that contain numeric values and text values
B. Sum of all numeric values in the rage
C. Counts all cells in a given range that contain only numeric values
D. All of above
View Answer
A. Current sheet
B. All Sheets
C. Current Workbook
D. All of above
View Answer
A. Ctrl+ P
B. Ctrl+ I
C. Ctrl+ K
D. Ctrl+ L
View Answer
A. Counts all cells in a given range that contain numeric values and text values
B. Counts all cells in a given range that contain numeric values only
C. Counts all cells in a given range that contain text values only
D. None of above
View Answer
A. Underlines all cells in highlighted section
B. Puts italics all cells in the highlighted section
C. Puts a strike through all cells in the highlighted section.
D. None of these
View Answer
A. changing the cases of the texts
B. eliminating all empty spaces
C. making italic texts in the cell
D. All of above
View Answer