Cell references that remain fixed when a formula is copied to a new location are called _________.
A. phantom references
B. relative references
C. absolute references
D. pointer references
Fill in the blank(s) with the appropriate word(s).
absolute references
Rationale: Cell references that remain fixed when a formula is copied to a new location are called absolute references. In Excel, absolute references have a $ (dollar sign) before each column and row designation. See 14-1: Using Relative, Absolute, and Mixed Cell References in Formulas
You might also like to view...
The __________ approach to worksheet assessment involves the evaluation of each practice, followed by additional audits to ensure activities defined for a practice are in place.
Fill in the blank(s) with the appropriate word(s).
Which of the following statements is false?
a. JavaFX applications in which the GUI is implemented as FXML adhere to the Model-View-Controller (MVC) design pattern, which separates an app’s data (contained in the model) from the app’s GUI (the view) and the app’s processing logic (the controller). b. The model presents the data stored in the view. c. When a user provides input, the controller modifies the model with the given input. d. When the model changes, the controller updates the view to present the changed data.