2. Questions Bank
  3. 9th Class
  4. Computers Science
  5. Microsoft Excel

9th Class Computers Science Microsoft Excel Question Bank MS-Excel 2010

  • question_answer
    Presence of dollar sign (\[\$\]) before a row and column number, in a cell range for example, \[\$C\$7:\$D\$10\] indicates that ___________.

    A) An absolute cell reference is created

    B) Cell address will change when it is copied to another cell

    C) The sheet tab is changed

    D) The status bar does not display the cell address

    Correct Answer: A

    Solution :

    Absolute reference is used to keep a row and/or column constant, because they do not change when copied or filled.


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