Relative and absolute cell references – Excel MCQs

By: Prof. Dr. Fazal Rehman Shamil | Last updated: July 31, 2024

  1. Which type of cell reference changes when copied to another cell?
    a) Absolute reference
    b) Relative reference
    c) Mixed reference
    d) Static reference
    Answer: b) Relative reference
  2. Which type of cell reference remains constant no matter where it is copied?
    a) Relative reference
    b) Absolute reference
    c) Mixed reference
    d) Dynamic reference
    Answer: b) Absolute reference
  3. What symbol is used to indicate an absolute cell reference in Excel?
    a) #
    b) &
    c) $
    d) *
    Answer: c) $
  4. If a cell contains the formula =A1+B1 and it is copied to the right by one cell, what will the new formula be?
    a) =A1+B1
    b) =A2+B2
    c) =B1+C1
    d) =B1+C2
    Answer: c) =B1+C1
  5. How would you write an absolute reference for cell A1?
    a) $A$1
    b) A1
    c) $A1
    d) A$1
    Answer: a) $A$1
  6. Which of the following is an example of a mixed cell reference?
    a) $A$1
    b) A1
    c) $A1
    d) A$1
    Answer: c) $A1 and d) A$1
  7. What will be the result of copying the formula =$A$1*B1 from cell C1 to cell D2?
    a) =$A$1B2
    b) =$A$1    C2
    c) =$A$1B1
    d) =A1    B1
    Answer: a) =$A$1*B2
  8. If you want to keep the column constant but allow the row to change, how would you write the cell reference for A1?
    a) $A$1
    b) A$1
    c) $A1
    d) A1
    Answer: c) $A1
  9. Which type of cell reference is used by default in Excel formulas?
    a) Absolute reference
    b) Relative reference
    c) Mixed reference
    d) Dynamic reference
    Answer: b) Relative reference
  10. If the formula =B$2+C$3 is copied from cell A1 to B2, what will be the new formula?
    a) =C$2+D$3
    b) =B$2+C$3
    c) =B$3+C$4
    d) =C$3+D$4
    Answer: b) =B$2+C$3

Related Posts: