The answer should be C, you need a text editor to write out the code, and then a web browser to view what the code creates.
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.
Answer:
A. the BY statement.
Explanation:
The BY statement aids the procedure MEANS to develop the tree for the current BY group only, thereby analyze the stats, and clean the tree prior to the start and development of the next BY group.
However, without the BY statement, procedure MEANS develops its AVL tree for both the whole file and all sector estimates crossings established in CLASS.
Hence, in this case, the correct answer is the BY Statement.
I've included my code in the picture below. Best of luck.