Guest House Rental Rates

You manage a beach guest house in $Ft.$ Lauderdale containing three types of rental units. Prices are based on peak and off$-$peak times of the year. You need to calculate the maximum daily revenue for each rental type, assuming all units are rented. In addition, you need to calculate the discount rate for off$-$peak rental times. Finally, you will improve the appearance of the worksheet by applying font. alignment, and number formats.

a$.$ Open e$01$m$2$Rentals and save it as $001m2Rental{s}_{?}$ LastFirst.

b$.$ Merge and center Peak Rentals in the range C$4$:D$4,$ over the two columns of peak rental data. Apply Dark Red fill color and White, Background $1$ font color.

c$.$ Merge and center Off$-$Peak Rentals in the range E$4$:G$4$ over the three columns of off$-$peak rental data. Apply Blue fill color and White, Background $1$ font color.

d$.$ Center and wrap the headings on row $5.$ Adjust the width of columns D and F$,$ if needed. Center the data in the range $B6$:$B8.$

e$.$ Create and copy the following formulas:

Calculate the Peak Rentals Maximum Revenue by multiplying the number of units by the peak rental price per day.

Calculate the Off$-$Peak Rentals Maximum Revenue by multiplying the number of units by the off$-$peak rental price per day.

Calculate the Discount 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 $75\%$ of its peak rental rate. However you need to calculate and display the off$-$peak discount rate, which is $24975.$

f$.$ Format the monetary values with Accounting Number Format. Format the Discount Rate for mula results in Percent Style with one decimal place.

g$.$ Apply Blue, Accent $1,$ Lighter $80\%$ fill color to the range E$5$:G$8.$

h$.$ Select the range C$5$:D$8$ and apply a custom color with Red $242,$ Green $220,$ and Blue $219.$

i$.$ Answer the four questions below the worksheet data. If you change any values to answer the qu tions, change the values back to the original values.

j$.$ Set $1^{\text{'}\text{'}}$ top, bottom, left, and right margins. Center the data horizontally on the page.

k$.$ Insert a footer with your name on the left side, the sheet name code in the center, and the file n code on the right side.

I. Create a copy of the Rental Rates worksheet, place the new sheet to the right side of the ori worksheet, and rename the new sheet Formulas. On the Formulas worksheet, select Lands orientation and the options to print gridlines and headings. Delete the question and answer tion on the Formulas sheet.

m$.$ Open the Excel Options dialog box while displaying the Formulas worksheet. In the Adv category, under Display options for this worksheet:, select the Show formulas in cells inst their calculated results check box. This option will make sure the active worksheet will the formulas when you open the workbook again. The Rental Rates worksheet will continue ing the results. Adjust column widths so that the data will fit on one page.

n$.$ Save and close the file, and submit based on your instructor's directions.

How do i solve the last paer of step