Solved

Match the Example with the Function or Feature

Question 16

Multiple Choice

Match the example with the function or feature:
i. =A54
II. =$A54
III. =$A$54
IV. =SUM(A54:B97)
v. "Ohio"

A) Function
B) Relative reference
C) Ensures text entry
D) Mixed reference
E) Absolute reference

Related Questions

Q10: The range that contains the lookup table

Q11: If A7=21, which of the following =IF

Q14: What is the term for the inputs

Q14: Excel assigns date number 1 to January

Q17: What action changes the actual number of

Q21: This is a valid way to use

Q59: Which of the following does not comply

Q79: The inputs in a function are specified

Q82: The _ function finds the smallest value

Q99: If you are looking up exact values