14. If the contents of Excel cell B4 is = Comparison! C5+$D$6 and that contents is copied to E8, what would the new formula be? a. = Comparison!F8 + \$D\$6 b. = Comparison!F9 + \$D\$6 c. = Comparison!E9 + \$G\$10 d. =E8+D6 e. = Comparison!F9 + D6 15. A delivery company charges delivery rates based on the weight of the package. For packages weighing less than 1kg, the charge is $1.50. If the package is 1kg or more but less than 5kg, the charge is $3.75. Packages 5kg and over are charged $6.95. Assume that the weight is entered into Excel cell F8. Which of the following correctly gets Excel to determine the charge? a. =1f(F85,6.95) b. =if(E8>5,6.95, if (E8