You Are Planning to Work as a Restaurant Host/hostess for the Next

question 65

Essay

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.)