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?
A)SUMPRODUCT(D1:D6,C1:C6)
B)SUMPRODUCT(C1:C3,C4:C6)
C)SUM(C1:C6)
D)All of the above
E)a 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 linear formulas in a spreadsheet?
A)SUMPRODUCT(D1:D6,C1:C6)
B)SUMPRODUCT(C1:C3,C4:C6)
C)SUM(C1:C6)
D)All of the above 
E)a and c only

Quizplus · Accepted Answer

SUMPRODUCT(D1:D6,C1:C6) and SUM(C1:C6) are linear formulas because they involve linear operations (addition and multiplication by constants). SUMPRODUCT(C1:C3,C4:C6) is not linear as it involves multiplying different changing cells together.

If the Data Cells Are in Column D and the Changing