Show:
Nested IF
VLOOKUP
Fix the Formula
Real-Life Excel
Bonus Questions!
100

What is a Nested IF?

A formula with one IF function inside another IF function.

100

What does VLOOKUP stand for?


Vertical Lookup.

100

What is wrong with this formula?

=IF(A1>50,"Pass","Fail"

Missing closing bracket.

100

Which function would help find a student’s score quickly in a table?


VLOOKUP

100

How many arguments does VLOOKUP normally use?

4

200

What does an IF function return when a condition is TRUE?


One value/result.

200

What part of VLOOKUP tells Excel which column to return data from?


Column Index Number.

200

Fix this formula:

=IF(A1>=70,Good,Fail)

=IF(A1>=70,"Good","Fail")

200

Which function is best for assigning grades?


Nested IF

200

TRUE in VLOOKUP means:

- exact match?

- approximate match?

Approximate match

300

What grade should this formula return for a score of 88?

=IF(A1>=95,"A",IF(A1>=85,"B","C"))

B

300

Which value gives an exact match in VLOOKUP?


FALSE (or 0).

300

What is wrong with this formula?

=VLOOKUP("Bob",A2:B5,2)

Missing FALSE for exact match.

300

A teacher wants:

  • 75+ = Pass
  • Below 75 = Fail

Which function should they use?


IF function.

300

What is the output?

=IF(A1="","Empty","Done")

If A1 has no value

Empty

400

Write a formula:

  • 90 and above = “Excellent”
  • Below 90 = “Good”

=IF(A1>=90,"Excellent","Good")

400

In this formula, what does the number 3 mean?

=VLOOKUP(H3,B4:E13,3,FALSE)

Return data from the 3rd column.

400

Fix this Nested IF:

=IF(A1>=90,"A",IF(A1>=80,"B","C")

Missing closing bracket.

400

A store owner wants to find product prices from a table automatically.

Which function should they use?

VLOOKUP

400

Write a VLOOKUP formula to find Bob's score from A2:B5. 

=VLOOKUP("Bob", A2:B5,2,FALSE)

500

Why should Nested IF conditions start with the highest value first?


Because Excel checks conditions from top to bottom.

500

What must always be in the FIRST column of a VLOOKUP table?


The lookup value/search value.

500

What is wrong with this VLOOKUP?

=VLOOKUP(85,A2:B5,2,FALSE)


The lookup value must be in the first column.

500

Which function is better for checking MANY conditions: VLOOKUP or Nested IF?


Nested IF

500

What common mistake happens when quotation marks are missing in IF formulas?

Excel will not recognize the text properly/ formula error.