Employee Sales Summary sheet (Note: Do not make any changes to the Employee Sales October, November, or December sheets).

1. Replace the Sales value for Deniz Alpada (E5) with a 3D cell reference function that will add together all her sales on the October, November, December sheets. (Be sure you are completing this formula on the Summary sheet and not on the other sheets. Use the other sheets in your 3D function).

2. Take this function (E5) and copy it down for all the other employees. Re-size columns if necessary.

3. Do the same thing for Deniz Alpadas Properties (F5). Use the 3D cell reference function that will add together the number of properties from the October, November, December sheets. 4. Take this function (F5) and copy it down for all the other employees.

5. Create a Total row by first typing in the word Total in cell A17, then use a function(SUM) to total up columns E and F (The functions should be in cells E17 and F17 respectively). 6. Increase the column widths to show all numbers if necessaryIf the bottom border in column E or F is missing, put it back in

Please show your work. Thanks

A B E F 1 Properties 1 2 W N Hermes Estate Sales 2 Employee Sales: Summary 4th Qtr 3 4 Employee ID First Name Last Name Location Sales 5 201 Deniz Alpada Los Angeles $350,000 6 202 Emily Orange County $385,000 7 203 John Choi Los Angeles $264,000 8 204 Chris Murphy Orange County $399,000 205 Norm Gibson Orange County $321,000 10 206 Jessica Mok Orange County $345,000 11 207 Ada Peters Los Angeles $285,000 12 208 Phil Jackson Los Angeles $401,000 13 209 Jam Kirk Los Angeles $324,000 14 210 Pam Nguyen Orange County $433,000 15 211 Chris Wetzel Orange County $452,000 16 212 Jan Jones Los Angeles $213,000 17 4 5 6 7 8 9 10 11 12 B F 1 A D E Hermes Estate Sales 2 Employee Sales: October 3 4 Employee ID First Name Last Name Location Sales 5 201 Deniz Alpada Los Angeles $395,000 6 202 Emily Orange County $385,000 7 203 John Choi Los Angeles $264,000 8 204 Chris Murphy Orange County $399,000 9 205 Norm Gibson Orange County $321,000 10 206 Jessica Mok Orange County $345,000 11 207 Ada Peters Los Angeles $285,000 12 208 Phil Jackson Los Angeles $401,000 13 209 Jam Kirk Los Angeles $324,000 14 210 Pam Nguyen Orange County $433,000 15 211 Chris Wetzel Orange County $452,000 16 212 Jan Jones Los Angeles $213,000 Properties 1 1 1 1 1 1 1 N 1 NW 1 Properties 1 1 1 A D E 1 Hermes Estate Sales 2 Employee Sales: November 3 4 Employee ID First Name Last Name Location Sales 5 201 Deniz Alpada Los Angeles $280,000 5 202 Emily Orange County $294,000 7 203 John Choi Los Angeles $285,000 3 204 Chris Murphy Orange County $311,000 3 205 Norm Gibson Orange County $300,000 206 Jessica Mok Orange County $214,000 1 207 Ada Peters Los Angeles $231,000 2 208 Phil Jackson Los Angeles $234,000 3 209 Jam Kirk Los Angeles $431,000 4 210 Pam Nguyn Orange County $231,000 5 211 Chris Wetzel Orange County $321,000 6 212 Jan Jones Los Angeles $332,000 7 2 1 1 om in 1 1 2 1 1 1 F 2 3 Properties 1 2 1 A B D E 1 Hermes Estate Sales Employee Sales: December 3 4 Employee ID First Name Last Name Location Sales 5 201 Deniz Alpada Los Angeles $351,000 6 202 Emily Orange County $345,000 7 203 John Choi Los Angeles $255,000 204 Chris Murphy Orange County $341,000 9 205 Norm Gibson Orange County $332,000 10 206 Jessica Mok Orange County $354,000 11 207 Ada Peters Los Angeles $299,000 12 208 Phil Jackson Los Angeles $398,000 13 209 Jam Kirk Los Angeles $235,000 14 210 Pam Nguyen Orange County $432,000 211 Chris Wetzel Orange County $341,000 16 212 Jan Jones Los Angeles $302,000 1 1 oo O Om in NPN 1 2 2 1 1 17