Question

Fill the range c15:e15 with the formula in cell b15 to determine the average revenue per salesperson in quarters 2 and 3 and year to date

Answer 1

Excel formulas are expressions used to perform computation.

The Excel formula to enter in range C15:E15 are: = (C14/G2) ,= (D14/G2) and = (E14/G2)

How to determine the Excel formula

From the complete question, the formula in cell B15 is:

= (B14/G2)

When the formula is moved to fill the range C15 to E15, we change B14 to C14, D14 and E14.

So, we have:

C15= (C14/G2)

D15= (D14/G2)

E15= (E14/G2)

Hence, the formulas in range C15:E15 are:

= (C14/G2) ,= (D14/G2) and = (E14/G2)

Read more about Excel formulas at:

https://brainly.com/question/14820723