Question 1

For a one-variable data table,you must specify both the row input cell and column input cell from the original data set.

Accepted Answer

A) True 
 B)False

Question 2

Match between columns
                        Premises: Color Scales
Highlight Cells Rules
Icon Sets
Data Bars
Top/Bottom Rules

Accepted Answer

The Answer of Applies a color gradient or solid fill is...

Question 3

All of the following are types of Solver reports EXCEPT ________.

Accepted Answer

A) Solver limits report 
B) Solver statistical report 
C) Solver population report 
D) Solver sensitivity report 
A) Solver limits report 
B) Solver statistical report 
C) Solver population report 
D) Solver sensitivity report

Question 4

The Scenario Manager has the ability to add,edit,and ________ scenarios.

Accepted Answer

The answer of The Scenario Manager has the ability to...

Question 5

The ________ solving method is the most complex because it is both nonlinear and nonsmooth.

Accepted Answer

A) Simplex LP method 
B) Evolutionary method 
C) GRG Nonlinear method 
D) Linear programming method 
A) Simplex LP method 
B) Evolutionary method 
C) GRG Nonlinear method 
D) Linear programming method

Question 6

What-if analysis tools can be found on the ________ tab.

Accepted Answer

The answer of What-if analysis tools can be found on...

Question 7

Which What-If Analysis tool would be best at comparing how interest rates affect a monthly car payment?

Accepted Answer

A) Goal Seek 
B) Scenario Manager 
C) One-variable data table 
D) Two-variable data table 
A) Goal Seek 
B) Scenario Manager 
C) One-variable data table 
D) Two-variable data table

Question 8

All of the following statements are TRUE about data tables EXCEPT:

Accepted Answer

A) A data table takes sets of input values, determines possible results, and displays all the results in one table on one worksheet. 
B) Although a data table is limited to only one or two variables, a data table can include as many different variable values as needed. 
C) Because data tables only focus on one or two variables, the results are easy to read and share in tabular form. 
D) Data tables are one of the four types of what-if analyses tools in Excel. 
A) A data table takes sets of input values, determines possible results, and displays all the results in one table on one worksheet. 
B) Although a data table is limited to only one or two variables, a data table can include as many different variable values as needed. 
C) Because data tables only focus on one or two variables, the results are easy to read and share in tabular form. 
D) Data tables are one of the four types of what-if analyses tools in Excel.

Question 9

Formulas that are used in a one-variable data table must refer to several input cells.

Accepted Answer

A) True 
 B)False

Question 10

The scroll bar is a type of scenario tool because of the ability to calculate numerous outputs in other cells by referencing the target cell in formulas and functions.

Accepted Answer

A) True 
 B)False

Question 11

The number of scenarios you can create is limitless.

Accepted Answer

A) True 
 B)False

Question 12

The last section of the Solver report displays information about the report.

Accepted Answer

A) True 
 B)False

Question 13

The Solver ________ Report shows the upper and lower bounds for the optimal value.

Accepted Answer

The answer of The Solver ________ Report shows the upper...

Question 14

Managers can use break-even analysis to calculate the break-even point in sales volume or dollars,estimate profit or loss at any level of sales volume,and help in setting prices.

Accepted Answer

A) True 
 B)False

Question 15

All of the following statements are TRUE regarding Solver EXCEPT:

Accepted Answer

A) Business managers can use Solver to minimize or maximize the output based on the constraints. 
B) The purpose of using Solver is to perform what-if analysis to solve more complex problems and to optimize the outcome. 
C) Prior to configuring the Solver variables, you need to ensure that you create a spreadsheet model that can be used to manipulate the values for your constraints. 
D) For the Solver to work properly, the formula in the result cell must reference and depend on the variable cells for part of its calculation. 
A) Business managers can use Solver to minimize or maximize the output based on the constraints. 
B) The purpose of using Solver is to perform what-if analysis to solve more complex problems and to optimize the outcome. 
C) Prior to configuring the Solver variables, you need to ensure that you create a spreadsheet model that can be used to manipulate the values for your constraints. 
D) For the Solver to work properly, the formula in the result cell must reference and depend on the variable cells for part of its calculation.

Question 16

A constraint that affects the optimal solution is considered a ________ constraint.

Accepted Answer

A) Binding 
B) Nonbinding 
C) Linear 
D) Model 
A) Binding 
B) Nonbinding 
C) Linear 
D) Model

Question 17

Excel contains three types of what-if analysis tools on the Data tab: Data table,Scenario Manager,and Goal Seek.

Accepted Answer

A) True 
 B)False

Question 18

The To value box in the Goal Seek dialog box contains ________.

Accepted Answer

A) a cell reference from the formula that can be adjusted to achieve the goal 
B) a formula 
C) the result desired for the formula 
D) a function 
A) a cell reference from the formula that can be adjusted to achieve the goal 
B) a formula 
C) the result desired for the formula 
D) a function

Question 19

The Solver ________ Report lists the objective cell and the changing cells with their corresponding original and final values for the problem,input variables,and constraints.

Accepted Answer

The answer of The Solver ________ Report lists the objective...

Question 20

By clicking the ________ button on the Solver Parameter dialog box,solver models can be saved.

Accepted Answer

The answer of By clicking the ________ button on the...

For a one-variable data table,you must specify both the row input cell and column input cell from the original data set.

All of the following are types of Solver reports EXCEPT ________.

The Scenario Manager has the ability to add,edit,and ________ scenarios.

The ________ solving method is the most complex because it is both nonlinear and nonsmooth.

What-if analysis tools can be found on the ________ tab.

Which What-If Analysis tool would be best at comparing how interest rates affect a monthly car payment?

All of the following statements are TRUE about data tables EXCEPT:

Formulas that are used in a one-variable data table must refer to several input cells.

The scroll bar is a type of scenario tool because of the ability to calculate numerous outputs in other cells by referencing the target cell in formulas and functions.

The number of scenarios you can create is limitless.

The last section of the Solver report displays information about the report.

The Solver ________ Report shows the upper and lower bounds for the optimal value.

Managers can use break-even analysis to calculate the break-even point in sales volume or dollars,estimate profit or loss at any level of sales volume,and help in setting prices.

All of the following statements are TRUE regarding Solver EXCEPT:

A constraint that affects the optimal solution is considered a ________ constraint.

Excel contains three types of what-if analysis tools on the Data tab: Data table,Scenario Manager,and Goal Seek.

The To value box in the Goal Seek dialog box contains ________.

The Solver ________ Report lists the objective cell and the changing cells with their corresponding original and final values for the problem,input variables,and constraints.

By clicking the ________ button on the Solver Parameter dialog box,solver models can be saved.

Navigate, manipulate, and Print Worksheets

Formatting, functions, and Formulas

Cell References, named Ranges, and Functions

Effective Charts

Complex Conditional and Retrieval Functions

Analyze Data Using Tables

Multiple Worksheets workbooks and Templates

Refine an Excel Application

Organize, import, export, and Cleanse Data Sets

Loan Amortization, investment Analysis, and Asset Depreciation

Business Statistics and Regression Analysis

Excels Data Model, Power-pivot, and Power View

Visual Basic for Applications

Appendix:efficient Interaction With a Touch Screen

The Common Features of Microsoft Office

Filters

Exam 10: Data Tables, scenario Manager, and Solver

For a one-variable data table,you must specify both the row input cell and column input cell from the original data set.

All of the following are types of Solver reports EXCEPT ________.

The Scenario Manager has the ability to add,edit,and ________ scenarios.

The ________ solving method is the most complex because it is both nonlinear and nonsmooth.

What-if analysis tools can be found on the ________ tab.

Which What-If Analysis tool would be best at comparing how interest rates affect a monthly car payment?

All of the following statements are TRUE about data tables EXCEPT:

Formulas that are used in a one-variable data table must refer to several input cells.

The scroll bar is a type of scenario tool because of the ability to calculate numerous outputs in other cells by referencing the target cell in formulas and functions.

The number of scenarios you can create is limitless.

The last section of the Solver report displays information about the report.

The Solver ________ Report shows the upper and lower bounds for the optimal value.

Managers can use break-even analysis to calculate the break-even point in sales volume or dollars,estimate profit or loss at any level of sales volume,and help in setting prices.

All of the following statements are TRUE regarding Solver EXCEPT:

A constraint that affects the optimal solution is considered a ________ constraint.

Excel contains three types of what-if analysis tools on the Data tab: Data table,Scenario Manager,and Goal Seek.

The To value box in the Goal Seek dialog box contains ________.

The Solver ________ Report lists the objective cell and the changing cells with their corresponding original and final values for the problem,input variables,and constraints.

By clicking the ________ button on the Solver Parameter dialog box,solver models can be saved.

Navigate, manipulate, and Print Worksheets

Formatting, functions, and Formulas

Cell References, named Ranges, and Functions

Effective Charts

Complex Conditional and Retrieval Functions

Analyze Data Using Tables

Multiple Worksheets workbooks and Templates

Refine an Excel Application

Organize, import, export, and Cleanse Data Sets

Loan Amortization, investment Analysis, and Asset Depreciation

Business Statistics and Regression Analysis

Excels Data Model, Power-pivot, and Power View

Visual Basic for Applications

Appendix:efficient Interaction With a Touch Screen

The Common Features of Microsoft Office

Filters