1. Which of
the following is true?
(Select all
correct answers)
a. VLOOKUP uses values in columns
b. VLOOKUP uses values in rows
c. HLOOKUP uses values in columns
d. HLOOKUP uses values in rows
Tip: Intermediate Excel, page 115
2. Lookup functions are found on the formula ribbon under Lookup &
Reference
a. True
b. False
Tip: Intermediate Excel, page 118
3. What does Col_index_num refer to?
a. Which column in the range has the data
b. Which column the data will be put into
c. There is an error in the formula
Tip: Intermediate Excel, page 119
4. It is
possible to select two, non-connected ranges in Excel
a. True
b. False
Tip: Intermediate Excel, page 122
5. The Scope of a defined range refers to whether the selected Defined
Name is available to one or all sheets in the workbook.
a. True
b. False
Tip: Intermediate Excel, page 128
6. Which of the following are Logic Functions? (Select all correct
answers.)
a. IF
b. AND
c. OR
d. NOT
Tip: Intermediate Excel, page 133
7. Match the
Error messages with their meaning.
a. #N/A
b. #VALUE
c. #REF!
d. #DIV/0!
e. #NAME!
f. #NULL!
g. #######
i. Can’t find the named range
ii. Column too narrow
iii. Different data types, such as adding a number to a date
iv. Divide by zero error
v. Lost cell reference
vi. Not enough data
vii. Refers to an empty cell with no data
Tip: Intermediate Excel, 137
