EXCEL QUESTIONS

1. You have been handed a spreadsheet that contains a formula in cell D10 that computes Year 10 profits. You want to display all cells that are used to compute Year 10 Profits. You should select which tool from the Ribbon (two-word answer)?

2.An airline sells 120 tickets for a flight that seats 100. Each ticket is non-refundable and costs $200. The unit cost of flying a passenger (fuel, food, etc.) is $80. If the flight is overbooked, each person who does not find a seat is given $300 in cash. Assume it is equally likely that any number of people between 91 and 120 show up for the flight. Rounded to the nearest thousand (e.g., 18500 rounds to 19000), on the average how much expected profit (ignoring fixed cost) will the flight generate?

Enter just the number; e.g., 11000

3.Again refer to the screenshot below. Which of the following is another way of retrieving the appropriate value for unit sales, given a name entered in cell E4?

• =INDEX(B1:B20, MATCH(E4,A2:A20,0))
• =INDEX(B2:B20, MATCH(E4,A2:A20,0))
• =INDEX(B1:B20, MATCH(E4,A2:A20,1))
• =INDEX(B2:B20, MATCH(E4,A2:A20,1))
• =MATCH(E4,INDEX(B1:B20),0)
• =MATCH(E4,INDEX(B2:B20),0)
• =MATCH(E4,INDEX(B1:B20),1)
• =MATCH(E4,INDEX(B2:B20),1)
• See Screen Shot 2015-04-09 at 12.05.43 PM.png