Explain, in your own words, how at least two (2) of the following functions (otherwise known as pre-defined formulas) work and how using these functions will improve efficiency. Provide examples to support your answer. (as a guide 100 words per function)
Nested IF statement
LookupPivot tables
Data validation