MS Excel MCQs with Answers

Past Paper MCQ

Which of the following chart types is not available in MS Excel?

• A.Bar Chart
• B.Pie Chart
• C.Line Chart
• D.Volume Chart

Past Paper MCQ

A worksheet in an electronic spreadsheet allows users to perform which of the following actions?

• A.Enter and manipulate data
• B.Perform calculations using formulas
• C.Create charts and graphs
• D.All of these

Past Paper MCQ

What term is used for constant values in MS Excel?

• A.Label
• B.Formula
• C.Function
• D.Number

Past Paper MCQ

Which of the following is not a component of MS Excel?

• A.Worksheet
• B.Chart
• C.Document
• D.Formula Bar

Past Paper MCQ

Which feature in spreadsheet software allows you to reference data from another cell?

• A.Cell Reference
• B.Address
• C.Formula Bar
• D.Range

Past Paper MCQ

How is data organized in a spreadsheet application like MS Excel?

• A.Records and fields
• B.Paragraphs and pages
• C.Rows and columns
• D.Slides and notes

Past Paper MCQ

Which option in MS Excel is used to ensure a specific row or column appears on every printed page?

• A.Print Title
• B.Print Area
• C.Page Break
• D.Freeze Panes

Past Paper MCQ

In a computer spreadsheet, what can each cell contain?

• A.Label
• B.Value
• C.Formula
• D.All of these

Past Paper MCQ

In Microsoft Excel, what do the references like C11, D29 represent?

• A.Cell Address
• B.Formula Bar
• C.Range Name
• D.Worksheet Number

Past Paper MCQ

Another name for a pre-programmed formula in Excel is known as what?

• A.Module
• B.Macro
• C.Template
• D.Function