Menu
Home / Computer Fundamentals / MS Excel :: Discussion

Discussion :: MS Excel

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

    2. A.

     =SUM(Sales)-A3
    B.

     =SUM(A1:A5)*.5
    C.

     =SUM(A1:A5)/(10-10)
    D.

     =SUM(A1:A5)-10

    View Answer

    Workspace

    View Answer

    Answer : Option A

    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.

Write your comments here:

Be The First To Comment