Please discuss the purpose and how to apply Nested IF functions in Excel. Nested IF functions, meaning one
IF function inside of another, allows you to test multiple criteria and increases the number of possible
outcomes. Also, provide one visual application in Excel as to how a Nested IF function is applied. You can
make up the data or example.