Interview Questions And Answers Forum

hamidoon123

Moderator

Registered: 2017-09-21

Posts: 50,766

In Excel which of the following formulas willExcel not be able to...

Computer Info and Shortcut Keys Exams Quizzes MCQs Quizzes MS Excel Test 3

Question:
In Excel which of the following formulas willExcel not be able to calculate?

Option A):
=SUM(A1:A5)-10
Option B):
=SUM(A1:A5)/(10-10)
Option C):
=SUM(Sales)-A3
Option D):
=SUM(A1:A5)*.5

Correct Answer is Option C):
=SUM(Sales)-A3