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

question 367

Multiple Choice

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)

---

Definitions:

MIS Department

Refers to the Management Information Systems Department, a unit within an organization responsible for developing and managing technology solutions that facilitate business operations.

Mobile Subscriptions

Regular payment plans that allow users access to mobile phone services, including data, voice, and messaging.

Batches

Groups of items, tasks, or data processed or treated together as a set in manufacturing or information technology contexts.

Data

Information, often in the form of facts or statistics, collected together for reference or analysis.