Discussion: Find Real-World Applications

In this discussion topic, you are asked to find practical examples to apply a few functionality in Excel that were presented in Module Three of the textbook.

IF Statement Think of examples of decisions people make each day. Then convert several (two to three) of those decisions into an IF statement/function. For example, =IF (exam grades > = 70, then return to school for another semester, otherwise wait tables at Bobs Burgers). Expand one of the examples into a nested IF statement.

What-If Analysis Describe two examples where Excel can be used to perform what-if analysis.

Goal Seeking Give an example in which goal seeking could be useful.

Sparklines Describe a worksheet data where its appropriate to use sparklines to illustrate data trends.