Home
MCQs
MS Office MCQs
MS Excel
MS Office MCQs

MS Office MCQs - MS Excel

MS Excel MCQs consist of Shortcut Keys, Functions, Formulas, Sheets, Workbook, Data Formatting, Charts, Graphs, Lines, Tables and Layouts.

11. A COUNT function in MS Excel

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

Answer: C

12. Ctrl + F searches in

A. Current sheet

B. All Sheets

C. Current Workbook

D. All of above

Answer: A

13. A Shortcut key which inserts hyperlink in MS Excel

14. A Shortcut key which inserts hyperlink in MS Excel

A. Ctrl+ P

B. Ctrl+ I

C. Ctrl+ K

D. Ctrl+ L

Answer: C

15. COUNTA function in MS Excel

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

Answer: A

16. Ctrl + 5 puts the

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

Answer: C

17. The TRIM function is used for

A. changing the cases of the texts

B. eliminating all empty spaces

C. making italic texts in the cell

D. All of above

Answer: B