5.3k views
4 votes
Calculate average revenue per passenger by dividing the fee by the number of passengers.

Build the division formula.


Copy the formula in cell F5 to cells F6:F19.

User GFlam
by
7.2k points

1 Answer

5 votes

Answer and Explanation:

To build the division formula to calculate average revenue per passenger, you can follow these steps:

1. Identify the cells containing the fee and the number of passengers.

- Let's assume the fee is in cell D5 and the number of passengers is in cell E5.

2. Write the division formula to calculate the average revenue per passenger.

- In cell F5, you can enter the formula "=D5/E5".

To copy this formula to cells F6:F19, you can follow these steps:

1. Select cell F5, where the formula is currently located.

2. Copy the formula by either pressing Ctrl+C or right-clicking and selecting "Copy".

3. Select the range of cells F6:F19.

4. Paste the formula into the selected range by either pressing Ctrl+V or right-clicking and selecting "Paste".

The division formula will be copied to cells F6:F19, and each cell will calculate the average revenue per passenger by dividing the fee by the number of passengers in their respective rows.

User Kaj
by
8.3k points
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.