MS Excel MCQs with Answers

Which of the following terms does not relate to Microsoft Excel?

• A.Workbook
• B.Cell
• C.Browser
• D.Formula Bar

In MS Excel, what are the vertical divisions of a worksheet called?

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

What information does the Name Box display in MS Excel?

• A.The file name of the current workbook
• B.The name of the active worksheet
• C.The formula applied in the selected cell
• D.The current cell or range address

Which of the following is not commonly associated with spreadsheet software?

• A.Cell
• B.Formula
• C.Browser
• D.Worksheet

What is the maximum number of characters that can be entered in a single cell in Microsoft Excel?

• A.255
• B.32767
• C.65536
• D.1048576

Which MS Excel function is used to calculate depreciation, rates of return, future values, and loan payment amounts?

• A.Statistical
• B.Financial
• C.Logical
• D.Mathematical

Which of the following features is not available in the Data tab of MS Excel?

• A.Sort & Filter
• B.Data Validation
• C.Charts
• D.Text to Columns

Which Excel feature allows users to evaluate values and return a result?

• A.Templates
• B.Charts
• C.Filters
• D.Formulas

Past Paper MCQ

Which of the following wildcard characters are used in MS Excel for pattern matching?

• A.* and ?
• B.% and _
• C.& and #
• D.@ and $

Which feature in MS Excel enables you to display rows that meet specific criteria?

• A.Sorting
• B.Filtering
• C.Conditional Formatting
• D.Data Validation