Question

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.

Answer 1

In this exercise we have to use the knowledge of excel to explain some functions that can be used, as:

In excel cell a division formula can be written as: =(A4+B4+C4+D4+E4)/5

How to divide in excel?

Tip: To divide numerical values, use the "/" operator, as there is no DIVIDE function in Excel. For example, to divide 5 by 2, type =5/2 in a cell, which returns 2.5.

Not necessarily, we need the division to always be in numbers, they can be from cells. Just click on the cells and then do your division.

See more about excel at brainly.com/question/12788694