Excel
YenRose99
3 years ago
8
files (2)ExcelAssignmnet.docx
UNV103_T6ExcelBudgetAssignment.xlsx
ExcelAssignmnet.docx
During your time here at GCU you might be asked to use Microsoft Excel. This assignment will help you to see some of the basic functions of Excel. As you complete the steps in the worksheet, notice the changes within the cells. For further information on Microsoft Excel, go to: https://www.microsoft.com/en-us/search/explore?q=excel.
Use the attached document to complete the assignment.
UNV103_T6ExcelBudgetAssignment.xlsx
GCU Graduation Vacation
| Location | ||||||||
| Phoenix, AZ | Budget Total: | $ 6,626.08 | ||||||
| Transportation | ||||||||
| Item Description | Qty | Price each | Total price | |||||
| Plane tickets | 4 | $ 350.00 | $ 1,400.00 | |||||
| Rental car- per day | 5 | $ 45.00 | $ 225.00 | |||||
| Gas- Gallons | 100 | $ 3.10 | $ 310.00 | |||||
| Lodging | ||||||||
| Item Description | Nights | Price each night | Total price | |||||
| GCU Hotel | 3 | $ 89.00 | $ 267.00 | |||||
| Flagstaff Hotel | 2 | $ 128.00 | $ 256.00 | |||||
| Food | ||||||||
| Item Description | Days | Price each day | Total price | |||||
| Breakfast budget | 5 | $ 200.00 | $ 1,000.00 | |||||
| Lunch budget | 5 | $ 200.00 | $ 1,000.00 | |||||
| Dinner budget | 5 | $ 350.00 | $ 1,750.00 | |||||
| Entertainment and Misc. | ||||||||
| Item Description | Qty | Price each ticket | Total price | |||||
| Movie | 4 | $ 10.50 | $ 42.00 | |||||
| Concert | 4 | $ 45.00 | $ 180.00 | |||||
| GCU Basketball game | 4 | $ 10.00 | $ 40.00 | |||||
| Grand Canyon National Park | 1 | $ 35.00 | $ 35.00 | |||||
| Flagstaff Extreme Adventure | 4 | $ 30.27 | $ 121.08 | |||||
You have finished your degree and are traveling to Phoenix for the GCU graduation ceremonies with three of your closest friends for a week. You want to visit Phoenix for graduation and drive to Flagstaff to see the Grand Canyon before returning home. You have come up with a budget to see how much the trip will cost. Please make the following adjustments- 1.) You just saw a promotion for $200 round trip flights to Phoenix. Change the ticket price from $350 to $200. 2.) You decide to stay 1 night in Flagstaff and 4 nights in Phoenix. Change the Flagstaff Hotel to 1 and the GCU Hotel to 4. 3.) After reviewing the options at GCU Hotel's Canyon 49 Grill, you think you can save money eating breakfast there and adjust your breakfast budget from $200 to $150. 4.) GCU offers you a discount on your Basketball tickets changing your total from $10 to $8.50 each. 5.) One of your friends cannot attend the concert because she is meeting up with a cousin in Phoenix. Change the concert number from 4 to 3. Before you submit this assignment please click the plus sign (+) next to the GCU Graduation Vacation tab, create a new tab, and type your name in cell A1. Then save and submit for grading
- For Accounting_king
- Strategic planning
- PSY 101
- The Net Exports Effect
- Free-market versus Controlled Economies
- Organize the three (3) basic forms of government from the point of view of a public administrator. Suggest two to three (2-3) common goals and interdependencies of the forms of government in question. Provide a rationale to support your response.
- "One Interconnected Economy" Please
- Please Comment Financial ANalyst statement of findings
- Week One Health Care Financial Terms Worksheet
- Would the mass density of an object
