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

Question

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

Quizplus · Accepted Answer

I. =IF(D1 >= 6, C1, C2) - This is a conditional formula based on a logical statement, so it is not linear.
II. =ROUND(C3) - This is a linear formula because it only involves a single variable.
III. =ABS(C3) - This is also a linear formula because it only involves a single variable. 
Therefore, the only non-linear formula is I, while II and III are both linear. The correct choice is E, as it includes II and III only.

If the Data Cells Are in Column D and the Changing