Lab Two

Intended topics:

VLOOKUP
INDIRECT
UPPER
LOWER
MID
LEN
IF

If name starts with J, then get 100 in the class. Otherwise, do a VLookUp

If grade is less than 60, give an F, otherwise give a B.

If second letter is an A, then make the entire name uppercase. Otherwise, make it lowercase.

Formula auditing tools

Homework:
In the online book, page 289, questions 23 - 27.