Answer:
1. =SUM(C15: G15) 2. The first part of second part is =SUM(C11:G11), =SUM(C12:G12), =SUM(C13:G13), =SUM(C14:G14), =SUM(C15:G15). Last is total revenue and the first four are seating for various classes and the second part of the second question is =SUM(H11: H14) which is the grand total of seats.
Explanation:
Suppose from C15 to G15, we have five columns and hence five days. So we can have one column for one day, and add there, number of seats. C15: G15 is daily revenue, and C11: G11 ...... C14: G14 is the number of seats each day, and in each class, and thus the above answer. We can have different assumptions, and formula will change according to assumptions. You can use HLOOKUP as well if you want.
You have to ask you teacher to show you which ones you got wrong and the answers to them.
