Exam 16: Excel 2007 Unit B: Working With Formulas and Functions

As shown in the figure above, item 2 points to the ____.

You CANNOT insert a function as part of another formula.

In the reference $C14, ____.

$A$1 is an example of a(n) ____.

You are planning to work as a restaurant host/hostess for the next 6 months. During this time you plan to save 15 percent of your projected earnings each month. You want to use a worksheet to calculate how your existing savings will grow each month. So far, you have created the following worksheet. You want to use Excel to track your earnings throughout the six months you will work. Each month, you would like to know your total savings for all the months you have worked. Using the above figure as a reference, what formula would result in tracking total earnings? Describe the formula you would use for January and February, and explain how you would go about entering the data. (Assume column C reads 15% and column D has been automatically calculated to show earnings per month.)

An Excel formula can include more than one operation; for example, multiplication and addition.