Which of the following choices is a valid SUM function?
A) =SUM(G7:G11)
B) =SUM(G7-G11)
C) =SUMS(G7:G11)
D) =SUMS(G7-G11)

Question

Quizplus · Accepted Answer

Option A is the only valid SUM function out of the given options. It uses the correct syntax for adding the values within the given range from G7 to G11. Option B uses a hyphen instead of a colon to specify the range. Option C and D both use an invalid function name, as SUMS is not a recognized function in Excel.

Which of the Following Choices Is a Valid SUM Function