MO-211 practice question 32 of 35
What is a relative reference in Excel?
Full set: 355 questionsDomain Insert and format text, shapes, and images
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.
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.
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."
Keep practicing
Take the free MO-211 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other MO-211 practice questions
- Question 1What formula can be used to calculate the sum of a range of cells in Excel?
- Question 2Which chart type is best used to display trends over time?
- Question 3What is the formula used in Excel to calculate the percentage change between two numbers?
- Question 4What is a slicer in Excel?
- Question 5What is the shortcut key to insert a new worksheet in Excel?
- Question 6What is the shortcut key for copying a formula in Excel?
