What is a lookup table used for?
A) It looks up a value and returns a related result.
B) It contains data for the basis of a lookup and the data to be retrieved.
C) It is the lowest value for a specific category or series.
D) It is a reference to a cell containing a value to look up.
Correct Answer:
Verified
Q18: How many arguments are required for the
Q20: Which of the following is FALSE about
Q21: To simplify entering ranges in formulas you
Q23: A nested function
A) contains data for the
Q25: In Excel 2013,the function name describes the
Q26: An argument is an operator such as
Q27: The formula =C4*D4 uses only relative cell
Q28: Which of the following is FALSE about
Q36: The breakpoint
A) looks up a value and
Q59: A circular reference occurs when a formula
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents