INFORMATICS HW3
February 19th, 2023
This homework has 3 parts.In Part-1, you will explain how VLOOKUP works, In Part-2, you will explain how an IF statement worksIn 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.