Using the IF Function in Excel


Choose an answer and hit 'next'. You will receive your score and answers at the end.

question 1 of 3

Which of the following is the correct formula for the IF function in Excel?

Create Your Account To Take This Quiz

As a member, you'll also get unlimited access to over 79,000 lessons in math, English, science, history, and more. Plus, get practice tests, quizzes, and personalized coaching to help you succeed.

Try it risk-free
Try it risk-free for 30 days. Cancel anytime
Already registered? Log in here for access


If the cell B2 is 68, what will this IF function give you as a result?

=IF (B2>60, ''pass'', ''fail'')

2. What do you need to include when you are entering text into your formula?

Create your account to access this entire worksheet
A Premium account gives you access to all lesson, practice exams, quizzes & worksheets
Access to all video lessons
Quizzes, practice exams & worksheets
Certificate of Completion
Access to instructors
Create an account to get started Create Account

About This Quiz & Worksheet

This quiz/worksheet involves questions centered around the reading and operating of Excel's IF function, allowing you to make sure you have your bases covered when it comes to this aspect of the program.

Quiz & Worksheet Goals

To test your understanding, you'll be asked questions pertaining to:

  • The IF function's formula
  • Effects of the IF function on data
  • Which IF functions describes whether an item is over $100 in a given example
  • Interpreting IF functions

Skills Practiced

  • Interpreting information - verify that you can read information about what IF functions describe and interpret it correctly
  • Knowledge application - use your knowledge to match data with the appropriate IF function
  • Information recall - access the knowledge you've gained regarding the formula for the IF function

Additional Learning

To learn more about this part of Excel, review the accompanying lesson titled Using the IF Function in Excel. This lesson incorporates the following objectives:

  • Understand the purposes of Excel
  • Know what the IF function does within Excel
  • See the IF function in action through a provided example