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:

Creative Accounting

The manipulation of financial records and reports to present a more favorable view of a company's business activities.

Economic Substitution

The act of replacing one product with another due to changes in price, preferences, or other factors, reflecting the flexibility of consumption choices.

Industrial Regulation

Refers to government rules and laws that control how businesses can operate within certain industries to ensure fairness, safety, and competitiveness.

Social Regulation

Regulation in which government is concerned with the conditions under which goods and services are produced, their physical characteristics, and the impact of their production on society. Differs from industrial regulation.