MS Excel MCQs with Answers

Which of the following methods can be used to zoom in or out of an Excel worksheet?

• A.Using the Zoom slider on the status bar
• B.Using the Zoom option in the View tab
• C.Holding Ctrl key and scrolling the mouse wheel
• D.All of these

How are rows represented in an MS Excel worksheet?

• A.Symbols
• B.Letters
• C.Numbers
• D.Alphanumeric codes

What does the MIN function do in Excel when used as =MIN(A1:A5)?

• A.Counts the number of cells
• B.Returns the average of numbers
• C.Returns the maximum number
• D.Returns the minimum number

Which feature in MS Excel allows you to apply visual cues to data based on specific conditions?

• A.Data Validation
• B.Conditional Formatting
• C.SmartArt Graphics
• D.PivotTable

Where can you find the ZOOM option in MS-Excel?

• A.Ribbon
• B.Status Bar
• C.Quick Access Toolbar
• D.Formula Bar

In MS Excel, which command is executed when the Delete key is pressed on the keyboard?

• A.Edit > Clear > Formats
• B.Edit > Clear > All
• C.Edit > Delete
• D.Edit > Clear > Contents

In MS Excel, which icon indicates that you can fill a series of cells?

• A.Arrow icon
• B.Hand icon
• C.Small thin plus icon
• D.Crosshair icon

Past Paper MCQ

What does the MOD() function return in MS Excel?

• A.Quotient
• B.Remainder
• C.Product
• D.Power

Which feature in MS Excel automatically sums up numbers in the selected cells?

• A.AutoFormat
• B.AutoFill
• C.AutoSum
• D.AutoComplete

Which feature in MS Excel allows you to protect the integrity of your worksheet data by restricting edits to specific cells?

• A.Track Changes
• B.Freeze Panes
• C.Data Validation
• D.Lock the cells