All Quizzes
Random
Blog
Create / Edit Quiz
More
en
1
Login
Create Account
Take another quiz >
More Suggestions

Your Stats
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
Profile
Quizzes
Subscribed
Subscribe?
Rate:
More quiz info >>
First submitted
March 30, 2015
Last updated
March 30, 2015
Times taken
36
Quiz and answer stats >>
Start Quiz
4:00
Give Up?
Enter answer here
0
/ 8 guessed
Pause Timer
Take Untimed
Show Help
The quiz is paused. You have
remaining.
Resume
Scoring
You scored
/
=
%
This beats or equals
% of test takers
The average score is
Your high score is
Your best time is
remaining
more stats >>
Keep scrolling down for answers and more stats ...
Retake Quiz
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.
Add comment
New and Popular
de
en
es
fr
it
pt
3,189
Category Elimination  Countries #2
1,680
6Letter History Chain #2
1,175
Turkey AZ
1,167
Countries of the World Quiz
618
Category Elimination  Countries #3
472
Countries by Consonants
413
Countries by First Two Letters in 90 Seconds
258
Country Word Search
255
Countries with more than 200 Million People
254
Countries Closest to Canada
252
Digits of Pi
251
Countries of the World with an Empty Map
244
Asia Map Quiz
121
100 BestReviewed Animated Films
102
X Answers Quiz
?
Random