Category Archives: MS Excel MCQs

MS-Excel is a?

A. Workbook
B. Design format
C. Spreadsheet
D. None of these

Statistical calculations and preparation of tables and graphs can be done using?

A. Excel
B. Power Point
C. Notepad
D. Adobe Photoshop

In Excel, spacing in a column is called as?

A. Stirrups
B. Paper Size
C. Page Layout
D. All of the above

Which of the following is not a function in Microsoft Excel?

A. SUM
B. MAX
C. MIN
D. AVG

In MS Excel 2016, ‘Conditional Formatting’ option is available in______ menu?

A. Insert
B. Page Layout
C. Formulas
D. Home

Which area in Excel window allows entering values and formulas?

A. Title bar
B. Menu bar
C. Formula bar
D. Standard toolbar

In MS Excel 2016, = Now() is used?

A. To show say name
B. To show time only
C. To show date only
D. To show current date and time

To move between the worksheets in a workbook in MS Excel, we can use which of the following shortcut?

A. Alt + =
B. Ctrl + 9
C. Ctrl + Tab
D. Ctrl + Page up

In MS Excel 2016, ‘Print Titles’ option is available in _____ menu?

A. Review
B. View
C. Insert
D. Page Layout

Which symbol must all formula begin with?

A. =
B. *
C. #
D. All of these