UNIV106U3SubmissionBudgetTemplate2402A
.pdf
School
No School**We aren't endorsed by this school
Course
AA 1
Subject
Computer Science
Date
Jan 15, 2025
Pages
1
Uploaded by
For this assignment, you will use a spreadsheet application to learn how to use basic tools such as adding and averaging numbers, creating borders, and updating titles and labels for atrip budget. Knowing how to use these tools will help you better represent information numerically.Family St. Louis Trip BudgetTARGET TRIP BUDGET$2,500.00ItemDescriptionCostQtyAmountNotesAirfareTickets$253.004$1,012.00 4 tickets for the flightHotelRoom (4 ppl per room)$200.002$400.00 Room cost is per night for a 2-night stayCar RentalCost per day$45.002$90.00 Car rental is 2 daysGasCost per gallon$1.8526$48.10 Filling up the 13-gallon tank 2 times during 2-day tripActivity#1Name of Activity$0.004$0.00 4 tickets for Activity#1Activity#2Name of Activity$0.004$0.00 4 tickets for Activity#2Activity#3Name of Activity$0.004$0.00 4 tickets for Activity#3FoodCost per day$40.008$320.00 Food cost is per person per day (2 days)Total Trip CostACTIVITY COSTSINSTRUCTIONSActivityCost per TicketYou can also refer to the instructional videos for step-by-step assistance.1Baseball Game85Step 1: Save this file to your device, renaming the file "YourLastName_U3_Submission.xlsx."2The Arch133Mississippi River Tour65Step 2:Change the title of the worksheet in cell B2 from “Family St. Louis Trip Budget” to"YourLastName St. Louis Trip Budget." Make this title bold, 26-point font.4City Museum for Kids18.485Touring the Historic District10Step 3: Change the tab labelfrom “Family St Louis Trip Budget” to "YourLastName St Louis TripBudget."Step 4:Add an AutoSum formula to cell F15 using the AutoSum shortcut. Update cell F15 formattingto currency with a $ and 2 decimal points to match the formatting of the other cells.Step 5: Find the Activity Costs table starting in cell B20. a. Review the activities and costs listed in this table, and pick 3 activities you like.b. Enter the name of each of the three activities into the appropriate cells in column C (C11, C12, C13).c. Enter the cost per ticket for each of the three activities into the appropriate cells in column D (D11,D12, D13).d. Adjust which activities you choose to keep your total cost in cell F15 at or below $2,500.Step 6: Find the average cost of your three activities.a. Name cell B16 "Average Activity Cost."b. Select cell F16, then using the AutoSum shortcut, click the down arrow and choose the Averageformula, select and drag cells F11–F13, and then click "Enter."c. Update cell F16 formatting to Currency with a $ and 2 decimal places to match the formatting of theother cells.Step 7: Create a border around the $ amount in cell F15.Step 8: Save your changes, and submit your assignment to the Unit 3 Submissions area. Click the "AddFile/Enter Text" button to upload your document ANDclick the "Submit to Instructor" button to submitthe saved document.
