MS Excel MCQs with Answers

How should a cell range from A3 to G3 be represented in a spreadsheet application?

• A.A3..G3
• B.A3-G3
• C.A3:G3
• D.A3;G3

Which of the following is not considered a criterion for designing a worksheet in MS Excel?

• A.Clarity
• B.Accuracy
• C.Description
• D.Efficiency

Which of the following is NOT a spreadsheet application?

• A.Microsoft Excel
• B.Google Sheets
• C.Mozilla Firefox
• D.LibreOffice Calc

In MS Excel, which symbol indicates that you can select a range of cells?

• A.Doctor's symbol (Big Plus)
• B.Arrow pointer
• C.Hourglass
• D.I-beam cursor

Which type of chart is not available as a default option in MS Excel?

• A.Bar Chart
• B.Pie Chart
• C.Volume Chart
• D.Line Chart

What are the basic rectangular building blocks of an MS Excel spreadsheet called?

• A.Sheets
• B.Rows
• C.Columns
• D.Cells

Past Paper MCQ

An Excel workbook is a collection of what components?

• A.Only Charts
• B.Only Worksheets
• C.Worksheets and Charts
• D.Databases and Tables

What is the default row height in Microsoft Excel?

• A.15
• B.12
• C.18
• D.20

Which function returns the maximum number from a range in Excel?

• A.MAX
• B.MIN
• C.LARGE
• D.HIGH

What is the main function of the data validation command in spreadsheet applications?

• A.To format the appearance of cells
• B.To prohibit or allow a cell entry
• C.To perform mathematical calculations
• D.To sort data in ascending or descending order