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:

LIFO Cost Flow

A method of stock valuation where the latest items added to the inventory are the first ones to be sold.

Cost of Goods Sold

The direct expenses tied to the production of goods sold by a company, including material and labor costs.

Net Income

A company's profit amount after all deductions for expenses and taxes from revenue have taken place.

FIFO Cost Flow

An inventory valuation method (First In, First Out) where goods first purchased or produced are sold or used first.