Question: 2 2 . 6 % In cell G 6 , enter a formula that calculates the Discount Rate for the Off - Peak rental price

22.6%
In cell G6, enter a formula that calculates the Discount Rate for the Off-Peak rental price per day.
You created formulas for the Peak Rentals Maximum Revenue, Off-Peak Rentals Maximum Revenue, and the Discount Rate for the Off-Peak Rentals for the Studio Apartment rental type. Now you want to copy the formulas to the remaining rental types so that you don't have to create formulas again.
Copy the formula in cell D6 to cells D7:D9. Copy the formula in cell F6 to the range F7:F9. Copy the formula in cell G6 to cells G7:C9.
The values in the columns are hard to read with varying numbers of decimal points. The Accounting Number Format will align the decimal points and display dollar signs to improve the appearance of the monetary values.
Format the range C6:F9 with Accounting Number Format.
The Discount Rate formula results are displayed as decimal values. However, formatting the values as percentages will align decimal points and clearly indicate the percentages.
Format the range G6:G9 in Percent Style with one decimal place.
You applied a solid blue to the Off-Peak Rentals heading, so you will apply a complementary lighter blue fill color to the data below that heading-
Apply Blue, Accent 5, Lighter 80% fill color to the range E5:G9.
 22.6% In cell G6, enter a formula that calculates the Discount

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!