Home / Computer Fundamentals / MS Excel :: Discussion

Discussion :: MS Excel

  1. Which of the following is an absolute cell reference?

  2. A.

     !A!1

    B.

     $A$1

    C.

     #a#1

    D.

     A1

    View Answer

    Workspace

    Answer : Option B

    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