Excel Unit K

Question 1

A worksheet you use to produce a what if analysis.

Answer 1

Model

Question 2

Cells that contain data rather than formulas then observe the effects on dependent cells.

Answer 2

Input Cells

Question 3

Usually contains a formula whose resulting value changes depending on the values in the input cells.

Answer 3

Dependent Cells

Question 4

A set of values you use to observe different worksheet results.

Answer 4

Scenario

Question 5

A changing value such as the price.

Answer 5

Variable

Question 6

Are those that will vary in the different scenarios.

Answer 6

Changing Cells

Question 7

Is an excel table that compiles data from the changing cells and corresponding result cells for each scenario.

Answer 7

Scenario Summary

Question 8

Is a range of cells that simultaneously shows the varying resulting values when you change one or more input values in a formula.

Answer 8

Data Table

Question 9

Is a table that shows the result of varying one input value such as the interest rate.

Answer 9

One-input data table

Question 10

These are the values in the data table.

Answer 10

Input Values

Question 11

It is what you want excel to use in calculating the resulting percentages.

Answer 11

Output Values

Question 12

You specify a solution then ask excel to find the input value that produces the answer you want.

Answer 12

Goal Seek

Question 13

Can save a significant amount of time.

Answer 13

Backsolving

Question 14

Contains a formula in which you can substitute values to find a specific value or goal.

Answer 14

Goal Cell

Question 15

Is a component you can add to a computer or other device to increase its capabilities.

Answer 15

Add-In

Question 16

An add-in program you can use in excel for what if analysis.

Answer 16

Target Cell

Question 17

Refers to the entities that make up an excel workbook.

Answer 17

Objective