# Since vacation travel is a discretionary expense, consumers want to make the most out of the money they have budgeted. They often check travel websites for hotel ratings before making any reservations. A popular travel website offers travelers the opportunity to rate a hotel experience based on five categories: Excellent, Very Good, Average, Poor, and Terrible. Use the spreadsheet to

Chapter 1, Application 1.6 #4

Since vacation travel is a discretionary expense, consumers want to make the most out of the money they have budgeted. They often check travel websites for hotel ratings before making any reservations. A popular travel website offers travelers the opportunity to rate a hotel experience based on five categories: Excellent, Very Good, Average, Poor, and Terrible. Use the spreadsheet to answer the questions below.

a. Write the spreadsheet formula that was used to calculate the amount in cell B7.
b. Write the spreadsheet formula that was used to calculate the amount in cell C3.
c. Write the spreadsheet formula that was used to calculate the amount in cell D5.
d. Write the spreadsheet formula that was used to calculate the amount in cell E6.
e. Describe what the amount in cell C5 means in the context of this problem.
f. Describe what the amount in cell D4 means in the context of this problem.
g. Describe what the amount in cell E3 means in the context of this problem.