Microsoft Excel Mcqs

Which function calculates the largest value in a set of numbers?

A. Average
B. Count
C. Minimum
D. Maximum

What displays the content of active cell?

A. Name box
B. Row headings
C. Formula bar
D. None of these

Microsoft Excel 2019 files have a default extension of___________?A. .Xlsx
B. .Xls
C. .excel
D. .123

 

Which of the following is the latest version of MS Excel?A. Excel 2016
B. Excel 2017
C. Excel 2019
D. Office 365

 

Ctrl+Shift+1 shortcut Keys in excel are used to __________?

A. Format number in comma format
B. Format number in currency format
C. Format number in date format
D. Format number in time format

Which Shortcut keys are used to strikethrough highlighted selection in Excel?

A. Ctrl+4
B. Ctrl+5
C. Ctrl+6
D. None of the above.

Excel strikethrough shortcut
Want to have the job done as quickly as possible? Press a hotkey or key combination.
Here’s the keyboard shortcut to strikethrough in Excel: Ctrl + 5
The shortcut can be used on an entire cell, certain part of the cell contents, or a range of cells.
To apply the strikethrough format to a cell, select that cell, and press the shortcut: