Matching
Match the following terms to their definition.
Premises:
Name Manager
Mixed cell reference
Named range
Syntax
Flash Fill
Responses:
Recognizes patterns as you type and automatically enters in values
Used to create,edit,delete,or troubleshoot named ranges
Combination of absolute and relative addressing
Group of cells that have been given a name for use within a formula
Structure and order of a function and its arguments
Correct Answer:
Premises:
Responses:
Name Manager
Mixed cell reference
Named range
Syntax
Flash Fill
Premises:
Name Manager
Mixed cell reference
Named range
Syntax
Flash Fill
Responses:
Related Questions
Q12: Match the following functions to their definition.
Q14: When cell D3 containing the formula =$B$5^$C$6
Q15: Function arguments are enclosed in a pair
Q18: The result of =FIND("is","Mississippi",3)is _.<br>A)2<br>B)4<br>C)5<br>D)6
Q19: The result of =PROPER("KANSAS")is _.
Q20: _ indicates that an error occurred when
Q22: Excel's _ returns the current date and
Q24: The TRIM function returns text from which
Q53: The _ function returns the number of
Q80: An absolute cell reference is denoted by