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	89
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

US States by Borders in 30 Seconds

Fast Typing 1 to 100

Countries by Borders in 90 Seconds

12 Months in 15 Seconds

United States Map Quiz

Europe Map Quiz

Countries that Start with A

Countries that Start with M

Fast Math - Multiplication

Countries that Start with I

Brand Logos Quiz #1

Mythical Creatures Quiz #1

Brand Logos Quiz #5

Random

Top Today

Save Your Progress