Question
In cell P9, enter a formula using the SUM function that calculates the revenue collected by Silver Screen Cinemas for the event. This formula should
In cell P9, enter a formula using the SUM function that calculates the revenue collected by Silver Screen Cinemas for the event. This formula should add together the following values:
a.The total sales revenue from Standard ticket sales (G9*I9) multiplied by the standard ticket allowance percentage (cell Q4).
b.The total sales revenue from VIP ticket sales (K9*M9) multiplied by the VIP ticket allowance percentage (cell Q5).
Use absolute references to cells Q4 and Q5 in your formula.
Copy the formula in cell P9 to the range P10:P17, pasting only the formulas and number formats.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Answer In cell P9 you can enter the following formula usi...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Survey of Accounting
Authors: Carl S Warren
5th Edition
9780538489737, 538749091, 538489731, 978-0538749091
