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

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.### Related:

- Which of the following formulas will excel not be able to…
- Which function will you use to enter the current date and…
- What is an example of a function in MS Excel?
- What is an example of a formula in MS Excel?
- Which of the following is not a term of MS Excel?
- Which of the following is not a valid Zoom percentage in…
- File Extensions used in MS Excel Versions
- What does the VLOOKUP function do?
- MS Excel is based on which operating system?
- A typical worksheet has _____number of columns in Excel 2019
- The name box in MS Excel
- A worksheet can have a maximum __ number of rows in Excel…
- When you insert an Excel file into a Word document, the data…
- Which of the following Excel screen components can NOT be…
- Which of the following is not a basic step in creating a…