If the Data Cells Are in Column D and the Changing

question 60

Multiple Choice

If the data cells are in column D and the changing cells are in column C, which of the following are not linear formulas in a spreadsheet?
I. =IF(D1 >= 6, C1, C2)
II. =ROUND(C3)
III. =ABS(C3)

• A) I only
• B) II only
• C) III only
• D) I, II, and III
• E) II and III only

---

Definitions:

Purchases Discount

A reduction in the price of goods a company buys, typically for paying early or within a specified time period.

Accounts Payable

Liabilities owed by a business to its creditors for goods and services purchased on credit, which are due within a short period.

Debit Memorandum

A document issued by a buyer to a seller indicating returned goods or a request for a price reduction, increasing the buyer's accounts payable.

Sales Returns and Allowances

A reduction in sales revenue for returned goods or provided allowances due to dissatisfaction or defects.