Exhibit 14.8
The following questions use the information below.
A company needs to buy a new insurance policy. They have three policies to choose from, A, B and C. The policies differ with respect to price, coverage and ease of billing. The company has developed the following AHP tables for price and summary. The other tables are not shown due to space limitations.
-Refer to Exhibit 14.8. What formula should go in cell F11 and get copied to F12:F13 of the Price worksheet to compute the Price Score?
A) =AVERAGE(C4:C6)
B) =AVERAGE(C11:E11)
C) =AVERAGE(G11:G13)
D) =AVERAGE(C7:E7)

Question

Exhibit 14.8
The following questions use the information below.
A company needs to buy a new insurance policy. They have three policies to choose from, A, B and C. The policies differ with respect to price, coverage and ease of billing. The company has developed the following AHP tables for price and summary. The other tables are not shown due to space limitations.  
-Refer to Exhibit 14.8. What formula should go in cell F11 and get copied to F12:F13 of the Price worksheet to compute the Price Score?
A) =AVERAGE(C4:C6) 
B) =AVERAGE(C11:E11) 
C) =AVERAGE(G11:G13) 
D) =AVERAGE(C7:E7)

Quizplus · Accepted Answer

The correct formula to compute the Price Score by averaging the values across a row (from columns C to E for a specific row) is =AVERAGE(C11:E11). This formula correctly averages the values in cells C11, D11, and E11 for the Price worksheet, and can be copied to rows 12 and 13 to calculate the Price Score for those rows as well.

Exhibit 14.8 The Following Questions Use the Information Below