Statistics for Excel functions containing 'IF'

Click here to take the quiz!

General Stats

  • This quiz has been taken 58 times
  • The average score is 6 of 8

Answer Stats

FunctionDescription% Correct
IFSpecifies a logical test to perform
96%
COUNTIFCounts the number of cells within a range that meet the given criteria
85%
SUMIFAdds the cells specified by a given criteria
85%
AVERAGEIFReturns the average (arithmetic mean) of all the cells in a range that meet a given criteria
74%
COUNTIFSCounts the number of cells within a range that meet multiple criteria
70%
SUMIFSAdds the cells in a range that meet multiple criteria
70%
AVERAGEIFSReturns the average (arithmetic mean) of all cells that meet multiple criteria.
63%
IFERRORReturns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula
61%

Score Distribution

Percentile by Number Answered

Percent of People with Each Score

Your Score History

You have not taken this quiz