If the data cells are in column D and the changing cells are in column C, which of the following are linear formulas in a spreadsheet?
I. =SUMPRODUCT(D1:D6, C1:C6)
II. =SUMPRODUCT(C1:C3, C4:C6)
III. =SUM(C1:C6)
A) I only
B) II only
C) III only
D) I, II, and III
E) I and III only

Question

Quizplus · Accepted Answer

I. This formula is linear because it is multiplying the values in column D by the values in column C and then adding them up.
II. This formula is also linear because it is multiplying two sets of values in column C and then adding them up.
III. This formula is linear because it is simply adding up the values in column C.

If the Data Cells Are in Column D and the Changing