Google News
logo
Microsoft Excel - Quiz(MCQ)
Which of the following formulas will Excel not be able to calculate?
A)
=SUM(A1:A5)*.5
B)
=SUM(Sales)-A3
C)
=SUM(A1:A5)-10
D)
=SUM(A1:A5)/(10-10)

Correct Answer : Option (B) :   =SUM(Sales)-A3


Explanation : 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.

Advertisement