Question: Please include excel statement. F This problem will familiarize you with tables, and will give you practice in using various Excel tools at once. It
Please include excel statement.


F This problem will familiarize you with tables, and will give you practice in using various Excel tools at once. It counts as 2 problems. Pg. 79, \#20 The operational parameters are entered for you, starting in column I. Refer to the values from the table in your formulas, do NOT type them into your formulas. NOTE: the discount (if there is one) is applied to the entire bill. The meal charge is only applied if there are 3 or more guests per room, and only on the 3rd, 4th, .. guests. See template below (set up as an Excel table). Set up formulas for columns J-N. Then calculate the total revenue for December. Total Room/Meal Charges for December: Extra credit point: I will change the values in A10:A13. One extra credit point if your value in A20 adjusts accordingly (and correctly)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
