MS Excel MCQs with Answers

Past Paper MCQ

An excel workbook is a collection of ?

• A.Worksheets and Charts
• B.Only Worksheets
• C.Only Charts
• D.Documents and Slides

Past Paper MCQ

VLOOKUP in Excel is?

• A.Vector Lookup
• B.Visual Lookup
• C.Variable Lookup
• D.Vertical Lookup

Past Paper MCQ

Pivot Table is a feature of which of the following software?

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

Past Paper MCQ

Which of the following statements accurately describes the ability to add or delete columns and rows in a database or spreadsheet?

• A.You can add and delete columns/rows as needed
• B.Columns and rows once created cannot be modified
• C.Only columns can be added but rows are fixed
• D.Only rows can be deleted but columns are permanent

Past Paper MCQ

How can you edit a chart in a document or spreadsheet application?

• A.Right-click the chart and select "Edit Data"
• B.Double click the chart object
• C.Press Ctrl+E while the chart is selected
• D.Go to View menu and select "Edit Chart"

Past Paper MCQ

IF function used in Excel for _?

• A.Performing logical comparisons
• B.Creating charts and graphs
• C.Sorting data alphabetically
• D.Formatting cell borders

Past Paper MCQ

The function in Excel returns the highest value in a set of data that you specify.

• A.MAX
• B.MIN
• C.HIGH
• D.TOP

Past Paper MCQ

A collection of related worksheets is called ?

• A.Worksheet
• B.Document
• C.Spreadsheet
• D.Workbook

Past Paper MCQ

How to add a filter in Excel?

• A.Go to Home → Sort & Filter
• B.Go to Data → Filter
• C.Go to Insert → Filter
• D.Go to View → Filter

Past Paper MCQ

In Excel, to perform addition, the function used is _?

• A.=ADD()
• B.=SUM()
• C.=TOTAL()
• D.=PLUS()