Practice If (2.6) - Spreadsheet – Functions and Charts

Practise this section

9 questions

Flashcard drill
2 cards from this section. Quick, good the night before a test.
Exercise
6 questions · about 4 min · pass mark 70%. Hints available.
Sign up to start the exercise
Quiz
3 questions · about 2 min · pass mark 70%. Hints available.
Sign up to start the quiz

6 sample questions

Question 1.
What does the IF function do?
Show hintHide hint
Think about a simple pass/fail scenario.
Question 2.
Identify the parts of the IF function: =IF(B1>10, 'Yes', 'No').
Show hintHide hint
Remember the syntax structure.
3Question 3.
What is the correct syntax for the IF function in Excel?
- IF(condition, value_if_true, value_if_false)
- IF(value_if_true, condition, value_if_false)
- IF(value_if_false, value_if_true, condition)
Show hintHide hint
Remember the order of evaluation.
4Question 4.
True or False: The IF function can only return numerical values.
- True
- False
Show hintHide hint
Consider what else might be returned in a function.
Question 5.
Develop an IF function that categorizes expenses based on whether they exceed a budget of $1000.
Show hintHide hint
Determine suitable comparisons.
Question 6.
Write a nested IF function to determine a discount based on purchase amount in cell A1: 10% for over $100, 5% for over $50, and no discount otherwise.
Show hintHide hint
Think about how to layer conditions logically.

5 more questions in this section. Enroll free to practise them all.