Quizzes
More
Create
en
-1

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
More quiz info >>
First submittedMarch 30, 2015
Times taken54
Report this quizReport
Quiz and answer stats >>
Friends stats >>
4:00
Give Up?
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
Copyright H Brothers Inc, 2008–2021
View Mobile Site