a) =SUM(A1,B1)
b) =SUM(A1:B9)
c) =SUM (A1:A9,B1:B9)
d) All of the above
e) None of above
Check Answer
All of the listed options (a) =SUM(A1,B1), (b) =SUM(A1:B9), and (c) =SUM (A1:A9,B1:B9) are correct syntax for the SUM function in Excel.
The SUM function is a built-in function in Excel that allows you to add up a series of numbers. It takes one or more arguments, which can be a range of cells, a cell reference, or a constant.
Option a) =SUM(A1,B1) adds up the values in cells A1 and B1.
Option b) =SUM(A1:B9) adds up the values in the range A1:B9, which includes all the cells from A1 to B9.
Option c) =SUM (A1:A9,B1:B9) adds up the values in the ranges A1:A9 and B1:B9, which includes all the cells from A1 to A9 and all the cells from B1 to B9.
Therefore, the correct answer is d) All of the above. All of the listed options are correct syntax for the SUM function in Excel.
The SUM function is a built-in function in Excel that allows you to add up a series of numbers. It takes one or more arguments, which can be a range of cells, a cell reference, or a constant.
Option a) =SUM(A1,B1) adds up the values in cells A1 and B1.
Option b) =SUM(A1:B9) adds up the values in the range A1:B9, which includes all the cells from A1 to B9.
Option c) =SUM (A1:A9,B1:B9) adds up the values in the ranges A1:A9 and B1:B9, which includes all the cells from A1 to A9 and all the cells from B1 to B9.
Therefore, the correct answer is d) All of the above. All of the listed options are correct syntax for the SUM function in Excel.
