Which of these Excel functions is NOT primarily designed for mathematical calculation?
COUNT
AVERAGE
VLOOKUP
✓
SUM
Correct Answer
VLOOKUP
SUM, AVERAGE, and COUNT are all functions that perform mathematical calculations on numbers. VLOOKUP is a lookup and reference function, not a mathematical one.
Question 2
Which of these Excel formatting options is NOT a standard number format category?
Currency
Conditional Formatting
✓
General
Percentage
Correct Answer
Conditional Formatting
General, Currency, and Percentage are standard number format categories that define how numerical values are displayed. Conditional Formatting applies formats based on rules, rather than being a display category itself.
Question 3
Which of these Excel features is NOT used for modifying the physical structure or content arrangement of data within a worksheet?
Data Validation
✓
Text to Columns
Remove Duplicates
Flash Fill
Correct Answer
Data Validation
Text to Columns, Remove Duplicates, and Flash Fill are all features used to transform or rearrange existing data within a worksheet. Data Validation restricts what data can be entered into cells, but does not modify existing data's structure or arrangement.
Question 4
Which of these Excel chart elements is NOT typically used to provide additional context or detail about the plotted data?
Data Table
Data Labels
Trendline
Chart Title
✓
Correct Answer
Chart Title
Data Labels, Data Table, and Trendline all provide specific context or detail related to the plotted data points. A Chart Title provides a general identification for the entire chart.
Question 5
Which of these Excel functions is NOT used for conditional logic?
SUM
✓
IF
AND
OR
Correct Answer
SUM
IF, AND, and OR are all functions used to implement conditional logic in Excel. SUM performs mathematical aggregation and is not a conditional logic function.
Question 6
Which of these is NOT a standard aggregation function directly available in the 'Values' area of an Excel PivotTable?
Average
SUMIFS
✓
Sum
Count
Correct Answer
SUMIFS
Count, Sum, and Average are standard aggregation functions that can be directly applied to fields in the 'Values' area of an Excel PivotTable. SUMIFS is a worksheet function for conditional summation and is not a direct PivotTable aggregation option.
Question 7
Which of these Excel functions is NOT primarily used for manipulating text strings?
LEFT
TRIM
SUM
✓
CONCAT
Correct Answer
SUM
CONCAT, LEFT, and TRIM are all functions primarily used for manipulating text strings. SUM performs mathematical aggregation on numbers.
Question 8
Which of these refers to a specific cell or range of cells in an Excel formula, but is NOT a type of absolute or relative cell reference?
A1
A$1
MyDataRange
✓
$A$1
Correct Answer
MyDataRange
A1, $A$1, and A$1 are all types of A1-style cell references (relative, absolute column/row, mixed). MyDataRange is a named range, which is a descriptive name given to a cell or range, not a direct cell reference type.
Question 9
Which of these Excel functions does not require specifying a column or row index number?
VLOOKUP
INDEX
HLOOKUP
XLOOKUP
✓
Correct Answer
XLOOKUP
VLOOKUP and HLOOKUP explicitly require a column index number for the return value. INDEX requires row and column numbers to retrieve a value from a given range. XLOOKUP uses a separate return array, not a column index number.
Question 10
Which of these Excel chart types is NOT typically used to compare values across different categories?
Radar chart
Bar chart
Line chart
✓
Column chart
Correct Answer
Line chart
Column, Bar, and Radar charts are all commonly used to compare values across distinct categories. A Line chart is typically used to show trends or changes over time or across an ordered sequence.
Question 11
Which of these Excel tools is NOT primarily used for consolidating or combining data from multiple sources or ranges?
Text to Columns
✓
Get & Transform Data
Power Query
Consolidate
Correct Answer
Text to Columns
Consolidate, Power Query, and Get & Transform Data are all features designed to combine or consolidate data from various sources or ranges. Text to Columns is used to split data within a single column into multiple columns.
Question 12
Which of these Excel functions is NOT designed to operate on a range of cells to return a single aggregated value?
IF
✓
SUM
AVERAGE
COUNT
Correct Answer
IF
SUM, AVERAGE, and COUNT are all functions that take a range of cells and return a single aggregated value. IF performs a logical test and returns one of two specified values, but does not aggregate a range.
Question 13
Which of these is NOT a data type that Excel can natively recognize and store within a cell?
Number
Image
✓
Date
Text
Correct Answer
Image
Number, Text, and Date are fundamental data types that Excel cells can natively contain and interpret. An Image is an object that can be inserted onto a worksheet, but it is not a data type stored directly within a cell.
Question 14
Which of these Excel features is NOT primarily about protecting or controlling access to worksheet content?
Protect Workbook
Cell Locking
Protect Sheet
Freeze Panes
✓
Correct Answer
Freeze Panes
Protect Sheet, Protect Workbook, and Cell Locking are all features used to control editing access or prevent changes to worksheet content. Freeze Panes keeps specific rows or columns visible while scrolling, which is a view control feature, not a protection feature.
Question 15
Which of these Excel features is NOT primarily used to interactively filter or display subsets of data?
Timeline
What-If Analysis
✓
Filter
Slicer
Correct Answer
What-If Analysis
Slicer, Filter, and Timeline are all interactive tools used to filter or display specific subsets of data. What-If Analysis tools (like Goal Seek, Scenario Manager, Data Tables) are used for exploring different outcomes based on changing inputs, not for interactive data filtering.