ExamVeda
Login
Home
This question belongs to Computer Fundamentals MS Excel
MS Excel
?

Which of the following formulas will Excel not be able to calculate?

Answer & Solution
Correct Answer: Option A
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.
Examveda
Question posted by Examveda
Community

Join the Discussion

4 Comments
Muhammad Arsalan
Muhammad Arsalan 2 years ago
What about option C
=SUM(A1:A5)/(10−10) because it involves division by zero, which is undefined and will result in an error message in Excel.
Raman Verma
Raman Verma 6 years ago
=SUM(A1:A5)/(10-10)
How this will get calculated, as getting divide by 0.
Parul Dang
Parul Dang 7 years ago
In the first option, Sales can be a name given to some range and in the question, so ideally it may work as well.
Janak Bhatt
Janak Bhatt 8 years ago
=SUM(A1:A5)/(10-10) is not calculate in excel because 10-10 is zero so something divided by zero not defined in excel function. So its correct answer is C. Correct it.