Excel Functions
6 reference items
Which function adds all the numbers in a range of cells?
A
SUM
Explanation
The SUM function adds up all selected numeric values in a specified cell range.
Which function returns the arithmetic mean of a range of numbers?
A
AVERAGE
Explanation
The AVERAGE function calculates the arithmetic mean of the specified cells.
Which basic function counts the number of cells containing numbers?
A
COUNT
Explanation
The COUNT function calculates how many cells in a range contain numbers.
Which legendary Excel function searches for a value in the first column?
A
VLOOKUP
Explanation
VLOOKUP (Vertical Lookup) searches for a target value in the first column of a table.
Which function returns one value if true and another if false?
A
IF
Explanation
The IF function performs a conditional test, returning different values based on the result.
Which modern function combines searching both vertically and horizontally?
A
XLOOKUP
Explanation
XLOOKUP is the modern, powerful successor to both VLOOKUP and HLOOKUP.