MS Excel MCQs with Answers

What is the default name given to the first worksheet in a new Excel workbook?

• A.Sheet1
• B.Book1
• C.Worksheet1
• D.Page1

Which function is not available in the Consolidate dialog box of MS Excel?

• A.Sum
• B.Average
• C.Pmt
• D.Count

To remove only the formatting from a selected range in MS Excel, which option should you choose?

• A.From Format menu choose Clear Formatting
• B.From Edit menu choose Clear and then Contents
• C.From Edit menu choose Clear and then All
• D.From Edit menu choose Clear and then Formats

How do you denote a range of cells from A1 to M12 in MS Excel?

• A.A1:M12
• B.A1-M12
• C.A1..M12
• D.A1;M12

Which Excel function returns the square root of the value in cell A5?

• A.POWER(A5, 2)
• B.SQRT(A5)
• C.ROOT(A5)
• D.SQR(A5)

Which software application is commonly used for statistical calculations and creating tables and graphs?

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

What is the term used for the systematic arrangement of data in rows and columns?

• A.Classification
• B.Tabulation
• C.Summarization
• D.Aggregation

What steps do you follow to delete a record in MS Excel?

• A.Select Data > Open data from dialog box to find the record and click the delete button
• B.Right-click the sheet tab and choose Delete Record from the context menu
• C.Press Ctrl + D and then select the record to delete from the pop-up list
• D.Go to Home tab > Editing group > Clear > Clear Records

In MS Excel, which of the following is not a type of sheet you can have in a workbook?

• A.Worksheet
• B.Chart sheet
• C.Data sheet
• D.Macro sheet

Past Paper MCQ

How can you display the current date and time in MS Excel?

• A.TIME()
• B.TODAY()
• C.DATE()
• D.NOW()