Question

Eric works for an airline, and he needs to calculate the weight of passengers and luggage before takeoff. The number of passengers is entered into cell A1. The airline uses an average weight of 180 pounds per person, so Eric enters 180 into cell A2. The weight of the checked luggage is entered into cell A3. Each passenger is alloted 10 pounds for carry-on luggage, so he enters 10 into cell A4. Which formula should Eric use?

Responses

=A1*A2+A3+A1*A4
=A1*A2+A3+A1*A4

=A1*A2+(A3+A1)*A4
=A1*A2+(A3+A1)*A4

=A1*(A2+A3+A1)*A4
=A1*(A2+A3+A1)*A4

=A1*A2*A3*A4

Answer 1

To calculate the total weight of passengers and luggage before takeoff, Eric needs to consider the following:

1. The total weight of the passengers, which is the number of passengers (A1) multiplied by the average weight per passenger (A2).
2. The weight of the checked luggage (A3).
3. The total carry-on luggage weight, which is the number of passengers (A1) multiplied by the allowance for carry-on luggage per passenger (A4).

The correct formula to calculate the total weight would be:

\[ \text{Total Weight} = ( \text{Number of Passengers} \times \text{Average Weight per Passenger} ) + ( \text{Weight of Checked Luggage} ) + ( \text{Number of Passengers} \times \text{Carry-On Weight per Passenger} ) \]

In cell reference terms, this translates to:

\[ =A1*A2 + A3 + A1*A4 \]

So the correct response is:

**=A1*A2+A3+A1*A4**