Question 4 (4 points) Saved Enter an appropriate formula to calculate the Total Charges for All Customer Service Calls (without tax) in cell F1 above the table. The total charges for all service calls (without tax) is: $24,642.83 $20,083.26 $24,025.77 $22,938.49 None of these $20,828.10 Question 5 (2 points) Saved Some of Green Lawns' customers are government contractors. The State of Ohio recently nassed legislation that exempts government contracts from tax liability on Paste AY Merge & Center $ % ) ad - Conditional Format Formatting as Table Cell Styles LA F A1 foc fr B D E F G H K Total Charges for All Service Calls (without tax): Total Charges for All Service Calls (with tax): Code 1 2 Lookup Table Status Non-Government Government Sector Private Public Tax Rate 7% Service Hours Total Cost (w/o tax) Gov't Contract? Total Cost (with tax) Gov't Code 1 1 1 1 1 1 1 1 2 3 3 4 4 5 6 7 Customer 8 vase, Jason 9 vdams, Aaron 10 Nderks, David 11 Nexander, Velinda 12 Anderson, Alvin 13 nderson, Katherine 14 laker, Jean 15 larr, Deborah 16 lartlett, Emily 17 laxter, Nichelle 18 leler, Deborah 19 lexfield, Christopher 20 bills, Tamara 21 Hack, Brian 22 Blatter, Therron 23 Maylock, Glenn 24 Iradfield, Todd 25 ray, E. Lee 26 Briges, Kristen 27 Irinkerhoff, Alonzo 28 lushman, Michelle 29 Call, Lisa 30 Carling, Gregory 31 Chandler, Matthew 32 Christiansen, David 33 urtice, Brian 34 bangerfield, Anne 35 Dewey, John 36 Diazconti, Concepcion 37 Durrant, Camille 38 butson Sarah 1 1 1 1 1 1 1 Last Service Date Base Fee 8/22/12 $ 43.20 8/20/12 $ 21.33 8/19/12 $ 41.55 8/7/12 $ 31.67 8/23/12 $ 44.10 8/17/12 s 26.02 8/20/12 $ 33.85 8/31/12 $ 36.86 8/15/12 $ 31.60 8/20/12 $ 28.96 8/12/12 $ 37.97 8/11/12 $ 29.82 8/3/12 $ 27.46 8/20/12 $ 34.49 8/29/12 $ 42.96 8/21/12 $ 37.80 8/5/12 $ 21.25 8/5/12 $ 27.34 8/29/12 $ 29.29 8/31/12 $ 26.99 8/22/12 $ 21.90 8/29/12 $ 43.23 8/10/12 $ 23.13 8/17/12 $ 29.74 8/23/12 $ 27.10 8/18/12 $ 23.14 8/6/12 $ 42.94 8/29/12 $ 35.85 8/5/12 $ 37.03 8/12/12 $ 43.10 8/29/12 s 32 34 Hourly Rate 11.2 $ 16.55 8.4 $ 28.41 5.5 $ 29.06 10.8 $ 25.30 7.6 $ 14.73 7.9 $ 28.87 7.8 $ 11.63 10.9 $ 11.76 11.9 $ 17.41 3.6 S 28.05 7.9 $ 16.70 10.3 $ 15.53 10.5 $ 30.91 9 $ 29.37 3.3 $ 30.35 11.5 $ 23.02 1.7 $ 25.70 4.2 $ 25.62 4.8 $ 27.48 4.1 $ 19.46 7.5 $ 13.64 8.3 $ 16.92 2.1 $ 12.90 1.5 $ 26.14 9.4 $ 27.11 6.4 $ 27.79 3 $ 3 13.33 6.6 $ 28.10 7 $ 12.02 20.09 118 27.49 1 1 2 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1 . 10.4 %