In the Expenses workbook, Cassie defined the range D10:G10 with the name RentExpenses. Which of the following formulas can replace the formula =SUM(Expenses!D10:G10)?
A) '=SUM([Expenses]!Rent),
B) =SUM(RentExpenses)
C) =SUM([RentExpenses], D10:G10)
D) =SUM(D10:G10)

Question

Quizplus · Accepted Answer

The formula =SUM(RentExpenses) refers to the range D10:G10 in the Expenses workbook, which has been defined as RentExpenses by Cassie.

In the Expenses Workbook, Cassie Defined the Range D10:G10 with the Name