Analysis “2017-2020 Sales”

Companies need to be able to accurately predict their sales so that they can plan to have the correct amount of financial, human, information, and material resources on hand.
Using the following steps, create a spreadsheet using the sales data provided for 2017 through September 2020:

1. Add the word “Average” to the bottom of the “Year” column.
2. Calculate the average sales for every month. (Exclude December of 2019 from your calculation because it is an outlier.)
3. Format the chart using the “all borders” setting.
4. Set the format the “Year” and “Average” cells to bold.
5. Center the name of each month and set the format to bold.
6. Underline the heading of every column.
7. Set the alignment for the information in the first column to “right.”
8. Use the accounting format for all sales figures and remove any decimals.