Excel MCQ Flashcards
7 cards from real Microsoft Excel practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Excel MCQ flashcards as text
What does a circular reference in Excel mean?
Answer: A formula that directly or indirectly refers to its own cell
A circular reference occurs when a formula refers back to its own cell, creating an endless calculation loop.
Which function would you use to look up a value in the first column of a table and return a value from another column?
Answer: VLOOKUP
VLOOKUP searches vertically in the first column of a table and returns a value from a specified column.
What is the default file extension for Excel workbooks saved in modern Excel versions?
Answer: .xlsx
.xlsx is the default Open XML format for Excel workbooks introduced in Excel 2007.
Which Excel feature highlights cells based on their values using color scales or icons?
Answer: Conditional Formatting
Conditional Formatting applies visual formatting rules to cells based on their content or value.
What does the AVERAGE function do when a cell in its range contains text?
Answer: Ignores the text cell
AVERAGE ignores text values and blank cells, calculating only from numeric values in the range.
Which Excel function converts a text string to all uppercase letters?
Answer: UPPER
UPPER(text) converts all characters in a text string to uppercase letters.
In a PivotTable, what does the 'Values' area display?
Answer: Aggregated data such as sums, counts, or averages
The Values area in a PivotTable shows summarized data calculated by functions like SUM, COUNT, or AVERAGE.