Multiple Choice
Match the following five terms to their meanings:
i.validation list
II.data validation
III.defined name
IV.Watch Window
v.scope
A) technique to improve accuracy when completing a worksheet
B) location within which a defined name is recognized without qualification
C) displays the results of specified cells
D) a list that controls type of data entered for a group of cells
E) word or string of characters that represents a cell,a range of cells,a formula,or a constant value
Correct Answer:

Verified
Correct Answer:
Verified
Q59: In a Lookup formula,the defined range is
Q60: An Excel function that looks up values
Q61: When creating a data table to calculate
Q62: When a new row is inserted into
Q63: Naming cells has no effect on the
Q65: Match the following five terms to their
Q66: A range of cells that shows how
Q67: The PMT function calculates the payment for
Q68: The process of changing the values in
Q69: The Error Checking command checks for common