Read the brief case below. Using the Excel spreadsheet provided, complete the

questions.

Downtown Office Supply

Downtown Office supply is a small family owned store in a small suburb. In order to

maintain and grow the business the owners want to do some analysis to see how their

sales are doing. Management wants to see how the company did last year and make

some decisions about what products to keep along with staffing for busy times of the

year.

Instructions: In the excle spreadheet provided, complete the tasks below. Upon

completion you will submit a single, completed, Excel workbook.

Setup the spreadsheet with proper formatting and formulas so it can be presented to

management. $(12$ points: $2$ point each$)$

a$.$ Change the tab called "Quarterly" to $"$Q$1-$ Quarterly" and move the tab to the

first position.

b$.$ Add a column to calculate the total for each product. Use the SUM function.

c$.$ Add rows to calculate the Total, Average and Median sales for each quarter.

Use the SUM, AVERAGE, and MEDIAN functions.

d$.$ Format the title at the top so it stands out. Add distinct formatting to the

column and row headings. Format the data in the cells to show currency.

e$.$ Format the total sales column to have a green background.

f$.$ Create a bar chart showing for each product $($a$)$ the total sales for the year

and $($b$)$ the proportion of the total contributed by each quarter's sales. This

should be shown in one. You should have $1$ bar for each product. Add a title

to your chart.

Management would like to decide whether they should discontinue any products.

Any product which has had $50\%$ less sales over the previous year should be

discontinued. Are there any products that they should discontinued? List the

product$($s$)$ and your recommendation in the worksheet. Which $3$ products had the

highest increase in sales? $(12$ points: $2$ points each$)$

a$.$ Change the tab called $2017$ vs $2018$ to Q$2-2017$ vs$.2018$ and move the tab to

the second position.

b$.$ Add a new column to calculate the percentage change from $2017$ to $2018.$

Percentage change is computed using the following formula: $($current year