CIS 105 - 2.11

Ford escape cannot have total rating of zero, what should be the formula for I14?

I14 =

What is the unit of power equal to 550 foot-pounds per second (745.7 watts)?

What is wrong with the Nissan Maxima's practicality rating?

• The Maxima is the worst car when it comes to practicality so it should be rated as a 0

• The range should be a value between 1-5

What is wrong with the Chevrolet Malibu's performance rating?

• The range should be a value between 1-5

• 
  The Malibu exceeds all other cars so it should be a 6 rating

The total ratings for all the cars seem too low out of 30, what could be the error?

• The formula is correct.

• The formula does not include the "looks" rating in the sum.

Cell I15 shows the maximum of all the ratings, but Honda Civic/Chevrolet Malibu has the maximum total, what is the correct formula?

• I15 = MAX(I9:I14)

• I15 = MAX(I4:I10)

• I15=MAX(I7:I10)

• I15 = MAX(I4:I14)

Ford escape cannot have total rating of zero, what should be the formula for I14?

I14 =