Modify the spreadsheet (add at least one column for each item 1 to 3) to calculate:
(1) The number of days that each party stayed at the inn.
(2) Daily rates considering the number of guest(s), Hint: Use VLOOKUP function; create a resort fee table using the data above.
(3) Revenue collected from each party for their total stay at the guest house
(4) Total revenue generated for the month from all guests
Add one additional sheet to the spreadsheet to address the following items:
(5) Create a pivot table to calculate the total revenue categorized by each room type for December.
(6) Show a pie chart to display the revenue breakdown by room type from the previous item.
PLACE THE ORDER WITH US TODAY AND GET A PERFECT SCORE!!!