MS Excel MCQs with Answers

In MS Excel, which command would you use to display numbers between 0 and 100 in red color?

• A.Apply Conditional Formatting command on Format menu
• B.Apply Cell Styles command on Home tab
• C.Apply Sort & Filter command on Data menu
• D.Apply Data Validation command on Data menu

What is the method to remove borders applied to cells in MS Excel?

• A.Select cells and choose No Border from the Border menu
• B.Use the Erase Border tool from the Border drop-down
• C.Both a and b
• D.Right-click the cell and select Delete Border

In MS Excel, what is the name of the bar that appears at the topmost part of the screen in a new workbook?

• A.Title Bar
• B.Menu Bar
• C.Formula Bar
• D.Status Bar

Past Paper MCQ

To automatically adjust the width of a column in MS Excel, which action should you perform?

• A.Double click the right border of the column
• B.Right-click the column header and select "AutoFit"
• C.Drag the left border of the column
• D.Press Ctrl + W

Which MS Office application allows users to perform mathematical calculations using formulas?

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

In Microsoft Excel, how is the date entry 'July 16, 2016' treated by default?

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

How can you delete a worksheet in Excel if you only need two out of the default three?

• A.Click the Close button on the sheet tab
• B.Go to File menu and select Delete Sheet
• C.Press Ctrl + D and select the sheet to delete
• D.Right-click on the Sheet Tab of the third sheet and select Delete from the context menu

What is the label of the first cell in an MS Excel worksheet?

• A.0A
• B.1A
• C.A0
• D.A1

In a spreadsheet, what is the vertical arrangement of data called?

• A.Row
• B.Column
• C.Cell
• D.Range

Which of the following statements about conditional formatting in MS Excel is not true?

• A.You can apply conditional formatting to highlight cells that contain duplicate values
• B.You can use conditional formatting to apply data bars, color scales, and icon sets
• C.You can set condition to look for Bold and apply Italics on them
• D.You can create rules based on cell values, formulas, or dates