Take another quiz >

Excel functions containing 'IF'

Can you name all Excel functions that contain 'IF'? They are listed in alphabetical order
List from here
Quiz by scambigol
Rate:
Last updated: March 30, 2015
First submittedMarch 30, 2015
Times taken40
4:00
Enter answer here
0
 / 8 guessed
The quiz is paused. You have remaining.
Scoring
You scored / = %
This beats or equals % of test takers also scored 100%
The average score is
Your high score is
Your fastest time is
Keep scrolling down for answers and more stats ...
Function
Description
AVERAGEIF
Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria
AVERAGEIFS
Returns the average (arithmetic mean) of all cells that meet multiple criteria.
COUNTIF
Counts the number of cells within a range that meet the given criteria
COUNTIFS
Counts the number of cells within a range that meet multiple criteria
IF
Specifies a logical test to perform
IFERROR
Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula
SUMIF
Adds the cells specified by a given criteria
SUMIFS
Adds the cells in a range that meet multiple criteria
No comments yet.