Question 1

Which of these would be a good candidate for a one-variable data table and payment function?

Accepted Answer

A) Finding how much you can spend on a car with a specific goal of $450 per month payments 
B) Checking scenarios with variable interest rates and down payments 
C) Solving for a constraint of 3 years of payments 
D) Checking scenarios with variable down payments 
A) Finding how much you can spend on a car with a specific goal of $450 per month payments 
B) Checking scenarios with variable interest rates and down payments 
C) Solving for a constraint of 3 years of payments 
D) Checking scenarios with variable down payments

Question 2

Which is not true about Scenario Manager?

Accepted Answer

A) Is rarely used in business models 
B) Defines and manages up to 32 scenarios 
C) Provides more variability and details than a data table 
D) Used to provide best-case,worst-case,and most-likely scenarios. 
A) Is rarely used in business models 
B) Defines and manages up to 32 scenarios 
C) Provides more variability and details than a data table 
D) Used to provide best-case,worst-case,and most-likely scenarios.

Question 3

________ specify the restrictions or limitations imposed on a spreadsheet model as Solver finds an optimum value.

Accepted Answer

A) Accesses 
B) Objectives 
C) Variables 
D) Constraints 
A) Accesses 
B) Objectives 
C) Variables 
D) Constraints

Question 4

A(n)________ specifies the cell that contains a formula that produces the value to be optimized with Solver.

Accepted Answer

A) objective cell 
B) set value 
C) target cell 
D) variable cell 
A) objective cell 
B) set value 
C) target cell 
D) variable cell

Question 5

What is a scenario in Excel What-if analysis?

Accepted Answer

A) A two-variable goal seek tool 
B) Any what-if analysis 
C) A tool that changes one variable through several iterations 
D) Detailed set of values that represent different possible situations 
A) A two-variable goal seek tool 
B) Any what-if analysis 
C) A tool that changes one variable through several iterations 
D) Detailed set of values that represent different possible situations

Question 6

Match between columns
                        Premises: Scenario Manager
Two-variable data table
Solver
One-variable data table
Goal Seek

Accepted Answer

The Answer of You want to know how many products is...

Question 7

Discount Rate is a valid range name.

Accepted Answer

A) True 
 B)False

Question 8

Scenario manager is on the ________ tab.

Accepted Answer

The answer of Scenario manager is on the ________ tab....

Question 9

This what-if analysis tool is best suited to determine the input value needed to achieve a specific output.

Accepted Answer

The answer of This what-if analysis tool is best suited...

Question 10

________ results are mathematically feasible but physically impossible solutions such as producing a less than zero products.These should be constrained to be greater than zero in some situations.

Accepted Answer

The answer of ________ results are mathematically feasible but physically...

Question 11

What is a benefit of using a range name in Excel?

Accepted Answer

A) Range names are easier for people to remember than cell references. 
B) Range names inherently make calculations more accurate. 
C) Range names make the data more portable to other applications. 
D) Range names are required when using financial functions. 
A) Range names are easier for people to remember than cell references. 
B) Range names inherently make calculations more accurate. 
C) Range names make the data more portable to other applications. 
D) Range names are required when using financial functions.

Question 12

A Scenario Manager Summary report displays the single best input to achieve the desired outcome.

Accepted Answer

A) True 
 B)False

Question 13

The ________ are the cells containing variables whose values change within the constraints until the objective cell reaches its optimum value.

Accepted Answer

A) goal seek cells 
B) changing variable cells 
C) objective cells 
D) constraints 
A) goal seek cells 
B) changing variable cells 
C) objective cells 
D) constraints

Question 14

________ are the limits or restrictions placed on a Solver model.

Accepted Answer

The answer of ________ are the limits or restrictions placed...

Question 15

Solver is an Excel Add-in.

Accepted Answer

A) True 
 B)False

Question 16

Goal Seek differs from one and two-variable data table analysis by ________.

Accepted Answer

A) building a data table automatically 
B) providing a single best answer rather than a table of possible answers 
C) providing a row of possibilities 
D) providing an average of the possibilities 
A) building a data table automatically 
B) providing a single best answer rather than a table of possible answers 
C) providing a row of possibilities 
D) providing an average of the possibilities

Question 17

If you would like to determine how many bags of popcorn to sell at a profit margin of $5 to raise $100 and have no constraints,which what-if analysis tool should you choose?

Accepted Answer

The answer of If you would like to determine how...

Question 18

Given this worksheet,which cell would you use in the set cell:
Box in Goal Seek to see how expensive of a house you can afford and keep your Mortgage Payment at $650?

Accepted Answer

A) B3 
B) E3 
C) B2 
D) E5 
A) B3 
B) E3 
C) B2 
D) E5

Question 19

A(n)________ constraint does not restrict the target that Solver finds.

Accepted Answer

non-bindin

Question 20

A one-variable table may only be created vertically.

Accepted Answer

A) True 
 B)False

Which of these would be a good candidate for a one-variable data table and payment function?

Which is not true about Scenario Manager?

________ specify the restrictions or limitations imposed on a spreadsheet model as Solver finds an optimum value.

A(n)________ specifies the cell that contains a formula that produces the value to be optimized with Solver.

What is a scenario in Excel What-if analysis?

Discount Rate is a valid range name.

Scenario manager is on the ________ tab.

This what-if analysis tool is best suited to determine the input value needed to achieve a specific output.

________ results are mathematically feasible but physically impossible solutions such as producing a less than zero products.These should be constrained to be greater than zero in some situations.

What is a benefit of using a range name in Excel?

A Scenario Manager Summary report displays the single best input to achieve the desired outcome.

The ________ are the cells containing variables whose values change within the constraints until the objective cell reaches its optimum value.

________ are the limits or restrictions placed on a Solver model.

Solver is an Excel Add-in.

Goal Seek differs from one and two-variable data table analysis by ________.

If you would like to determine how many bags of popcorn to sell at a profit margin of $5 to raise $100 and have no constraints,which what-if analysis tool should you choose?

Given this worksheet,which cell would you use in the set cell: Box in Goal Seek to see how expensive of a house you can afford and keep your Mortgage Payment at $650?

A(n)________ constraint does not restrict the target that Solver finds.

A one-variable table may only be created vertically.

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivot-tables, and Pivot-charts

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Imports, xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, styles, and Macros

Office 2016 Common Features

Filters

Exam 6: What-If Analysis

Which of these would be a good candidate for a one-variable data table and payment function?

Which is not true about Scenario Manager?

________ specify the restrictions or limitations imposed on a spreadsheet model as Solver finds an optimum value.

A(n)________ specifies the cell that contains a formula that produces the value to be optimized with Solver.

What is a scenario in Excel What-if analysis?

Discount Rate is a valid range name.

Scenario manager is on the ________ tab.

This what-if analysis tool is best suited to determine the input value needed to achieve a specific output.

________ results are mathematically feasible but physically impossible solutions such as producing a less than zero products.These should be constrained to be greater than zero in some situations.

What is a benefit of using a range name in Excel?

A Scenario Manager Summary report displays the single best input to achieve the desired outcome.

The ________ are the cells containing variables whose values change within the constraints until the objective cell reaches its optimum value.

________ are the limits or restrictions placed on a Solver model.

Solver is an Excel Add-in.

Goal Seek differs from one and two-variable data table analysis by ________.

If you would like to determine how many bags of popcorn to sell at a profit margin of $5 to raise $100 and have no constraints,which what-if analysis tool should you choose?

Given this worksheet,which cell would you use in the set cell: Box in Goal Seek to see how expensive of a house you can afford and keep your Mortgage Payment at $650?

A(n)________ constraint does not restrict the target that Solver finds.

A one-variable table may only be created vertically.

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivot-tables, and Pivot-charts

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Imports, xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, styles, and Macros

Office 2016 Common Features

Filters