Multiple Choice
____ lookup tables are commonly used to find a taxpayer's tax rate in a tax table,find a shipping charge based on the weight of a package in a shipping charges table,or determine a student's letter grade from a table of grading criteria.
A) Range
B) Approximate
C) Calculated
D) Exact match
Correct Answer:

Verified
Correct Answer:
Verified
Q24: The ORERROR function can determine if a
Q34: To evaluate a condition in Excel,you use
Q36: To filter records by color,click the filter
Q38: To highlight duplicate values,in the Styles group
Q39: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB5278/.jpg" alt=" -Given the flowchart
Q53: When a lookup table is used with
Q55: MATCHING<br>Identify the letter of the choice that
Q59: When you create a calculated column you
Q79: A formula that includes a structured reference
Q121: To retrieve a particular value from a