Recall & Review
beginner
What does the IFS function do in Excel?
The IFS function checks multiple conditions one by one and returns the value for the first condition that is TRUE. It helps avoid nested IF statements.
Click to reveal answer
beginner
Write the syntax of the IFS function.
IFS(condition1, value_if_true1, condition2, value_if_true2, ..., conditionN, value_if_trueN)<br><br>Each condition is tested in order. The function returns the value for the first TRUE condition.
Click to reveal answer
intermediate
How does IFS differ from nested IF statements?
IFS is simpler and cleaner because you list conditions and results in pairs without many parentheses. Nested IFs require multiple IF functions inside each other, which can be confusing.
Click to reveal answer
intermediate
What happens if none of the IFS conditions are TRUE?
If no condition is TRUE, IFS returns a #N/A error unless you add a final condition that is always TRUE (like TRUE) with a default value.
Click to reveal answer
beginner
Example: How to use IFS to assign grades based on scores?<br>Score >= 90: "A"<br>Score >= 80: "B"<br>Score >= 70: "C"<br>Score < 70: "F"
Use this formula:<br>=IFS(A1>=90, "A", A1>=80, "B", A1>=70, "C", TRUE, "F")<br><br>This checks each condition in order and returns the matching grade.
Click to reveal answer
What will the formula =IFS(A1>10, "High", A1>5, "Medium", TRUE, "Low") return if A1 is 7?
✗ Incorrect
Since 7 is not greater than 10, the first condition is FALSE. The second condition (A1>5) is TRUE, so it returns "Medium".
Which of these is a correct way to write an IFS function?
✗ Incorrect
Each condition must be followed by a value. Option B correctly pairs conditions and values.
What error does IFS return if no conditions are TRUE and no default is given?
✗ Incorrect
IFS returns #N/A error if no condition is TRUE and no default condition is provided.
Why might you use IFS instead of nested IFs?
✗ Incorrect
IFS simplifies writing multiple conditions without complex nesting, making formulas easier to read.
In the formula =IFS(A1>90, "A", A1>80, "B", TRUE, "C"), what does TRUE represent?
✗ Incorrect
TRUE as a condition always evaluates to TRUE, so it acts as a default if earlier conditions fail.
Explain how the IFS function works and how it can replace nested IF statements.
Think about checking conditions one by one and stopping at the first match.
You got /4 concepts.
Describe how to handle a situation where none of the IFS conditions are met.
Use a condition that always returns TRUE at the end.
You got /3 concepts.