Excel Project Office 2016-myitlab:grader- Instructions EX16 XL_CH01 _GRADER ML1 HW -Guest House Rental Rates 1.5 Project Description: 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 Instructions: For the purpose of grading the project you are required to perform the following tasks Points Step Instructions 1Start Excel. Download and open the file named eot grader h2.xx 2 Apply the Heading 1 cell style to the range A1:G1. | Apply the 20%-Accent 1 cell style to the range A2:02. 4 Merge and center Off-Peak Rentals in the range E4:G4. s Apply Blue il c olor (the eighth color below Standard Colors) and White, Background 1 font color to the cell E4. Center and wrap the headings on row 5. 6 In cell D6, enter a formula that calculates the Peak Rentals Maximum Revenue by multiplying the No. Units by the Per Day value. In cell G6, enter a formula that calculates 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 80% of its peak rental rate. However, you need to cal ulate and display the off-peak discount rate, which is 19973 9 Copy the formula in cell D6 to cells D7:D8. Copy the formula in cell G6 to cells G7-G8. Format the range C6:F8 with Accounting Number Format. 10 Updated: 01/19/2018 Current Instruction docx Office 2016- myitlab:grader -Instructions Excel Project Points Step Instructions 11 Format the range G6:68 in Percent Style with one decimal place. 12 | Apply Blue, Accent 1, Lighter 80% fill color to the range E5:08. Select the range CS:D8 and apply a custom fill color with Red 242, Green 220, and Blue 219 13Note, Mac users, in the Colors diakog box, dick the Color Sliders tab and then selot the RGB Sliders 14 Answer the frst question below the worksheet data. Aoly Yellow holiht colox to te corect in either cell A16, A17, or A18 Answer the second question below the worksheet data. Apply Yellow highlight color to the 15 correct answer in either cell A22, A23, or A24. Answer the third question below the worksheet data. Change XXX% to the correct percentage in cell A28. 16 Select Landscape orientation, center the data horizontally on the page, and apply the setting 17 to fit to one page. 18 Insert a footer with the text Exploring Series on the left side, the sheet name code in the 19 Create a copy of the Rental Rates worksheet, place the new sheet to the nght side of the 20 On the Formulas worksheet, display cell formulas, and set options to print gridines and center, and the file name code on the right side original worksheet, and rename the new sheet as Formulas. headings. Ensure that the worksheets are correctly named and placed in the following order in the Excel. Submit the workbook as directed. 21 workbook: Rental Rates, Formulas. Save the workbook. Close the workbook and then exit Total Points 100 Weddle_e01.g File Home Insert Draw Page Layout Formulas Data Review View Help O Tell me I PROTECTED VIEW Be careful-files from the Internet can contain viruses Unless you need to edit,it's safer to stay in Protected E12 Beachfront Guest House Effective May 1, 2018 r1 Off-Peak Rentals ER Maximum R Per Day Peak Rentals 5 Rental Type No. Units Per Day Maximum R Discount Rate 120 174 720 149.95 250.45 450 6 Studio Apartment6 7 1 Bedroom Suite 8 2 Bedroom Suite 9 10 11 Questions & Answers 6 4 696 247.55 495.1 12 Assume all 12 units are rented as you answer the folloving questions: 13 14 (1) Which rental type 15 Apply Yellow highlight to the correct answer below: 16 Studio Apartment 17 1 Bedroom Suite 18 2 Bedroom Suite 19- 20 (2) Which rental type generates the most maximum revenue for off-peak rental periods? 21 Apply Yellow highlight to the correct answer below generates the most maximum revenue for peak rental peri ods? 22 Studio Apartment 23 1 Bedroom Suite 24 2 Bedroom Suite 25 26 (3) Why is there a difference? 27 Change XX.X to the correct values at the end of the following sentence 28 The Studio Apartment is discounted only 20% for off-peak periods, whereas the 1 Bedroom Suite is discounted XXX 29 30 31 Excel Project Office 2016-myitlab:grader- Instructions EX16 XL_CH01 _GRADER ML1 HW -Guest House Rental Rates 1.5 Project Description: 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 Instructions: For the purpose of grading the project you are required to perform the following tasks Points Step Instructions 1Start Excel. Download and open the file named eot grader h2.xx 2 Apply the Heading 1 cell style to the range A1:G1. | Apply the 20%-Accent 1 cell style to the range A2:02. 4 Merge and center Off-Peak Rentals in the range E4:G4. s Apply Blue il c olor (the eighth color below Standard Colors) and White, Background 1 font color to the cell E4. Center and wrap the headings on row 5. 6 In cell D6, enter a formula that calculates the Peak Rentals Maximum Revenue by multiplying the No. Units by the Per Day value. In cell G6, enter a formula that calculates 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 80% of its peak rental rate. However, you need to cal ulate and display the off-peak discount rate, which is 19973 9 Copy the formula in cell D6 to cells D7:D8. Copy the formula in cell G6 to cells G7-G8. Format the range C6:F8 with Accounting Number Format. 10 Updated: 01/19/2018 Current Instruction docx Office 2016- myitlab:grader -Instructions Excel Project Points Step Instructions 11 Format the range G6:68 in Percent Style with one decimal place. 12 | Apply Blue, Accent 1, Lighter 80% fill color to the range E5:08. Select the range CS:D8 and apply a custom fill color with Red 242, Green 220, and Blue 219 13Note, Mac users, in the Colors diakog box, dick the Color Sliders tab and then selot the RGB Sliders 14 Answer the frst question below the worksheet data. Aoly Yellow holiht colox to te corect in either cell A16, A17, or A18 Answer the second question below the worksheet data. Apply Yellow highlight color to the 15 correct answer in either cell A22, A23, or A24. Answer the third question below the worksheet data. Change XXX% to the correct percentage in cell A28. 16 Select Landscape orientation, center the data horizontally on the page, and apply the setting 17 to fit to one page. 18 Insert a footer with the text Exploring Series on the left side, the sheet name code in the 19 Create a copy of the Rental Rates worksheet, place the new sheet to the nght side of the 20 On the Formulas worksheet, display cell formulas, and set options to print gridines and center, and the file name code on the right side original worksheet, and rename the new sheet as Formulas. headings. Ensure that the worksheets are correctly named and placed in the following order in the Excel. Submit the workbook as directed. 21 workbook: Rental Rates, Formulas. Save the workbook. Close the workbook and then exit Total Points 100 Weddle_e01.g File Home Insert Draw Page Layout Formulas Data Review View Help O Tell me I PROTECTED VIEW Be careful-files from the Internet can contain viruses Unless you need to edit,it's safer to stay in Protected E12 Beachfront Guest House Effective May 1, 2018 r1 Off-Peak Rentals ER Maximum R Per Day Peak Rentals 5 Rental Type No. Units Per Day Maximum R Discount Rate 120 174 720 149.95 250.45 450 6 Studio Apartment6 7 1 Bedroom Suite 8 2 Bedroom Suite 9 10 11 Questions & Answers 6 4 696 247.55 495.1 12 Assume all 12 units are rented as you answer the folloving questions: 13 14 (1) Which rental type 15 Apply Yellow highlight to the correct answer below: 16 Studio Apartment 17 1 Bedroom Suite 18 2 Bedroom Suite 19- 20 (2) Which rental type generates the most maximum revenue for off-peak rental periods? 21 Apply Yellow highlight to the correct answer below generates the most maximum revenue for peak rental peri ods? 22 Studio Apartment 23 1 Bedroom Suite 24 2 Bedroom Suite 25 26 (3) Why is there a difference? 27 Change XX.X to the correct values at the end of the following sentence 28 The Studio Apartment is discounted only 20% for off-peak periods, whereas the 1 Bedroom Suite is discounted XXX 29 30 31