Microsoft Excel Excel MCQ 4 — Questions and Answers
Question 1: What does a circular reference in Excel mean?
- A formula that references cells in a circle shape
- A formula that directly or indirectly refers to its own cell (Correct answer)
- A formula that loops through all cells in a range
- A chart that displays data in a circular format
Correct 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.
Question 2: Which function would you use to look up a value in the first column of a table and return a value from another column?
- HLOOKUP
- VLOOKUP (Correct answer)
- XLOOKUP
- MATCH
Correct answer: VLOOKUP
VLOOKUP searches vertically in the first column of a table and returns a value from a specified column.
Question 3: What is the default file extension for Excel workbooks saved in modern Excel versions?
- .xls
- .xlsx (Correct answer)
- .xlsm
- .csv
Correct answer: .xlsx
.xlsx is the default Open XML format for Excel workbooks introduced in Excel 2007.
Question 4: Which Excel feature highlights cells based on their values using color scales or icons?
- Data Validation
- Conditional Formatting (Correct answer)
- Cell Styles
- Format Painter
Correct answer: Conditional Formatting
Conditional Formatting applies visual formatting rules to cells based on their content or value.
Question 5: What does the AVERAGE function do when a cell in its range contains text?
- Returns an error
- Counts the text cell as zero
- Ignores the text cell (Correct answer)
- Converts the text to a number
Correct answer: Ignores the text cell
AVERAGE ignores text values and blank cells, calculating only from numeric values in the range.
Question 6: Which Excel function converts a text string to all uppercase letters?
- CAPS
- UPPER (Correct answer)
- CAPITAL
- UCASE
Correct answer: UPPER
UPPER(text) converts all characters in a text string to uppercase letters.
Question 7: In a PivotTable, what does the 'Values' area display?
- The row labels for the pivot table
- Aggregated data such as sums, counts, or averages (Correct answer)
- Filters applied to the data
- The column headers of the source data
Correct 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.
Microsoft Excel Excel MCQ 4
What does a circular reference in Excel mean?