Relative and absolute cell references – Excel MCQs
By: Prof. Dr. Fazal Rehman | Last updated: July 31, 2024
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
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
What symbol is used to indicate an absolute cell reference in Excel?
a) #
b) &
c) $
d) *
Answer: c) $
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
How would you write an absolute reference for cell A1?
a) $A$1
b) A1
c) $A1
d) A$1
Answer: a) $A$1
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
What will be the result of copying the formula =$A$1*B1 from cell C1 to cell D2?
a) =$A$1B2
b) =$A$1C2
c) =$A$1B1
d) =A1B1
Answer: a) =$A$1*B2
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
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
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
