" . C ... Book2 Q Search (Cmd + Ctrl + U) AutoSave Hom Book3 Q Search (Cmd + Ctri + U) AutoSave A HEY . C ... Comments Share Draw Page Layout Formulas Data Review View Automate Home Insert Pas 2g v Conditional Formatting Insert ne me Aptos Narrow (Bod... v 11 A A Currency Format as Table Delete v Editing Sensitivity Add-ins Analyze Tasks Atlas 3.0 N4 Paste B U $ v % 19 08 0 Cell Styles v Format Data SUM 4XV fx = M N O P Atlas 3.0 X C D E G H M A W N 1.3 Calculate the "Add-On Total" 2 Graduates' Inn Guest Database # of # of Guest First Guest Last Departure Room Type 1.4 The manager would like some 3 Name Name Room Room Type Arrival Date Date Nights Guests Daily Rate Room Total Add-On Total Total With Tax ay-window $150.00 $0.00 Ocean 12/1 12/4 2 $450.00 details on revenue and taxes. 4 Julia Martines Hayes 0 00 N $650.00 $0.0 $731.71 Bay-window 5 Edward Holt Washington Ocean 12/1 12/3 $325.00 CO NG . Calculate the "Total With Tax" for N $300.00 $2,160.00 $0.00 $2,431.51 Side 10 6 Thomas Collins Cleveland Ocean 12/1 12/9 the first transaction. Bay-window 12/1 12/3 $150.00 $300.00 $60.00 $337.71 7 Lou Rodriguez Coolidge $125.00 $750.00 $0.00 $844.28 ax Rate . Copy and paste the formula down 8 Xavie 12/7 Trezza Johnson Ocean 12/1 12/4 $275.00 $825.00 $105.00 $928.70 the column to calculate the total 9 12/1 |Gregg Hodges Arthur Ocean CO V W H WON Roosevelt Ocean 12/1 12/2 $175.00 $175.00 $0.00 $197.00 with tax for the other transactions. 10 David Sanchez NN $125.00 $0.00 $422.14 Summary T 15 12/4 $375.00 11 Arthur Gottfried Polk Side 12/1 $125.00 $787.50 $886.49 Total Revenue before Tax . In cell Q12), calculate the "Total 16 12 Mickey Melendez Garfield Side 12/1 12/8 $175.00 $2,431.51 Total Tax Collected Revenue Before Tax". 12/9 $300.00 $2,160.00 $240.00 13 Patti Bray Reagan Bay-window 12/1 NW $150.00 $0.00 $168.86 Total Revenue 3 or 4 Guests Ocean 12/2 12/3 $150.00 . In cell Q13), calculate the "Total 14 Hull Lincoln 12/2 12/3 $150.00 $150.00 $0.00 $168.8 19 15 Carlyle Charleston Tyler Bay-window Tax Collected." 20 $200.00 $1,260.00 $245.00 $1,418.38 16 Manue Schroeder Jackson Ocean 12/2 12/9 $148.50 $594.00 $140.00 $668.6 Find Gues . Use the "Tax Rate" in cell Q8) and 17 Mabe Adams Grant Ocean 12/2 12/6 Quincy Adams Bay-window 12/3 12/4 $275.00 $275.00 $30.00 $309.57 Last Name the "Total Revenue Before Tax" you 18 Mohammed Nguyen $2,026.26 Vazquez 23 19 Buste Whisler Madison Ocean 12/3 12/11 $250.00 $1,800.00 $280.00 calculated in Q12) to calculate the $300.0 $0.00 $337.71 Hal 24 20 Donahue Truman Side 12/3 12/5 $150.00 $0.00 $1,604.80 Tilson total tax collected. 25 21 Jon Bay-window 12/3 12/11 $198.00 $1,425.60 Villanueva Adams $1,375.00 $ 150.00 $1,547.84 26 22 Gerald Pittsfield Tyler Bay-window 12/3 12/8 $275.00 N $0.00 $337.71 23 Bodkin Eisenhower Ocean 12/4 12/6 $150.00 $300.00 10 Washington 12/4 12/7 P A N N N H N W W NOO NOO HAN Ocean $250.00 $750.00 $105.00 $844.28 24 Albert Goldstone $525.00 $0.00 $590.99 1.5 In cell Q14), use a SUMIF 25 Clayton Lambert Mckinley Side 12/4 12/7 $175.00 12/6 $175.00 $350.00 $0.00 $394.00 30 26 Jen Blair orthu cear 12/4 125 31 Bay-window 12/4 12/5 $300.00 $300.00 $30.0 $337.71 1.6 The manager would like a 27 Dina Mcfarland Coolidge 12/5 12/7 $175.00 $350.00 $0.00 $394.00 32 28 Lorena Rice Van Buren Bay-window JAN $650.00 $70.00 $731.71 33 29 Lincoln Ocean 12/5 12/7 $325.00 1.7 The manager would like to Miller 12/5 12/7 N $325.00 $650.00 $0.0 $731.71 34 30 Erica Duncan Jefferson Bay-window 12/9 $600.00 $0.00 35 $150.00 $675.42 1.8 On the January Bookings 31 Micheal Mccoy Roosevelt Ocean 12/5 $1,000.00 $140.00 $1,125.70 32 Ana Carrillo Arthur Ocean 12/7 12/11 $250.00 $250.00 $1,000.00 $0.00 $1,125.70 1.9 In cell C36), use a 33 Paris Grant 12/7 12/11 12/8 12/10 $150.00 $300.0 $60.0 $337.71 38 34 Pacheco Jefferson Bay-window $450.00 $0.00 $506.57 1.10 On the Spring Remodel 39 $112.50 35 Juan Bush Quincy Adams Bay-window 12/8 12/12 40 December Guests January Bookings Remodel + 100% 41 Edit Accessibility: Investigate 100% Edit Accessibility: InvestigateAutoSave " . C ... Book2 Q Search (Cmd + Ctrl + U) Hom AutoSave A HEY . C ... Book3 Q Search (Cmd + Ctri + U) Home Insert Draw Page Layout Formulas Data Review View Automate Comments Share Pas Aptos Narrow (Bod... v 11 A A do v Currency Conditional Formatting v Insert ne me Format as Table Delete v N4 Paste B I UV $ v % 19 Editing Sensitivity Add-ins Analyze Tasks Atlas Cell Styles v Format Data 3.0 SUM X fx = O P Q R S T U V W X Y Z AA Atlas 3.0 X D UT AWNH N 1.3 Calculate the "Add-On Total" Room Type Additonal cost/person/day 1.4 The manager would like some 8 Ocean $35.00 Bay-window $30.00 details on revenue and taxes. Side $25.0 . Calculate the "Total With Tax" for the first transaction. Tax Rate 12.57% . Copy and paste the formula down 560 00 the column to calculate the total Summary Table with tax for the other transactions. Total Revenue before Tax . In cell Q12), calculate the "Total Total Tax Collected Revenue Before Tax". Total Revenue 3 or 4 Guests . In cell Q13), calculate the "Total Tax Collected." Find Guests . Use the "Tax Rate" in cell Q8) and Last Name Room Total the "Total Revenue Before Tax" you Vazquez Hall calculated in Q12) to calculate the Tilson total tax collected. 10 T23 1.5 In cell Q14), use a SUMIF 1.6 The manager would like a 1.7 The manager would like to 1.8 On the January Bookings 1.9 In cell C36), use a 1.10 On the Spring Remodel December Guests January Bookings Remodel + Edit ux Accessibility: Investigate + 100% Edit Accessibility: Investigate 100%