Question 1

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

Accepted Answer

Goal Seek

Question 2

Match between columns
                        Premises: Range name
Changing variable cell
What-if analysis
Variable
Substitution Value

Accepted Answer

The Answer of A word or string of characters that is...

Question 3

A variable is an input value that changes the outcome of the situation.

Accepted Answer

A) True 
 B)False  True

Question 4

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 5

The what-if analysis tool which uses two substitution values is a(n)________ data table.

Accepted Answer

two-variab

Question 6

Goal Seek would be the best what-if analysis tool to use to discover the necessary interest rate to keep your car payment below $500 per month.

Accepted Answer

A) True 
 B)False

Question 7

An objective cell is required to complete a Solver model.

Accepted Answer

A) True 
 B)False

Question 8

If you set up a two-variable data table to calculate monthly payments on different interest rates and loan terms, what values would be a likely set of entries in the left column of your data table?

Accepted Answer

A) $150,000, $160,000, $170,000 
B) APR 
C) 3.0%, 3.25%, 3.5%, 3.75% 
D) $583.73, $630.02, $659.97 
A) $150,000, $160,000, $170,000 
B) APR 
C) 3.0%, 3.25%, 3.5%, 3.75% 
D) $583.73, $630.02, $659.97

Question 9

Business managers often create ________ /worst-case scenarios.

Accepted Answer

best-case,

Question 10

A(n)________ is a rule that Solver has to enforce to reach the objective value.

Accepted Answer

The answer of A(n)________ is a rule that Solver has...

Question 11

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 12

A one-variable table may only be created vertically.

Accepted Answer

A) True 
 B)False

Question 13

Solver does not support which of the following calculations on the target cell?

Accepted Answer

A) Maximize 
B) Range 
C) Minimize 
D) Exact Value 
A) Maximize 
B) Range 
C) Minimize 
D) Exact Value

Question 14

You do need to use an absolute cell reference when copying formulas with named ranges.

Accepted Answer

A) True 
 B)False

Question 15

Solver is on the Formulas tab.

Accepted Answer

A) True 
 B)False

Question 16

Match between columns
                        Premises: Add-in
Binding constraint
Changing variable cell
Constraint
Solver

Accepted Answer

The Answer of Manipulates variables based on constraints to find is...

Question 17

Goal Seek changes multiple variables to reach the optimal goal

Accepted Answer

A) True 
 B)False

Question 18

Associate the following concepts with its corresponding what-if analysis tool.
I.Answer Report
II.PivotTable
III.Set Cell
IV.Change interest rate
V.Change term and down payment
A.Goal Seek
B.Solver
C.One-variable data table
D.Two-variable data table
E.Scenario Manager

Accepted Answer

The answer of Associate the following concepts with its corresponding...

Question 19

If Solver is installed on your computer, it will display on the ________ tab.

Accepted Answer

The answer of If Solver is installed on your computer,...

Question 20

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

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

A variable is an input value that changes the outcome of the situation.

What is a scenario in Excel What-if analysis?

The what-if analysis tool which uses two substitution values is a(n)________ data table.

Goal Seek would be the best what-if analysis tool to use to discover the necessary interest rate to keep your car payment below $500 per month.

An objective cell is required to complete a Solver model.

If you set up a two-variable data table to calculate monthly payments on different interest rates and loan terms, what values would be a likely set of entries in the left column of your data table?

Business managers often create ________ /worst-case scenarios.

A(n)________ is a rule that Solver has to enforce to reach the objective value.

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

A one-variable table may only be created vertically.

Solver does not support which of the following calculations on the target cell?

You do need to use an absolute cell reference when copying formulas with named ranges.

Solver is on the Formulas tab.

Goal Seek changes multiple variables to reach the optimal goal

Associate the following concepts with its corresponding what-if analysis tool. I.Answer Report II.PivotTable III.Set Cell IV.Change interest rate V.Change term and down payment A.Goal Seek B.Solver C.One-variable data table D.Two-variable data table E.Scenario Manager

If Solver is installed on your computer, it will display on the ________ tab.

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

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivottables, and Pivotcharts

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Imports, Xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, Styles, and Macros

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters

Exam 6: What-If Analysis

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

A variable is an input value that changes the outcome of the situation.

What is a scenario in Excel What-if analysis?

The what-if analysis tool which uses two substitution values is a(n)________ data table.

Goal Seek would be the best what-if analysis tool to use to discover the necessary interest rate to keep your car payment below $500 per month.

An objective cell is required to complete a Solver model.

If you set up a two-variable data table to calculate monthly payments on different interest rates and loan terms, what values would be a likely set of entries in the left column of your data table?

Business managers often create ________ /worst-case scenarios.

A(n)________ is a rule that Solver has to enforce to reach the objective value.

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

A one-variable table may only be created vertically.

Solver does not support which of the following calculations on the target cell?

You do need to use an absolute cell reference when copying formulas with named ranges.

Solver is on the Formulas tab.

Goal Seek changes multiple variables to reach the optimal goal

Associate the following concepts with its corresponding what-if analysis tool. I.Answer Report II.PivotTable III.Set Cell IV.Change interest rate V.Change term and down payment A.Goal Seek B.Solver C.One-variable data table D.Two-variable data table E.Scenario Manager

If Solver is installed on your computer, it will display on the ________ tab.

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

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivottables, and Pivotcharts

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Imports, Xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, Styles, and Macros

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters