MS Excel MCQs with Answers

In Microsoft Excel, where can you change the shading color for a selected range of cells?

• A.Home tab → Font group → Fill Color
• B.Right-click → Format Cells → Fill tab
• C.Page Layout tab → Page Setup group → Background
• D.All of these

Past Paper MCQ

In MS Excel, where is the address of the current active cell displayed?

• A.Formula bar
• B.Name box
• C.Status bar
• D.Title bar

Past Paper MCQ

What is the outcome of the Excel formula (7-3)×(4+3)/4?

• A.10
• B.5
• C.7
• D.8

How many columns are there in MS Excel 2007?

• A.16,384
• B.65,536
• C.1,048,576
• D.256

In MS Excel, which feature is used to automatically adjust the row height to allow a long text to fit within the cell?

• A.Wrap Text
• B.AutoFit
• C.Merge & Center
• D.Text Orientation

Why might Excel not automatically update a formula when changes are made?

• A.Manual calculation mode is enabled
• B.The formula contains a circular reference
• C.The worksheet is protected
• D.The cell format is set to Text

Which method in MS Excel allows you to create a new table without specifying the field type and size?

• A.CreateTable By Entering Data
• B.CreateTable Using Design View
• C.CreateTable Using Table Wizard
• D.CreateTable By Importing Data

Which of the following MS-Excel 2016 formulas will result in an error due to division by zero?

• A.=SUM(A1:A5)/(10-10)
• B.=AVERAGE(A1:A5)/2
• C.=SUM(A1:A5)*0
• D.=PRODUCT(A1:A5)/1

What are the horizontal and vertical lines on a spreadsheet commonly known as?

• A.Grid-lines
• B.Border-lines
• C.Row-column lines
• D.Cell boundaries

Which option in the Format Cells dialog box is used to merge cells and center the content in MS Excel?

• A.Wrap Text check box
• B.Merge and Center check box
• C.Shrink to Fit check box
• D.Center Across Selection check box