Matching
Match the following terms with their definition.
Premises:
Cell reference
Named range
Mixed cell reference
Relative cell reference
Absolute cell reference
Responses:
Changes automatically when the formula or function is copied to another location
A combination of relative and absolute cell references
The exact address of a cell when both the column and the row need to remain constant
Refers to a particular cell or range of cells within a formula or function instead of a value
Group of cells that have been given a name
Correct Answer:
Premises:
Responses:
Cell reference
Named range
Mixed cell reference
Relative cell reference
Absolute cell reference
Premises:
Cell reference
Named range
Mixed cell reference
Relative cell reference
Absolute cell reference
Responses:
Related Questions
Q45: If you type =C,a list of functions
Q46: The result of =LEFT("Washington",4)is Wash.
Q47: B7 is an example of a(n)_ cell
Q48: Which of the following is NOT a
Q49: The _ logical function returns true only
Q51: The inputs used by an Excel function
Q52: If you wanted to determine how many
Q53: The _ function returns the number of
Q54: A(n)_ function determines if a statement is
Q55: The result of =ROUND(123.456,2)is _.