a) =SUM(Sales)-A3

b) =SUM(A1:A5)*.5

c) =SUM(A1:A5)/(10-10)

d) =SUM(A1:A5)-10

e) All of above

### Check Answer

Excel will not be able to calculate

SUM Function returns the total of all values provided. These can be numbers or ranges, cell references, constants, and arrays using any of them. Here,

**“=SUM(Sales)-A3”**.SUM Function returns the total of all values provided. These can be numbers or ranges, cell references, constants, and arrays using any of them. Here,

**=SUM(Sales)**is incorrect since it isn’t the name of any range.### Related:

- Which of the following syntax is correct regarding SUM…
- You can enter which type of data into worksheet cells?
- What is an example of a function in MS Excel?
- Which of the following is not a basic step in creating a…
- Which area in an excel window allows entering values and…
- What is an example of a formula in MS Excel?
- Which of the following is not a valid Zoom percentage in…
- Which of the following is not a term of MS Excel?
- File Extensions used in MS Excel Versions
- Which symbol must all formula begin with
- Which type of software is similar to an accountant's…
- MS Excel is based on which operating system?
- Which of the following you can use in Paste Special command
- A typical worksheet has _____number of columns in Excel 2019
- The name box in MS Excel