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.