a) Complete formulas to calculate total sales for both row 9 and column G for all quarterly sheets at one time. To do this, select multiple worksheets to complete the actions simultaneously.

b) Using 3D Cell Referencing, 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).

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

C19 A xv fx A B D E F G 1 TVS Total Sales 2 3 Location 4 Store 1 5 Store 2 6 Store 3 7 Store 4 8 Store 5 9 Total Sales 10 11 12 Premium Purchase Electronics Sales, Quarter 4 2016 Computers Video Games Cellular Phones 13,586 13,310 13,152 14,480 10,345 14,946 10,175 10,700 13,440 12,345 12,039 10,859 13,792 13,799 10,190 8,974 14,881 11,329 14,189 14,942 Misc. Sales 5,399 6,786 6,316 7,094 5,664 Office Update To keep up-to-date with security updates, fixes, and improveme H12 X fx H A B D E F 1 Premium Purchase Electronics 2 Sales, Year of 2016 3 Location TVS Computers Video Gam Cellular Ph Misc. Sales Total Sales 4 Store 1 5 Store 2 6 Store 3 7 Store 4 8 Store 5 9 Total Sales 10 11 12 13 14 15 16 17 C19 A xv fx A B D E F G 1 TVS Total Sales 2 3 Location 4 Store 1 5 Store 2 6 Store 3 7 Store 4 8 Store 5 9 Total Sales 10 11 12 Premium Purchase Electronics Sales, Quarter 4 2016 Computers Video Games Cellular Phones 13,586 13,310 13,152 14,480 10,345 14,946 10,175 10,700 13,440 12,345 12,039 10,859 13,792 13,799 10,190 8,974 14,881 11,329 14,189 14,942 Misc. Sales 5,399 6,786 6,316 7,094 5,664 Office Update To keep up-to-date with security updates, fixes, and improveme H12 X fx H A B D E F 1 Premium Purchase Electronics 2 Sales, Year of 2016 3 Location TVS Computers Video Gam Cellular Ph Misc. Sales Total Sales 4 Store 1 5 Store 2 6 Store 3 7 Store 4 8 Store 5 9 Total Sales 10 11 12 13 14 15 16 17