Menu
Create
Random
Create Account
Login
0
0
0
Language
Deutsch
Español
Français
Italiano
Nederlands
Polski
Português
Suomi
More...
Search...
Featured Quizzes
All Featured Quizzes
New and Reset
Random
Top Today
Geography
History
User Quizzes
Most Recent
All User-Created
Tags
Highest Rated
Most Taken
Nominated Quizzes
Recent Spotlights
Create Quiz
Create / Edit Quiz
New Text Quiz
New Picture Quiz
New Click Quiz
New Click Map Quiz
New Multiple Choice
New Tile Select
SVG Guide
Data and Charts
JetPunk Charts
Recent Charts
Create Chart
Info Pages
Country Population
Interesting Facts
Interesting Quotes
Blogs
Official Blog
User Blogs
Recent User Blogs
Blogs by Tag
Create Blog
Badges and Games
Badges
Word Search
Minigames
Social
Reddit
Discord
Twitter
Instagram
About JetPunk
About Us
Contact Us
JetPunk Premium
Change Log
Terms of Service
Planting Trees
JetPunk Shop
Dark Mode
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
Spotlight
+ Playlist
Last updated: March 30, 2015
You have not attempted this quiz yet.
More quiz info >>
First submitted
March 30, 2015
Times taken
105
Average score
75.0%
Report this quiz
Report
Quiz and answer stats >>
Friends stats >>
Start Quiz
4:00
Give Up?
Enter answer here
0
/ 8 guessed
Time Used
00:00
Best Time
00:00
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 >>
friends stats >>
Keep scrolling down for answers and more stats ...
Retake Quiz
Share Result
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
Comments
No comments yet
Add comment
New and Popular
all
de
en
es
fi
fr
it
nl
pl
pt
Countries of the World Quiz
US States Quiz
All Country Flags of the World
Countries by First Two Letters in 90 Seconds
Europe Map Quiz
United States Map Quiz
Countries of Europe Quiz
U.S. Presidents Quiz
General Knowledge Quiz #9
Europe Capitals Quiz
Countries of Asia Quiz
World Map with Random Merged Countries
Biggest Countries by Population
Countries of Africa
12 x 12 Multiplication Table in 2 Minutes
Random
Top Today
Save Your Progress
Create Account