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(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.
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.
