Featured Quizzes
User Quizzes
Create Quiz
Data and Charts
Word Search
Flash Cards
Badges and Games
About JetPunk
Message Board
Dark Mode
Excel functions containing 'IF' - Statistics
General Stats
- This quiz has been taken 137 times
- The average score is 6 of 8
Answer Stats
| 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 | 81%
|
| SUMIF | Adds the cells specified by a given criteria | 81%
|
| AVERAGEIF | Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria | 77%
|
| COUNTIFS | Counts the number of cells within a range that meet multiple criteria | 70%
|
| IFERROR | Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula | 69%
|
| SUMIFS | Adds the cells in a range that meet multiple criteria | 69%
|
| AVERAGEIFS | Returns the average (arithmetic mean) of all cells that meet multiple criteria. | 67%
|
No matching quizzes found
Score Distribution
Percent of People with Each Score
Percentile by Number Answered
Your Score History
You have not taken this quiz