MS Excel MCQs with Answers

Past Paper MCQ

Which of the following is not a feature commonly found in a computer spreadsheet interface?

• A.Formula bar
• B.Grid of cells
• C.Pencil work
• D.Worksheet tabs

Past Paper MCQ

By default, how many worksheets does a new Excel workbook contain?

• A.1
• B.2
• C.3
• D.5

Past Paper MCQ

MS Excel is primarily designed to run on which operating system?

• A.Linux
• B.macOS
• C.Windows
• D.Android

Past Paper MCQ

The _ contains the insertion point of a cell on a worksheet and is identified by the column letter and the row number.

• A.Cell address
• B.Formula bar
• C.Name box
• D.Status bar

Past Paper MCQ

In MS Excel, what does the cell reference B2:B6 signify?

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

Past Paper MCQ

What is the purpose of using the PROPER function in MS Excel?

• A.Convert your input text to uppercase
• B.Convert your input text to lowercase
• C.Convert your input text to proper case
• D.Convert your input text to sentence case

Past Paper MCQ

In MS Excel, which tab allows you to insert a chart?

• A.Insert
• B.Home
• C.Data
• D.View

Past Paper MCQ

In MS Excel, what is the name of the formula that searches for a value in the leftmost column of a table and returns a value in the same row for a specified column?

• A.Horizontal Lookup
• B.Index Match
• C.Vertical Lookup
• D.Matrix Lookup

Past Paper MCQ

Which function is used in MS Excel to calculate the monthly mortgage payment?

• A.FV
• B.PV
• C.PMT
• D.RATE

Past Paper MCQ

What function does VLOOKUP perform in an Excel spreadsheet?

• A.It looks up a value vertically and returns a corresponding value from the same row
• B.It looks up a value horizontally and returns a corresponding value from the same column
• C.It searches for a value and returns its cell reference only
• D.It combines values from multiple cells into a single string