Question

In the expenses workbook, Cassie defined the range D10:G10 with the name rentexpenses. Which of the following forμlas can replace the forμla?

a) =SUM(rentexpenses)
b) =AVERAGE(rentexpenses)
c) =MAX(rentexpenses)
d) =MIN(rentexpenses)

Answer 1

The correct formula to replace the original formula is =SUM(rentexpenses). This formula will calculate the sum of the values within the range D10:G10, which is the same as the original formula that defined the range.

Step-by-step explanation:

The correct formula to replace the original formula is =SUM(rentexpenses).

This formula will calculate the sum of the values within the range D10:G10, which is the same as the original formula that defined the range.

The SUM() function adds up all the values in a given range, so it is the appropriate function for finding the sum of the rent expenses.