Weekly revenue calculation
Calculate a week of ticket revenue from full-price and half-price customers: unit totals with absolute references, row totals, then SUM and AVERAGE — 10 guided steps.
The full-price reference must be locked.
1 / 10
Write in D2 the formula to calculate the full-price amount.
=B2*$C$11
The $C$11 rate stays locked, the B2 reference shifts down.
2 / 10
Fill the formula down from D2 to D6 using the fill handle.
=B6*$C$11
The half-price ticket rate must be locked.
3 / 10
Write in E2 the formula to calculate the half-price amount for Monday.
=C2*$C$12
Same as column D: $C$12 stays locked, C2 shifts.
4 / 10
Fill the formula down from E2 to E6 using the fill handle. What formula do you get in E6?
=C6*$C$12
Add up Monday's full-price and half-price totals.
5 / 10
Write in F2 the formula to calculate Monday's total revenue (full price + half price).
=D2+E2
Both references (D2 and E2) shift down together.
6 / 10
Fill the formula down from F2 to F6 using the fill handle.
=D6+E6
Use the SUM function to make this easier.
7 / 10
Write in B7 the formula to calculate the total number of full-price customers.
=SUM(B2:B6)
Fill to the right using the fill handle.
8 / 10
Fill the formula from B7 across to F7.
=SUM(F2:F6)
Use the AVERAGE function on the range B2:B6.
9 / 10
In B8, calculate the average number of full-price customers over the week.
=AVERAGE(B2:B6)
Use the fill handle to fill the formula to the right.
10 / 10
Fill the formula across to cell F8.
=AVERAGE(F2:F6)
Your score is
Restart
