Advertisements
Advertisements
Question
Which of the following formulas in Excel will NOT give any result?
Options
=SUM(Sales)-A3
=SUM(A1:A5)*5
=SUM(A1:A5)/(10 - 10)
=SUM(A1:A5) - 10
MCQ
Solution
=SUM(Sales)-A3
Explanation:
SUM function returns the sum of values supplied. In any combination, these values can be numbers, cell references, ranges, arrays, and constants. Here =SUM(Sales) is incorrect if it is not name of any range.
shaalaa.com
Meaning of Electronic Spreadsheet
Is there an error in this question or solution?
