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

    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

    View Answer

    Workspace

    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