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
Q36: Which of the following is not a
Q39: When assigned to a cell, the _
Q41: Excel allows you to rotate text in
Q42: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TBX9085/.jpg" alt=" In the acsampanying
Q45: The range of entries that identifies the
Q55: A(n)_ IF function is one in which
Q74: Which of the following is the path
Q80: The underline format underlines the entire cell,not
Q86: If you enter 90 in the Degrees
Q87: When Excel cannot calculate a formula,it displays