MS Excel MCQs with Answers

In MS Excel, what is a macro typically used for?

• A.To create charts and graphs automatically
• B.A set of instructions that can be executed as a single command
• C.To format cells with predefined styles only
• D.To import data from external databases

Past Paper MCQ

Which Excel feature allows the conversion of a column of data into a row?

• A.Paste Special > Transpose
• B.Flash Fill
• C.Text to Columns
• D.Data Validation

Which of the following is commonly used for a visual representation of data?

• A.Query
• B.Report
• C.Table
• D.Chart

In Microsoft Excel, what are the intersecting rows and columns that form small boxes called?

• A.Cells
• B.Grids
• C.Blocks
• D.Fields

What are the horizontal lines in an MS Excel worksheet called?

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

What must a formula in MS Excel always start with?

• A.#
• B.+
• C.@
• D.=

In MS Excel, what feature allows you to calculate, summarize, and analyze data, providing insights into comparisons, patterns, and trends?

• A.Conditional Formatting
• B.VLOOKUP
• C.PivotTable
• D.Data Validation

What is the first step to duplicate values in a cell range in Excel 2016?

• A.Open the Paste Special dialog box
• B.Press Ctrl+C on the keyboard
• C.Click the destination cell
• D.Select the range of cells in the worksheet

What is the term for the unique address of every cell in a worksheet?

• A.Cell reference
• B.Cell range
• C.Cell value
• D.Cell format

In MS Excel, how can you identify a selected cell visually?

• A.Blinking cursor inside the cell
• B.Wide bold line
• C.Flashing cell color
• D.Dotted border around the cell