Question 1

Which of the following is not a solving method supported by Solver?

Accepted Answer

A) GRG nonlinear 
B) Simplex LP 
C) Duplex 
D) Evolutionary 
A) GRG nonlinear 
B) Simplex LP 
C) Duplex 
D) Evolutionary

Question 2

The ________ specifies the cell containing the formula that produces a value for Solver to optimize.

Accepted Answer

The answer of The ________ specifies the cell containing the...

Question 3

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

Accepted Answer

A) binding constraint 
B) non-binding constraint 
C) objective 
D) solving method 
A) binding constraint 
B) non-binding constraint 
C) objective 
D) solving method

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

Goal Seek has the ability to restrict variables to integers and greater than zero numbers.

Accepted Answer

A) True 
 B)False

Question 6

Goal Seek changes multiple variables to reach the optimal goal

Accepted Answer

A) True 
 B)False

Question 7

Which of these is not part of the Goal Seek dialog box inputs?

Accepted Answer

A) Set cell: 
B) To value: 
C) By changing cell: 
D) Function: 
A) Set cell: 
B) To value: 
C) By changing cell: 
D) Function:

Question 8

The limit of no more than a $50,000 down payment is an example of a(n)________ when calculating the optimal combination of down payment and interest rate to purchase a new printing press.

Accepted Answer

A) variable 
B) set value 
C) constraint 
D) objective 
A) variable 
B) set value 
C) constraint 
D) objective

Question 9

The What-If Analysis tool is on the ________ tab.

Accepted Answer

A) Data 
B) Home 
C) View 
D) Insert 
A) Data 
B) Home 
C) View 
D) Insert

Question 10

________ can define 32 different scenarios for comparison.

Accepted Answer

The answer of ________ can define 32 different scenarios for...

Question 11

Solver is on the Formulas tab.

Accepted Answer

A) True 
 B)False

Question 12

How do you start Goal Seek?

Accepted Answer

A) Install the Goal Seek add-in. 
B) Click Goal Seek on the Formulas tab. 
C) Click What-If Analysison the Data tab and then select Goal Seek 
D) Click Scenario Manager on the Data tab and then select Goal Seek. 
A) Install the Goal Seek add-in. 
B) Click Goal Seek on the Formulas tab. 
C) Click What-If Analysison the Data tab and then select Goal Seek 
D) Click Scenario Manager on the Data tab and then select Goal Seek.

Question 13

A list of active and inactive Add-ins is in the ________.

Accepted Answer

A) Options dialog box 
B) Properties Pane 
C) Add-ins dialog box 
D) View tab 
A) Options dialog box 
B) Properties Pane 
C) Add-ins dialog box 
D) View tab

Question 14

How many variables does Goal Seek change with each time it is run?

Accepted Answer

A) 2 
B) 1 
C) up to 3 
D) unlimited 
A) 2 
B) 1 
C) up to 3 
D) unlimited

Question 15

An objective cell is required to complete a Solver model.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

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

Question 17

A one-variable data table would be the appropriate what-if analysis tool to compare loans with variable time period and interest rates.

Accepted Answer

A) True 
 B)False

Question 18

Business managers often create ________ /worst-case scenarios.

Accepted Answer

The answer of Business managers often create ________ /worst-case scenarios....

Question 19

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

Accepted Answer

two-variab

Question 20

If cell B5 contains the value 6 and is named Quantity and cell C6 contains the value 3 and is named Unit_Price,what would the formula =Quantity*Unit_Price display in D6?

Accepted Answer

A) Quantity*Unit_Price 
B) 18 
C) 9 
D) #ERROR 
A) Quantity*Unit_Price 
B) 18 
C) 9 
D) #ERROR

Which of the following is not a solving method supported by Solver?

The ________ specifies the cell containing the formula that produces a value for Solver to optimize.

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

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

Goal Seek has the ability to restrict variables to integers and greater than zero numbers.

Goal Seek changes multiple variables to reach the optimal goal

Which of these is not part of the Goal Seek dialog box inputs?

The limit of no more than a $50,000 down payment is an example of a(n)________ when calculating the optimal combination of down payment and interest rate to purchase a new printing press.

The What-If Analysis tool is on the ________ tab.

________ can define 32 different scenarios for comparison.

Solver is on the Formulas tab.

How do you start Goal Seek?

A list of active and inactive Add-ins is in the ________.

How many variables does Goal Seek change with each time it is run?

An objective cell is required to complete a Solver model.

A one-variable data table would be the appropriate what-if analysis tool to compare loans with variable time period and interest rates.

Business managers often create ________ /worst-case scenarios.

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

If cell B5 contains the value 6 and is named Quantity and cell C6 contains the value 3 and is named Unit_Price,what would the formula =Quantity*Unit_Price display in D6?

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 the following is not a solving method supported by Solver?

The ________ specifies the cell containing the formula that produces a value for Solver to optimize.

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

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

Goal Seek has the ability to restrict variables to integers and greater than zero numbers.

Goal Seek changes multiple variables to reach the optimal goal

Which of these is not part of the Goal Seek dialog box inputs?

The limit of no more than a $50,000 down payment is an example of a(n)________ when calculating the optimal combination of down payment and interest rate to purchase a new printing press.

The What-If Analysis tool is on the ________ tab.

________ can define 32 different scenarios for comparison.

Solver is on the Formulas tab.

How do you start Goal Seek?

A list of active and inactive Add-ins is in the ________.

How many variables does Goal Seek change with each time it is run?

An objective cell is required to complete a Solver model.

A one-variable data table would be the appropriate what-if analysis tool to compare loans with variable time period and interest rates.

Business managers often create ________ /worst-case scenarios.

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

If cell B5 contains the value 6 and is named Quantity and cell C6 contains the value 3 and is named Unit_Price,what would the formula =Quantity*Unit_Price display in D6?

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