MS Excel MCQs with Answers

Which software is primarily used for spreadsheet calculations?

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

Which of the following statements about adjusting row width in MS Excel is incorrect?

• A.Row width can be adjusted by dragging the row boundary
• B.Row width can be adjusted using the Format menu option
• C.Row width can only be adjusted manually
• D.Row width can be auto-fitted to match the content height

Which type of chart in MS Excel is best suited for comparing the sales performance of two products?

• A.Pie Chart
• B.Column Chart
• C.Line Chart
• D.Scatter Chart

In MS Excel, what is a block of cells containing numbers called?

• A.Workbook
• B.Array
• C.Table
• D.Range

Which option would a company use in a spreadsheet application to analyze customer preferences?

• A.Pivot Table
• B.Data Validation
• C.Conditional Formatting
• D.Data Sorting

Past Paper MCQ

How can you display or hide the gridlines in an Excel worksheet?

• A.From Page Layout tab → Sheet Options group → Gridlines → View
• B.From View tab → Show group → Gridlines
• C.From File tab → Options → Advanced → Display options for this worksheet → Show gridlines
• D.Both A and B

In MS Excel, which menu system allows users to navigate and access various Excel commands?

• A.Toolbar
• B.Taskbar
• C.Ribbon
• D.Status Bar

What is the basic unit in a computer worksheet where text and numbers are entered?

• A.Row
• B.Column
• C.Cell
• D.Range

Which mathematical operator in MS Excel requires both operands to be integers?

• A.%
• B./
• C.*
• D.^

What is the primary function of the 'Pivot Table' tool in MS Excel?

• A.Perform spell check
• B.Create charts and graphs
• C.Apply conditional formatting
• D.Summarize and analyze data