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