1. Use Excel to create an appropriate chart and spreadsheet from the scenario below. Place the chart on a separate sheet tab and rename both sheet tabs with names pertaining to the spreadsheet information. Change the color on both renamed sheet tabs to one of preference. Create a text box with a title and place on the top of the chart. Adjust the title as necessary (center). Ensure the text box is positioned within the chart as specified.

Format the chart by using Change format: chart elements by using the Format task pane or the ribbon. You can format the chart area, plot area, data series axes, titles, data labels, and so on.

Scenario

1. What is the formula to calculate how much a savings account would be worth if the initial balance is $1,000 with monthly deposits of $75 for 10 years at 4.3% annual interest compounded monthly? What is the formula result?