Which of the following formulas will Excel not be able to calculate?
A
=SUM(Sales)-A3
B
=SUM(A1:A5)*.5
C
=SUM(A1:A5)/(10-10)
D
=SUM(A1:A5)-10
Correct Answer: =SUM(Sales)-A3
SUM function returns the sum of values supplied. These values can be numbers, cell references, ranges, arrays, and constants, in any combination. Here =SUM(Sales) is incorrect if it is not name of any range.