Ask Question
25 November, 00:49

Create a division formula.

a. Click the Bookings sheet tab and select cell F5. Average revenue per passenger can be determined by dividing the fee by the number of passengers.

b. Build the division formula.

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

+1
Answers (1)
  1. 25 November, 03:39
    0
    = (A4+B4+C4+D4+E4) / 5

    Explanation:

    If we want to have the average of the passengers, first we must sum all the revenue and then divide it with passenger quantity.

    In this particular example, I made the formula with 5 passengers, I sum the 5 revenues and then I divide with 5 passengers if there are more passengers we must sum all of them, and divided all of them, for example:

    = (A4+B4+C4+D4+E4+F4) / 6
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “Create a division formula. a. Click the Bookings sheet tab and select cell F5. Average revenue per passenger can be determined by dividing ...” in 📙 Computers & Technology if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers