Excel functions containing 'IF'

Can you name all Excel functions that contain 'IF'? They are listed in alphabetical order

List from here

Quiz by

Rate:

Last updated: March 30, 2015

You have not attempted this quiz yet.

More quiz info >>

First submitted	March 30, 2015
Times taken	103
Average score	75.0%
Report this quiz	Report

Quiz and answer stats >>

Friends stats >>

4:00

Enter answer here

/ 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 
more stats >>
friends stats >>

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

Countries of the World Quiz

US States Quiz

U.S. Presidents Quiz

Fast Typing A to Z

Countries of the World with an Empty Map

Countries by First Two Letters in 90 Seconds

South America Map Quiz

Asia Map Quiz

Major League Baseball Teams

Countries of North America Quiz

Fresh Prince of Bel-Air Lyrics

Save Your Progress