Which of the Following Adds the Values in Cell B21

question 44

Multiple Choice

Which of the following adds the values in cell B21 on the worksheets between Sheet1 and Sheet4?

• A)=SUM(Sheet1-Sheet4!B21)
• B)=SUM(Sheet1:Sheet4!B21)
• C)=SUM(Sheet1 Sheet2 Sheet3 Sheet4!B21)
• D)=SUM(Sheet1_Sheet4!B21)

---

Definitions:

Compounded Quarterly

The process of calculating interest on both the initial principal and the accrued interest over four quarters in a year.

Semi-annually

Occurring twice a year, typically used in the context of payments, compounding, or reporting periods.

Interest Rate

The ratio of interest a borrower must pay to a lender for using their money.

Monthly Payments

Monthly payments refer to the regular amounts paid monthly on a loan or lease over the duration of the agreement.