Which of the following does not comply with the preferred way of using the SUM function?
A)=SUM(A4:A11)
B)=SUM(A4:A11, B9:E11)
C)=SUM(A4, B8, D14)
D)=SUM(A4/A11)

Question

Quizplus · Accepted Answer

The SUM function is used to add up a range of cells or values. Option D uses "/" instead of ":" to define the range, which is incorrect syntax. Therefore, option D does not comply with the preferred way of using the SUM function.

The best choice is: 
Answer: A and B
 A uses the correct syntax of defining a range with ":" and B uses multiple ranges separated by a comma. Both comply with the preferred way of using the SUM function.

Which of the Following Does Not Comply with the Preferred