MS Excel MCQs with Answers

Past Paper MCQ

Which feature in MS Excel is used for organizing data in ascending or descending order?

• A.Data Filter
• B.Data Sort
• C.Data Validation
• D.Data Consolidation

Past Paper MCQ

In Microsoft Excel, what do the letters at the top of the spreadsheet represent?

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

Past Paper MCQ

What is a group of cells called in Microsoft Excel?

• A.Cell Range
• B.Worksheet
• C.Workbook
• D.Cell Block

Past Paper MCQ

In Excel, what is a data series?

• A.A collection of worksheets in a workbook
• B.A set of formatting rules applied to cells
• C.A row or column of numbers that are plotted in a chart
• D.A formula that performs calculations across multiple sheets

Past Paper MCQ

In MS Excel 2016, which option is used to split the window into two panes?

• A.View > Window > Split
• B.View > Window > Arrange All
• C.View > Window > Freeze Panes
• D.View > Window > New Window

Past Paper MCQ

Which program in Microsoft Office is used for creating spreadsheets?

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

Past Paper MCQ

Which button in MS Excel is used to quickly sum a series of numbers?

• A.AutoSum Button
• B.QuickSum Button
• C.SumTotal Button
• D.FormulaSum Button

Past Paper MCQ

What symbol is used in Excel to include all cells between two cell references?

• A.Comma (,)
• B.Semicolon (;)
• C.Single colon (:)
• D.Hash (#)

Past Paper MCQ

Which data type is considered valid in MS Excel?

• A.Rational
• B.Complex
• C.Boolean
• D.Imaginary

Past Paper MCQ

When you press which key does the cell in MS Excel accept your typing as its contents?

• A.Tab
• B.Enter
• C.Spacebar
• D.Esc