1 Truck Purchase Analysis \# Description Truck 1 Truck 2 Truck 3 Truck 4 Yearly Costs Need toan? Monthly Costs IIHS Safety Rating Lookup Chart Large and Small Pickups 6. Look up the Vehicle Safety Rating for each truck listed. a. Enter a formula in cell C15 to look up the vehicle safety rating for the first truck. Use the truck name in cell C3 as the Lookup_value argument. Use the SafetyRatings named range as the Table_array argument. The ratings are located in column 2 of the data table. Require an exact match. b. Copy the formula to the appropriate cells for the other trucks