Home / Computer Fundamentals / MS Excel :: Discussion

Discussion :: MS Excel

  1. What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)

  2. A.

     An absolute cell address is created


     Cell address will change when it is copied to another cell


     The sheet tab is changed


     The status bar does not display the cell address

    View Answer


    Answer : Option A

    Explanation :

    The absolute cell reference in excel is a cell address that contains a dollar sign ($). It can precede the column reference, the row reference or both.

Be The First To Comment