Excel 2019 Pred Excel - Renovation Project Description: Lesa Martin, a member of the supportooordination staff for the conference center at Painted Paradise Golf Resort and Spa has created a worksheet to keep track of the renovations being made to the three rooms that are used for conferences and the two technology centers that are used for computer-based presentations and interactive sessions. The technology centers are equipped with workstations, are networked, and have Internet accessibility. This spreadsheet is simple and designed only for Lesa and her associates to keep a handle on the renovation progress and estimate the increase in capacity and reverse that might cour as a result of the renovations Steps to Perform: Instructions Points Possible Step 0 1 Start Excel. Download and open the file named Renovations.xlsx, Grader has automatically added your last name to the beginning of the filename. Save the file to a location where you are storing your files. 2 5 3 30 4 You notice that the named range increase Revenue is not pointing to the correct destination Fix the named range Hint: Use the Name Manager on the Formulas tab. Create a second named range called increase in Capacity for $13. After renovations, each room will have more capacity and therefore more revenue. You want to determine the new capacity in H6:H10 and the projected revenue after the renovations have been completed in JG:10. Hint: Make sure to take into consideration the original revenue plus the increase in revenue You have been asked to determine how long the renovation of each room will take in days based on the started and completed dates in E6:10. Hint: Use DATEDIF What is the average length of renovations in days (E13)? What is the total new capacity (H13)? What is the total new projected revenue (J13)? 15 5 10 10 7 10 8 15 9 Lesa is contemplating only doing the rooms that are in the right corridor. If she moves forward with just those rooms, what is the new projected revenue for the right corridor (B18), the average length of renovations for the right corridor (B19), and the total number of projects that will be completed in the right corridor (820)? Total Points 100 Excel - Renovation Created On: 01/10/2020 Painted Paradise Resort & Spa Banquet Room Renovations Created by Lesa Martin The Musica Room The Eldorado Room The Pueblo Room Technology room 1 Technology room 2 Corridor Right Right Right Left Left Renovations Started 2/6/2022 3/15/2022 9/10/2022 8/1/2022 2/15/2022 Renovations Length of Completed Renovations in Days 5/10/2022 9 7/15/2022 122 11/10/2022 81 10/1/2022 61 4/15/2022 Original Capacity 100 250 25 Projeded Ouarterly Ne Quarterly Revenue Revenge Capacity Prior to Renovations Renovation 200.000 475,000 25 225.000 25,000 Increase in Capacity Increase in Revenue 30% 40% Avg Renovation Total New Capacity Total Projed Right Corridor Revenue Avg Length of Reno # of Projects Renovations ady Type here to search O CA a 3 Project Description: Lesa Martin, a member of the support/coordination staff for the conference center at Painted Paradise Golf Resort and Spa has created a worksheet to keep track of the renovations being made to the three rooms that are used for conferences and the two technology centers that are used for computer-based presentations and interactive sessions. The technology centers are equipped with workstations, are networked, and have Internet accessibility. This spreadsheet is simple and designed only for Lesa and her associates to keep a handle on the renovation progress and estimate the increase in capacity and revenue that might occur as a result of the renovations Steps to Perform: Points Possible Step Instructions 1 Start Excel. Download and open the file named Renovations.xlsx. Grader has automatically added your last name to the beginning of the filename. Save the file to a location where you are storing your files. 2. You notice that the named range Increase in Revenue is not pointing to the correct destination Fix the named range. Hint: Use the Name Manager on the Formulas tab. Create a second named range called increase incapacity for B13. 5 3 30 4 After renovations, each room will have more capacity and therefore more revenue. You want to determine the new capacity in H6:H10 and the projected revenue after the renovations have been completed in J6:J10. Hint: Make sure to take into consideration the original revenue plus the increase in revenue. 15 5 10 6 10 7 You have been asked to determine how long the renovation of each room will take in days based on the started and completed dates in E6:E10. Hint: Use DATEDIF. What is the average length of renovations in days (E13)? What is the total new capacity (13)? What is the total new projected revenue (J13)? Lesa is contemplating only doing the rooms that are in the right corridor. If she moves forward with just those rooms, what is the new projected revenue for the right corridor (B18), the average length of renovations for the right corridor (B19), and the total number of projects that will be completed in the right corridor (B20)? 10 8 15 9 Total Points 100