Multiple Choice
Match the following five terms to their meanings:
i.What-If Analysis
II.Goal Seek
III.data table
IV.one-variable data table
v.two-variable data table
A) changes the values in two cells
B) process of changing the values in cells to see how those changes affect the outcome of formulas on the worksheet
C) changes the value in only one cell
D) method used to find a specific value for a cell by adjusting the value of another cell
E) a range of cells that shows how changing certain values in your formulas affects the results of those formulas
Correct Answer:

Verified
Correct Answer:
Verified
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
Q64: 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
Q70: A data tables is useful for all