who knows excel?

profilefavgadhed
alqadheeb_e01_grader_h1_hoteldisc.xlsx
Home>Computer Science homework help>who knows excel?

Hotel Discounts

Fall Room Rates
One Double Two Doubles Two Kings Deluxe Suite Super Suite Grand Villa Suite
Room Qty 105 210 175 140 42 28
Standard Rate 174 199 194 234 299 374
Discounts
Paradise Club -0.09 -0.09 -0.09 -0.09 -0.09 -0.09
Group -0.1 -0.1 -0.1 -0.1 -0.1 -0.1
Comp -1 -1 -1 -1 -1 -1
Rooms Sold
Friday One Double Two Doubles Two Kings Deluxe Suite Super Suite Grand Villa Suite
Standard Rate 44 35 35 80 21 0
Paradise Club 21 62 70 35 14 21
Group 35 105 50 14 0 0
Comp 0 0 14 7 0 7
Saturday One Double Two Doubles Two Kings Deluxe Suite Super Suite Grand Villa Suite
Standard Rate 41 56 53 49 28 7
Paradise Club 26 49 60 7 14 14
Group 33 99 47 63 0 0
Comp 0 0 9 21 0 7
Sales Analysis
Friday One Double Two Doubles Two Kings Deluxe Suite Super Suite Grand Villa Suite Total
Gross Sales
Paradise Club
Group
Comp
Net Sales
Total Discounts
Saturday One Double Two Doubles Two Kings Deluxe Suite Super Suite Grand Villa Suite Total
Gross Sales
Paradise Club
Group
Comp
Net Sales
Total Discounts
2 Night Total Discounts
Friday + Saturday One Double Two Doubles Two Kings Deluxe Suite Super Suite Grand Villa Suite Total
Paradise Club
Group
Comp
Total Discounts

&F

Documentation

Create Date By Whom Description Workbook Name
5/12/14 ERROR:#N/A
Mod. Date By Whom Mod. Description Last Version Backup Name
: VERSION BACKUP NAME : Before modifying any worksheet, save the original workbook with the following name format: Original name_yyyymmdd
5/8/15 Firstname Lastname
Create Date Sheet Name Creator Purpose
If the workbook contains more than 3 worksheets, create a new worksheet documentation section using copy and paste.