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.