8 In cell G6, enter a formula that calculates the Discount
8.000
Rate for the Off-Peak rental price per day. For example, using the peak and off-peak per day values, the studio apartment rents for 80 % of its peak rental rate. However, you need to calculate and display the off-peak discount rate, which is. 19973.
9 Copy the formula in cell D6 to cells D7: D8. Copy the 4.000 formula in cell G6 to cells G7: G8.
10 Format the range C6: F8 with Accounting Number 6.000
Format.
11 Format the range G6: G8 in Percent Style with one 6.000 decimal place.
12 Apply Blue, Accent 1, Lighter 80 % fill color to the range 4.000
E5: G8.