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

  • question_answer
    Which of the following is not a valid formula in Microsoft Excel?

    A)  =A2+A1         

    B)         = A2 + 1

    C)  = 1 + A2        

    D)         = 1A + 2

    E)  =A1+A2

    Correct Answer: D

    Solution :

    [d] In Excel, a formula starts with an equal sign (=). It can contain functions, references (A2 returns the value in cell A2), constants (Numbers or text values entered directly into a formula, such as 2) and operators. Using 1A is incorrect.


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