A Spreadsheet Developer Enters the Formula "=B9*B10" into Cell C1

question 29

Multiple Choice

A spreadsheet developer enters the formula "=B9*B10" into cell C1. If this formula is copied and then pasted into cell D2, what will the formula in cell D2 be?

• A) =B9*B10
• B) =C9*C10
• C) =C10*C11
• D) =B9*B11
• E) =B10*B11

---

Definitions:

Harmonized Sales Tax (HST)

A combined tax in some Canadian provinces that merges the federal goods and services tax (GST) with the provincial sales tax (PST) into a single value-added tax.

Current Liability

Obligations or debts that a company needs to settle within one year or one business cycle, whichever is longer.

Financial Liability

An obligation to pay money to another party, recorded on a company's balance sheet.

Contractual Obligation

A duty or responsibility one party owes to another under the terms of a contract.