Complete formulas to calculate total sales for both B9:G8 and G4:G9 for all quarterly sheets at one time. To do this, select multiple worksheets to complete the actions simultaneously.

You are concerned that one of the stores is not performing well in cellular phone sales. Use Conditional Formatting (either data bars or color scales), on cellular phone sales for all quarterly sheets. Place a comment on the Q4Sales sheet in cell E7 with your concern that it is regularly the lowest for cellular phone sales.

On the "2016 Sales" sheet, use 3D Cell Referencing to create a formula in B4 that will add the total sales for Store 1 TV sales from all 4 quarterly sheets. This reference must be a 3D reference (do not use individual cell references from each sheet separately).

Use the Fill Handle to copy the formula in B4 through G9 (total sales). HINT: If you do not have the right cell references in Step 4, this copy will not work.

Using format painter, copy the formatting from one of the quarterly sheets to the 2016 Sales sheet. Ensure that the formatting is the same to include fonts, numbers, colors, and column spacing.

Produce a graph showing the sales of all 5 locations for each product type (no totals). The type of graph can be your choice, but types that help the best are column or bar. Edit the chart title so that it clearly identifies what the chart is about.

Ensure your file is saved with the correct file name.

Premium Purchase Electronics
Sales, Quarter 1 2016
Location	TVs	Computers	Video Games	Cellular Phones	Misc. Sales	Total Sales
Store 1	10,618	13,596	12,375	14,545	7,295
Store 2	14,982	12,767	14,708	12,081	9,288
Store 3	11,350	13,602	12,471	12,792	8,604
Store 4	14,684	14,871	11,303	7,954	8,010
Store 5	12,032	13,286	11,486	11,647	9,991
Total Sales

Premium Purchase Electronics
Sales, Quarter 2 2016
Location	TVs	Computers	Video Games	Cellular Phones	Misc. Sales	Total Sales
Store 1	10,639	14,960	10,804	11,442	9,296
Store 2	14,952	14,511	10,911	12,337	5,275
Store 3	13,975	11,610	10,280	10,738	6,803
Store 4	12,871	12,560	11,551	8,245	8,163
Store 5	12,961	11,332	10,874	14,743	9,004
Total Sales

Premium Purchase Electronics
Sales, Quarter 3 2016
Location	TVs	Computers	Video Games	Cellular Phones	Misc. Sales	Total Sales
Store 1	11,027	10,691	14,113	12,384	9,673
Store 2	12,769	11,777	10,798	13,955	7,938
Store 3	12,602	10,190	13,562	11,165	8,484
Store 4	14,260	10,253	11,989	9,135	5,988
Store 5	13,564	11,085	10,814	11,412	5,972
Total Sales

Premium Purchase Electronics
Sales, Quarter 4 2016
Location	TVs	Computers	Video Games	Cellular Phones	Misc. Sales	Total Sales
Store 1	13,586	13,310	13,152	14,480	5,399
Store 2	10,345	14,946	10,175	10,700	6,786
Store 3	13,440	12,345	12,039	10,859	6,316
Store 4	13,792	13,799	10,190	8,974	7,094
Store 5	14,881	11,329	14,189	14,942	5,664
Total Sales

Premium Purchase Electronics
Sales, Year of 2016
Location	TVs	Computers	Video Games	Cellular Phones	Misc. Sales	Total Sales
Store 1
Store 2
Store 3
Store 4
Store 5
Total Sales