Develop, explain, and implement two different creative examples using first a financial function and second, one which uses “nested functions”; on excel another way of questions
Find the various collections of pre-set functions on the Formulas tab (such as financial, logic, other, etc), open each set , browse the function names and open some you think might be useful but at least one has to be the NPV function and one the IF function.
Read what the function does and open several of the “help on this function” links and read that file (including NPV).
In a worksheet, click on fx and find one of the functions you looked up and implement it (using any values you want).
Nesting functions: Puts one preset function inside another (see bottom page 472-473)
With reference to exercise 2 above, create a nested IF statement where the logical test is whether B1 is less than A1. If that is true, you want Excel to enter the Average of the two cells; if it is false you want it to enter the text word Wrong .
its from a book called business analysis the art of modeling with spreadsheets.