The Excel ________ Tool Allows the Creation of Sets of Values

question 57

Multiple Choice

The Excel ________ tool allows the creation of sets of values that are saved and can be substituted automatically on the worksheet.

• A)Data Table
• B)Scenario Manager
• C)Goal Seek
• D)Auto Outline

---

Definitions:

Excess Demand

When the quantity demanded of a good exceeds the quantity supplied.

Utilities Possibilities Frontier

A graphical representation that shows the maximum amount of two different utilities that can be achieved with a given set of resources.

Unattainable

Refers to goals, objectives, or levels of production that cannot be achieved with the current availability of resources or technology.

Utilities Possibilities Frontier

A graphical representation showing the maximum levels of utility that two individuals or more can achieve given a fixed set of resources.