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?
A)IF(D1 = 6,C1,C2)
B)ROUND(C3)
C)ABS(C3)
D)All of the above
E)b and c 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?
A)IF(D1 >= 6,C1,C2)
B)ROUND(C3)
C)ABS(C3)
D)All of the above 
E)b and c only

Quizplus · Accepted Answer

The linear formulas in a spreadsheet are those that can be represented as a straight line on a graph. The formulas that are not linear are those that contain non-linear functions, such as the IF function, the ROUND function, and the ABS function.

If the Data Cells Are in Column D and the Changing