MS Excel MCQs with Answers

Past Paper MCQ

Which of the following is not a correct method to edit the content of a cell in MS Excel?

• A.Double-click the cell
• B.Press F2 key
• C.Press the Alt key
• D.Click the formula bar

How can you toggle grid-lines visibility in an Excel worksheet?

• A.Page Layout tab -> Sheet Options group -> Gridlines checkbox
• B.View tab -> Show group -> Gridlines checkbox
• C.Home tab -> Editing group -> Gridlines checkbox
• D.File tab -> Options -> Advanced -> Gridlines checkbox

Calculate the result of the MS Excel formula: = FACT(0) + FACT(3) + FACT(5).

• A.126
• B.128
• C.127
• D.125

What is used to reference or navigate between different cells in an Excel worksheet?

• A.Address
• B.Formula
• C.Range
• D.Function

In MS Excel, what does the term 'data categories' refer to?

• A.Data labels on a chart
• B.A vertical axis
• C.A horizontal axis
• D.Legend entries in a chart

In MS Excel, which of the following is NOT an example of a value?

• A.A number
• B.A date
• C.A text label
• D.A formula result

What is another term used to describe a cell address in MS Excel?

• A.Cell format
• B.Cell range
• C.Cell value
• D.Cell reference

In MS Excel, which of the following represents a valid range reference?

• A.C3:E5
• B.C3-E5
• C.C3..E5
• D.C3>E5

Which function in Microsoft Excel is used to interchange rows and columns in a worksheet?

• A.Transpose
• B.Pivot
• C.Swap
• D.Convert

Which of the following is not a recognized type of chart in data visualization?

• A.Bar chart
• B.Pie chart
• C.T-graph
• D.Line chart