MO-211 practice question 32 of 35

What is a relative reference in Excel?

Full set: 355 questions

Domain Insert and format text, shapes, and images

Answer options
A: A reference to another worksheet or workbook.
B: A cell reference that changes based on the location of the formula. Correct answer
C: A cell reference that doesn't change when copied or moved.
Correct Answer:
B. A cell reference that changes based on the location of the formula.
Explanation

A relative cell reference is the default reference type in Excel. Its address is based on its position relative to the cell containing the formula. When a formula with a relative reference is copied or filled into other cells, the reference automatically adjusts to maintain the same relative offset. For instance, if the formula =A1 in cell C1 is copied to cell C2, it will change to =A2, reflecting the one-row shift. This dynamic behavior is fundamental for applying calculations across datasets efficiently.

Why Incorrect

A. This describes an external or 3-D reference, which points to cells in other worksheets or workbooks, a concept distinct from how a reference behaves when copied.
C. This is the definition of an absolute reference (e.g., $A$1), which is designed to remain constant and not change, regardless of where the formula is copied or moved.

References

1. Microsoft Corporation. (n.d.). Switch between relative

absolute

and mixed references. Microsoft Support. Retrieved from https://support.microsoft.com/en-us/office/switch-between-relative-absolute-and-mixed-references-dfec08cd-ae65-4f56-839e-5f0d8d0baca9.

Section: "Relative references"

Quote: "A relative cell reference in a formula

such as A1

is based on the relative position of the cell that contains the formula and the cell the reference refers to... If you copy or fill the formula across rows or down columns

the reference automatically adjusts."

2. University of Wisconsin-Madison

Division of Information Technology (DoIT). (2019

March 11). Excel - Relative and Absolute Cell References. UW-Madison KnowledgeBase. Retrieved from https://kb.wisc.edu/showcase/page.php?id=90313.

Section: "Relative Cell References"

Quote: "Relative cell references are the default in Excel. When you copy a formula with a relative cell reference

the reference will change based on its position."

3. Harvard University

Institute for Quantitative Social Science. (2018). Introduction to Microsoft Excel Handout. Retrieved from https://projects.iq.harvard.edu/files/harvard-intro-excel/files/day1handoutharvardintrotoexcel.pdf.

Page: 11

Section: "Relative vs. Absolute Cell References"

Quote: "By default

all cell references are relative references. When copied across multiple cells

they change based on the relative position of rows and columns."

Scroll to Top