YO16_XL_CH03_GRADER_PS1_HW - Renovations 1.2
- Jonmaz02
- Rating : 4
- Grade : A+
- Questions : 0
- Solutions : 4
- Blog : 0
- Earned : $497.00
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step
Instructions
Points Possible
1
Start Excel. Open the file named e02ch03_grader_hw_Renovations.xlsx. Save the file with the name e02ch03_grader_hw_Renovations_LastFirst, replacing LastFirst with your last and first name.
0.000
2
On the Renovations worksheet in cell G6, enter a formula using an absolute reference to determine the new capacity that the Musica Room will hold based on the capacity in cell F6 and the percentage in cell B13. Copy this formula to the range G7:G10.
8.000
3
Assign the named range IncreaseInRevenue to cell B14.
6.000
4
In cell I6, enter a formula to determine the projected revenue for the Musica Room based on the revenue figure in cell H6 and the percentage in cell B14. Use the named range in cell B14 when entering this formula. Copy this formula to the range I7:I10.
8.000
5
In cell D6, enter the DATEDIF date function to determine the length in days of the expected renovation for the Musica Room. Copy this function to the range D7:D10.
12.000
6
In cell B15, enter the function to calculate the median length of renovations in days. Assign the named range MedianDays to the cell.
10.000
7
In cell J6, enter a logical function to display the word Under in the cell if the renovations are going to take fewer than or equal to the median number of days calculated in cell B15; otherwise, have the word Over display. Use the named range for B15 when entering this function. Copy this function to the range J7:J10.
15.000
8
In cell B21, enter a function that will calculate the monthly payment for the loan amount in cell B18, based on the Annualized Rate in B19, and the number of years in the Term in cell B20. Display the monthly payment as a positive value.
15.000
9
Assign the named range RoomClassification to A24:B27.
6.000
10
In cell K6, using a VLOOKUP, create a function to determine the projected room classification based on the projected quarterly revenue after renovations in cell I6. Use the named range RoomClassification when entering this function. Copy this function to the range K7:K10.
15.000
11
Add the File Name in the left footer of the Renovations sheet.
5.000
12
Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.
0.000
Total Points
100.000
[Solved] YO16_XL_CH03_GRADER_PS1_HW - Renovations 1.2
- This Solution has been Purchased 6 time
- Submitted On 05 Jul, 2018 06:01:17
- Jonmaz02
- Rating : 4
- Grade : A+
- Questions : 0
- Solutions : 4
- Blog : 0
- Earned : $497.00
YO16_XL_CH04_GRADER_PS1_HW - Advertising 1.3
YO16_XL_CH06_GRADER_PS1_HW - Gift Shop Sales Review 1.8
YO16_XL_CH05_GRADER_PS1_HW - University Call Center 1.3
YO16_XL_CH03_GRADER_PS1_HW - Renovations 1.2
The benefits of buying study notes from CourseMerits
Assurance Of Timely Delivery
We value your patience, and to ensure you always receive your homework help within the promised time, our dedicated team of tutors begins their work as soon as the request arrives.
Best Price In The Market
All the services that are available on our page cost only a nominal amount of money. In fact, the prices are lower than the industry standards. You can always expect value for money from us.
