Chapter Nine

Question 1

A problem-solving method that starts with a result and calculates the value needed to reach that result is:

Answer 1

Backsolving

Question 2

A column chart that illustrates the frequency of each data point in a data set is called a:

Answer 2

Histogram

Question 3

In regard to Solver, the formal-bearing cell that the user selects as the target to be solver for specific results is called an:

Answer 3

Objective Cell

Question 4

What is information used by Solver to find a solution?

Answer 4

Parameter

Question 5

A series of scenes created by 3D Map that visualizes your data is a:

Answer 5

Tour

Question 6

What is a worksheet with an Excel table and chart that illustrates past data and predicts future values generated from data in the worksheet?

Answer 6

Forecast Sheet

Question 7

A saved set of values in a worksheet that functions as a “what-if” analysis tool is a:

Answer 7

Scenario

Question 8

Summary measures for a data range such as the mean or average, the maximum, the minimum, or a count are:

Answer 8

Descriptive Statistics