MS Excel MCQs with Answers

In MS Excel, what is the default step value in the Fill Series dialog box?

• A.0
• B.1
• C.2
• D.5

Which feature in MS Excel allows you to limit the type of data that can be entered in a cell?

• A.Data Filtering
• B.Conditional Formatting
• C.Cell Protection
• D.Data Validation

In a spreadsheet application, what do the letters at the top of the grid represent?

• A.Rows
• B.Columns
• C.Cells
• D.Sheets

Which of the following is a function in MS Excel?

• A.SHOW()
• B.PRINT()
• C.DISPLAY()
• D.SUM()

If you need to organize, calculate, and analyze numerical data from various sources, which software would you use?

• A.MS Word
• B.MS Excel
• C.MS PowerPoint
• D.MS Access

In MS Excel, which symbol should a numeric value begin with to be treated as a formula?

• A.Plus Sign (+)
• B.Equal Sign (=)
• C.Hash Sign (#)
• D.At Sign (@)

What does the POWER function =POWER(3,4) calculate in Excel?

• A.4 raised to the power of 3
• B.3 multiplied by 4
• C.3 raised to the power of 4
• D.3 added to 4

In MS Excel, how can you activate the previously selected cell range?

• A.Press Ctrl + Shift + *
• B.Press F5 and select the range from the list
• C.Press Ctrl + G and type the range address
• D.None of these

In MS Excel, what is a group of adjacent cells that can be selected for operations called?

• A.Cell Range
• B.Worksheet
• C.Workbook
• D.Cell Block

What is the best page orientation to fit the maximum number of columns on a single sheet when printing?

• A.Portrait
• B.Landscape
• C.Legal
• D.A4