Week 2 Excel Problems

profilebrianc19861
PresidentsInnGuestDatabase.xlsx
Home>Business & Finance homework help>Management homework help>Week 2 Excel Problems

Data

President's Inn Guest Database
ID Guest First Name Guest Last Name Room Room Type Arrival Date Departure Date No of Guests Daily Rate
1 Barry Lloyd Hayes Bay-window 12/1/14 12/4/14 2 $150.00
2 Michael Lunsford Cleveland Ocean 12/1/14 12/9/14 3 $112.50
3 Kim Kyuong Coolidge Bay-window 12/4/14 12/7/14 1 $150.00
4 Edward Holt Washington Ocean 12/1/14 12/3/14 4 $325.00
5 Thomas Collins Lincoln Ocean 12/9/14 12/13/14 2 $300.00
6 Paul Bodkin Coolidge Bay-window 12/1/14 12/3/14 2 $150.00
7 Randall Battenburg Washington Ocean 12/4/14 12/12/14 2 $292.50
8 Calvin Nowotney Lincoln Ocean 12/2/14 12/4/14 1 $300.00
9 Homer Gonzalez Lincoln Ocean 12/5/14 12/7/14 5 $320.00
10 David Sanchez Jefferson Bay-window 12/5/14 12/7/14 2 $175.00
11 Buster Whisler Jackson Ocean 12/5/14 12/8/14 2 $250.00
12 Julia Martines Reagan Bay-window 12/10/14 12/15/14 1 $150.00
13 Samuel Kim Truman Side 12/20/14 12/30/14 3 $112.50
14 Arthur Gottfried Garfield Side 12/13/14 12/15/14 2 $125.00
15 Darlene Shore Arthur Ocean 12/24/14 12/31/14 5 $198.00
16 Carlyle Charleston Quincy Adams Bay-window 12/3/14 12/6/14 2 $150.00
17 Albert Goldstone Johnson Ocean 12/5/14 12/7/14 3 $250.00
18 Charlene Tilson Van Buren Bay-window 12/5/14 12/7/14 1 $150.00
19 Everett Chad Madison Ocean 12/10/14 12/14/14 2 $275.00
20 Gerald Pittsfield Roosevelt Ocean 12/5/14 12/7/14 2 $275.00
21 Jamal Smith Tyler Bay-window 12/20/14 12/23/14 2 $150.00
22 Louis Paris Jackson Ocean 12/10/14 12/14/14 1 $250.00
23 Nigel Stratford Eisenhower Ocean 12/14/14 12/16/14 2 $200.00
24 Peter Willington Grant Ocean 12/19/14 12/21/14 1 $200.00
25 Ronald Cartier Jefferson Bay-window 12/24/14 12/28/14 4 $175.00
26 Trista Leven Eisenhower Ocean 12/17/14 12/20/14 1 $200.00
27 Valerie Snell Adams Bay-window 12/3/14 12/6/14 1 $150.00
28 Walter Acton Polk Side 12/24/14 12/31/14 6 $148.50
29 Xavier Trezza McKinley Side 12/14/14 12/17/14 2 $125.00
30 Zachary Miller Washington Ocean 12/13/14 12/16/14 2 $325.00