Banking Computers Science IBPS Bank Clerk Online CWE-IV Exam Held on 20-12-2014

  • question_answer
    In Excel, which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric?

    A)  Count              

    B)  Average

    C)  Sum                

    D)  Add

    E)  Merge

    Correct Answer: C

    Solution :

    [c] The SUM function is useful when we want to add or subtract values from different ranges or combine number values with ranges of numbers. We can include up to 255 numeric values or cell or range references, in any combination, as arguments in the SUM function.


You need to login to perform this action.
You will be redirected in 3 sec spinner