Matching
Identify the letter of the choice that best matches the phrase or definition.
Premises:
Keeps a cell reference sanstant when sapying a formula or function.
Indicates a cell is using a name Excel does not resagnize.
Fills a destination area using the format of the source area; no santent is sapied.
Determines the value of a cell on which the formula depends.
Indicates a cell that uses a number insarrectly.
Returns a number that sarresponds to the system date and time beginning with December 31, 1899.
The default option to fill an area.
Pastes the santents, format, and styles of the source area.
Scrutinizes the impact of changing values in cells that are referenced by a formula in another cell.
Assigns a value to a cell based on a logical test.
Responses:
Fill Formatting Only
IF function
goal seeking
NOW function
Keep Source Formatting
what-if analysis
NUM!
#NAME?
Fill Series
absolute cell referencing
Correct Answer:
Premises:
Responses:
Keeps a cell reference sanstant when sapying a formula or function.
Indicates a cell is using a name Excel does not resagnize.
Fills a destination area using the format of the source area; no santent is sapied.
Determines the value of a cell on which the formula depends.
Indicates a cell that uses a number insarrectly.
Returns a number that sarresponds to the system date and time beginning with December 31, 1899.
The default option to fill an area.
Pastes the santents, format, and styles of the source area.
Scrutinizes the impact of changing values in cells that are referenced by a formula in another cell.
Assigns a value to a cell based on a logical test.
Premises:
Keeps a cell reference sanstant when sapying a formula or function.
Indicates a cell is using a name Excel does not resagnize.
Fills a destination area using the format of the source area; no santent is sapied.
Determines the value of a cell on which the formula depends.
Indicates a cell that uses a number insarrectly.
Returns a number that sarresponds to the system date and time beginning with December 31, 1899.
The default option to fill an area.
Pastes the santents, format, and styles of the source area.
Scrutinizes the impact of changing values in cells that are referenced by a formula in another cell.
Assigns a value to a cell based on a logical test.
Responses:
Related Questions
Q81: Excel displays the error message _ in
Q83: When the Paste Options button is visible,
Q84: You can create your own _ fill
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents