Statistics for Excel functions containing 'IF'

Click here to take the quiz!

Function	Description	% Correct
IF	Specifies a logical test to perform	95%
COUNTIF	Counts the number of cells within a range that meet the given criteria	80%
SUMIF	Adds the cells specified by a given criteria	80%
AVERAGEIF	Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria	73%
COUNTIFS	Counts the number of cells within a range that meet multiple criteria	68%
IFERROR	Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula	68%
SUMIFS	Adds the cells in a range that meet multiple criteria	68%
AVERAGEIFS	Returns the average (arithmetic mean) of all cells that meet multiple criteria.	63%

You have not taken this quiz