This homework has 3 parts.
In Part-1, you will explain how VLOOKUP works,
In Part-2, you will explain how an IF statement works
In part-3, you will explain how a NESTED-IF works (include IF+IF+…, IF+AND and IF+OR)
The explanation has to be clear even to someone who has never heard about it before. Once you do this exercise you will be well prepared for Test-1, which is meant to test whether you understand the above 3 functions well.
The explanation must be in your own words – full points will be given only to those explanations that do a really good job. Poor quality submission and slipshod work, copy-paste etc., will receive a 0.