Question 6 (4 points) Saved Using a reference to the tax rate in cell 15, determine the Total Cost (with tax) charged to each customer. Remember that government contracts are not charged tax, but all other contracts are! Start by entering the formula in the first row and then copy it down for all of the Service Calls. The total cost (with tax) for the first customer in the table is: None of these $200.65 $198.34 $246.14 $244.56 Question 7 (5 points) Saved Enter an appropriate formula to calculate the Total Charges for All Customer Service Calls (with tax) in cell F2 above the table. The total charges for all service calls (with tax included) is: 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 %