A cell reference that is interpreted in relation to the location of the cell containing the formula is called _________.
A. absolute reference
B. pointer reference
C. phantom reference
D. relative reference
Fill in the blank(s) with the appropriate word(s).
relative reference
Rationale: A cell reference that is interpreted in relation to the location of the cell containing the formula is called relative reference. A relative reference is always interpreted in relation, or relative, to the location of the cell containing the formula. See 14-1: Using Relative, Absolute, and Mixed Cell References in Formulas
You might also like to view...
A(n) ________ is a small, miniature graphic of a slide that appears in the Slides tab
Fill in the blank(s) with correct word
Information architects work as independent ____________________ or as part of in-house Web design teams.
Fill in the blank(s) with the appropriate word(s).
Each time that your portable media player is connected to your computer, the ____ can copy podcast files to it.
A. Windows Media Player program B. software that manages your multimedia content C. browser with your podcast plugin D. Web-based feed reader
Case-Based Critical Thinking Questions ? Case 5-2 Cali has just discovered the power of using text filters to control which records display in his worksheet, and he has begun to use them often to find precisely the records he needs. The following questions are based on a camp directory table that includes First Name, Last Name, Date of Birth, Camp, and Phone Number. ? ? If Cali wants to find all of his campers whose last names end in "son" (such as Samson and Colson), what should he do?
A. Create a text filter using the Ends With operator to display all records that have cson as the last characters in the text value. B. Create a text filter using the Contains operator to display all records that include son in the text value. C. Create a text filter using the Ends With operator to display all records that have son as the last characters in the text value. D. Create a text filter using the Contains operator to display all records that have son as the last characters in the text value.