Question 1

The biggest difference between Scenario Manager and Solver is Solver uses ________.

Accepted Answer

A) labels 
B) constraints 
C) solver scenarios 
D) the rank in the sort order dialog box 
A) labels 
B) constraints 
C) solver scenarios 
D) the rank in the sort order dialog box

Question 2

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 3

________ 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 4

A(n)________ is a program in Excel which provides enhanced capabilities over the base installation.

Accepted Answer

The answer of A(n)________ is a program in Excel which...

Question 5

Match between columns
                        Premises: Scenario Summary Report
Goal Seek Dialog Box
Scenario PivotTable
Optimization Model
Answer Report

Accepted Answer

The Answer of Tool to input the set cell, to is...

Question 6

A(n)________ is a label for a cell or range of cells which can be used in formulas.

Accepted Answer

The answer of A(n)________ is a label for a cell...

Question 7

Discount Rate is a valid range name.

Accepted Answer

A) True 
 B)False

Question 8

What selections in the File tab do you make to load an add-in?

Accepted Answer

A) Properties and then Solutions 
B) Properties and then Add-ins 
C) Options and then Solutions 
D) Options and then Add-ins 
A) Properties and then Solutions 
B) Properties and then Add-ins 
C) Options and then Solutions 
D) Options and then Add-ins

Question 9

You have a worksheet with a calculation to estimate production costs based on cost of raw materials, labor, fuel and delivery costs.You would like to see what would happen if the price of fuel and raw materials spiked.Which what-if analysis tool would be best?

Accepted Answer

A) Goal Seek 
B) Solver 
C) Data Tables 
D) Scenario Manager 
A) Goal Seek 
B) Solver 
C) Data Tables 
D) Scenario Manager

Question 10

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

Accepted Answer

non-bindin

Question 11

Solver has the ability to generate an answer report.

Accepted Answer

A) True 
 B)False

Question 12

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 13

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 14

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

Question 15

Scenario Manager is not an Excel Add-in.

Accepted Answer

A) True 
 B)False

Question 16

Match between columns
                        Premises: Non-binding constraint
Optimization model
Solver
Binding constraint
Objective cell

Accepted Answer

The Answer of A constraint that does not restrict the is...

Question 17

Where does Excel create a Scenario Summary report?

Accepted Answer

A) On a new worksheet 
B) On the same worksheet 
C) In a new workbook 
D) In a dialog box 
A) On a new worksheet 
B) On the same worksheet 
C) In a new workbook 
D) In a dialog box

Question 18

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 19

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

Accepted Answer

A) True 
 B)False

Question 20

How many scenarios can Scenario Manager manage?

Accepted Answer

The answer of How many scenarios can Scenario Manager manage?...

The biggest difference between Scenario Manager and Solver is Solver uses ________.

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

________ 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.

A(n)________ is a program in Excel which provides enhanced capabilities over the base installation.

A(n)________ is a label for a cell or range of cells which can be used in formulas.

Discount Rate is a valid range name.

What selections in the File tab do you make to load an add-in?

You have a worksheet with a calculation to estimate production costs based on cost of raw materials, labor, fuel and delivery costs.You would like to see what would happen if the price of fuel and raw materials spiked.Which what-if analysis tool would be best?

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

Solver has the ability to generate an answer report.

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

Which is not true about Scenario Manager?

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?

Scenario Manager is not an Excel Add-in.

Where does Excel create a Scenario Summary report?

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

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

How many scenarios can Scenario Manager manage?

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

The biggest difference between Scenario Manager and Solver is Solver uses ________.

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

________ 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.

A(n)________ is a program in Excel which provides enhanced capabilities over the base installation.

A(n)________ is a label for a cell or range of cells which can be used in formulas.

Discount Rate is a valid range name.

What selections in the File tab do you make to load an add-in?

You have a worksheet with a calculation to estimate production costs based on cost of raw materials, labor, fuel and delivery costs.You would like to see what would happen if the price of fuel and raw materials spiked.Which what-if analysis tool would be best?

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

Solver has the ability to generate an answer report.

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

Which is not true about Scenario Manager?

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?

Scenario Manager is not an Excel Add-in.

Where does Excel create a Scenario Summary report?

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

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

How many scenarios can Scenario Manager manage?

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