Matching
Match the example with the function or feature:
Premises:
=$A$54
=A54
=$A54
=SUM(A54:B97)
"Ohio"
Responses:
Mixed reference
Ensures text entry
Function
Absolute reference
Relative reference
Correct Answer:
Premises:
Responses:
=$A$54
=A54
=$A54
=SUM(A54:B97)
"Ohio"
Premises:
=$A$54
=A54
=$A54
=SUM(A54:B97)
"Ohio"
Responses:
Related Questions
Q6: Match the result with the function using
Q14: Match the following terms with their description:
Q19: What describes a function's purpose?<br>A)Arguments<br>B)Name<br>C)Category<br>D)Variables
Q24: The most used logical function is the
Q26: The MIN and MAX functions can be
Q40: What type of cell reference should be
Q47: What error will you get if you
Q54: The _ function finds the largest value
Q63: If a cell containing =B$14 is copy
Q99: If you are looking up exact values