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:
Nominate?
Nominated
see leaders
Last updated: March 30, 2015
More quiz info >>
First submitted
March 30, 2015
Times taken
40
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
also scored 100%
The average score is
Your high score is
Your fastest time is
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
5,891
Countries in Random Squares of the World Map
3,270
Southern Things Quiz
2,772
Biggest French Empire Countries
945
US States Quiz
618
Countries by First Two Letters in 90 Seconds
524
Fast Typing A to Z
500
Countries Bordering Germany
495
U.S. Presidents Quiz
494
Seas on the World Map
493
Animals A-Z #1
488
Word Scramble - Countries
483
History of Egypt
481
Countries of the World with an Empty Map
266
General Knowledge Quiz #122
238
Biggest Cities in the World - Extreme
?
Random