Now you want to determine the total amount spent at the spa if the guest stayed for four days. In cell D3, enter a formula to calculate the total amount spent at the spa if the guest stayed for 4 days (cell A3).
Added by Diana P.
Step 1
Let's think step by step. Show more…
Show all steps
Your feedback will help us improve your experience
Akash M and 78 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
11 You are ready to calculate the number of days for the workshops. In cell E5, enter a formula to calculate the number of days for the first workshop. Add 1 to the results to include the total number of days, including the start and end dates. The results may display in date format. Copy the formula to the range E6:E10. 12 The number of days results show dates rather than values. Applying the Number format will solve this issue. Apply Number format with zero decimal places and center the results horizontally in the range E5:E10. 13 The gross revenue is calculated by type of customer. Column J is designed to display the gross revenue for corporate customers. In cell J5, enter a formula to calculate the gross corporate revenue for the first workshop by multiplying the cost per attendee by the number of corporate attendees. Copy the formula to the range J6:J10. 14 Column K is designed to display the gross revenue for education customers. In cell K5, enter a formula to calculate the gross education revenue by subtracting the education discount rate from 1, multiplying the result by the cost per attendee and multiplying by the number of education attendees. Copy the formula to the range K6:K10. 15 Now that you calculated the gross revenue for corporate and education customers, you can calculate the total gross revenue for each workshop. In cell L5, enter a formula to calculate the total gross revenue by adding the Corporate Gross Revenue and the Education Gross Revenue. Copy the formula to the range L6:L10.
Akash M.
Calculate the "Add-On Total" for the first transaction. Rooms with 3 or more guests are required to pay the add-on fee. Use an IF function with a nested VLOOKUP to calculate the total based on the number of guests, number of nights, and the room type. Use the data in P4:Q6 to look up the cost based on the room type. The add-on fee is per person per night. If there is no add-on fee, display a zero (0) in the cell. Copy and paste the function down the column to calculate the add-on total for the other transactions.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD