MS Excel MCQs with Answers

What does the 'Delete' command in the Edit menu do in most applications?

• A.Removes selected cells
• B.Copies selected cells to clipboard
• C.Pastes content from clipboard
• D.Cuts selected cells to clipboard

In MS Excel, which elements of a worksheet can be protected to prevent accidental modification?

• A.Contents
• B.Objects
• C.Scenarios
• D.All of these

Which wildcard characters are recognized by MS Excel for filtering data?

• A.! and ~
• B.% and _
• C.& and #
• D.* and ?

Which command in MS Excel is used to remove the content of selected cells?

• A.Delete
• B.Clear Contents
• C.Remove
• D.Cut

In MS Excel 2016, which option must you navigate to in order to set or clear the print area?

• A.Page Layout
• B.File
• C.View
• D.Data

How can you remove a column in MS Excel?

• A.Right-click the column heading and select 'Delete'
• B.Press Ctrl + D on the selected column
• C.Click the Home tab and select 'Remove Column'
• D.Double-click the column heading and press Backspace

Past Paper MCQ

In MS Excel, how is the cell entry 'July 16, 2016' categorized?

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

In MS Excel, what feature is found in the bottom right area of the spreadsheet window?

• A.Zoom Slider
• B.Page View Buttons
• C.Status Bar
• D.All of these

In Microsoft Excel, how is a worksheet primarily organized?

• A.Pages & Sections
• B.Slides & Panes
• C.Columns & Rows
• D.Tables & Queries

Which feature in MS Excel is used to display only the data in columns according to specific criteria?

• A.Sorting
• B.Validation
• C.Filtering
• D.Conditional Formatting