Multiple Choice
Match the following five terms with their descriptions:
i.Trace Precedents command
II.Dependent cells
III.Trace Dependents command
IV.Trace Error command
v.Error checking command
A) Cells that contain formulas that refer to other cells
B) Checks for common errors that occur in formulas
C) Locates and resolves errors by tracing the selected error value
D) Displays arrows that indicate what cells affect the value of the selected cell
E) displays arrows that indicate what cells affect the value of the selected cell
Correct Answer:

Verified
Correct Answer:
Verified
Q1: All of the following are methods to
Q2: When you start typing a formula,such as
Q3: In the Excel PMT function,the term used
Q4: A method to find a specific value
Q5: _ functions look up a value in
Q7: _ is a technique in which you
Q8: A defined name that is distinctive and
Q9: You cannot insert new data into a
Q10: Excel includes a group of _ features,which
Q11: A(n)_ data table changes the value in