MS Excel MCQs with Answers

Which feature in MS Excel is used to create a chart from selected data?

• A.Format Painter
• B.SmartArt
• C.PivotTable
• D.Chart Wizard

What is the primary purpose of using MS Excel software?

• A.Sending emails
• B.Word processing
• C.Creating presentations
• D.Organized data

In MS Excel, which type of value does not change once it is entered?

• A.Variable
• B.Constant
• C.Formula
• D.Function

When is the Edit > Fill Across Worksheets command available in MS Excel?

• A.When only one sheet is selected
• B.When the workbook is protected
• C.When many sheets are selected
• D.When the workbook is in Read-Only mode

In MS Excel, what does the $ symbol indicate in a formula?

• A.Circular Reference
• B.Relative Cell Reference
• C.Mixed Cell Reference
• D.Absolute Cell Reference

How can you view a comment in a cell in MS Excel?

• A.Position the mouse pointer over the cell
• B.Double-click the cell
• C.Right-click the cell and select Show Comment
• D.Press Ctrl + Shift + C

Past Paper MCQ

What can you do using the formula palette in MS Excel?

• A.Create and edit formulas containing functions
• B.Format cells with conditional formatting
• C.Insert charts and graphs into a worksheet
• D.Apply data validation rules to cells

What is defined by the column letter and the row number in an Excel worksheet?

• A.Formula bar
• B.Cell range
• C.Workbook reference
• D.Cell address

What does the range B2:B6 signify in an MS Excel worksheet?

• A.A single cell
• B.Range of cells
• C.A formula reference
• D.A worksheet name

In an Excel chart, what is the vertical axis commonly referred to as?

• A.X-axis
• B.Y-axis
• C.Z-axis
• D.Category axis