Q183
Which of the following formulas will Excel not be able to calculate?
A.
=SUM(Sales)-A3
AnswerB.
=SUM(A1:A5)*.5
C.
=SUM(A1:A5)/(10-10)
D.
=SUM(A1:A5)-10
Answer: Option A
Solution
Answer: Option A
Solution:
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.