2. Solved Papers
  3. Banking
  4. Computers Science

Banking Computers Science IBPS Bank PO and MT CWE Exam Held on 19-10-2014

  • question_answer
    If you copy = SUM (Al: A5) from Cell A6 to Cell B6, which formula will result for Cell B6 in Excel 2007?

    A)  SUM (B1:B5)   

    B)  SUM (A6: B6)

    C)  SUM (B1:B5)   

    D)  SUM (A1:B1)

    E)  SUM (B1:B6)

    Correct Answer: A

    Solution :

    [a] If you want to copy a formula and have the cell reference change depending on where you paste the formula, use a relative cell reference. When you copy a formula containing a relative cell reference, Excel automatically adjusts the cell reference to refer to the corresponding location. So, if you copy, =SUM (A1-A5) from cell A6 to cell B6, Excel stores the following formula in cell B6:=SUM (B1:B5)


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