Question 1

Where would you setup the two substitution values in a two-variable data table?

Accepted Answer

A) In the first row and first column in the table 
B) In the Series dialog box 
C) In the bottom row and last column 
D) Excel does this for you. 
A) In the first row and first column in the table 
B) In the Series dialog box 
C) In the bottom row and last column 
D) Excel does this for you. A

Question 2

If you are analyzing how much a 30 year mortgage would cost with different interest rates,the interest rate would be the ________ value in the what-if scenario.

Accepted Answer

substitution

Question 3

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 A

Question 4

If Solver is loaded,it will appear on this tab.

Accepted Answer

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

Question 5

How many scenarios can Scenario Manager manage?

Accepted Answer

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

Question 6

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

Accepted Answer

The Answer of Cell that contains the formula to produce is...

Question 7

A(n)________ is the changeable input value used in a what-if analysis.

Accepted Answer

The answer of A(n)________ is the changeable input value used...

Question 8

Goal Seek is a what-if analysis tool.

Accepted Answer

A) True 
 B)False

Question 9

________ analysis enables you to compare how changes affect a related outcome.

Accepted Answer

The answer of ________ analysis enables you to compare how...

Question 10

A(n)________ is a structured report organized as a worksheet to summarize multiple scenarios.

Accepted Answer

scenario s

Question 11

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

Accepted Answer

The Answer of Finds the best way to optimize values is...

Question 12

To add a column header of Payment for the calculation column in a one-variable data table,Select the cell with the calculation formula and then ________.

Accepted Answer

A) type Payment in the cell and format as desired 
B) select Custom Number format and type Payment in the type box 
C) select Custom Number format and type "Payment" in the type box 
D) open the one-variable analysis dialog and type Payment in the header field 
A) type Payment in the cell and format as desired 
B) select Custom Number format and type Payment in the type box 
C) select Custom Number format and type "Payment" in the type box 
D) open the one-variable analysis dialog and type Payment in the header field

Question 13

What-if analysis always provides a definitive solution to a problem.

Accepted Answer

A) True 
 B)False

Question 14

Solver has the ability to generate an answer report.

Accepted Answer

A) True 
 B)False

Question 15

________ is an add-in application that searches for the optimum solution by manipulating variables using constraints you set.

Accepted Answer

The answer of ________ is an add-in application that searches...

Question 16

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

Accepted Answer

The Answer of Cell containing a variable whose value changes is...

Question 17

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

Accepted Answer

The Answer of Organizes the results from a set of is...

Question 18

What is an Excel Add-in?

Accepted Answer

A) All what-if analysis tools 
B) Printer drivers 
C) A program that you can add to Excel to enhance functionality 
D) A feature installed by default in Excel 
A) All what-if analysis tools 
B) Printer drivers 
C) A program that you can add to Excel to enhance functionality 
D) A feature installed by default in Excel

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

A one-variable data table can be built ________.

Accepted Answer

A) vertically 
B) horizontally 
C) in column A 
D) either horizontally or vertically 
A) vertically 
B) horizontally 
C) in column A 
D) either horizontally or vertically

Where would you setup the two substitution values in a two-variable data table?

If you are analyzing how much a 30 year mortgage would cost with different interest rates,the interest rate would be the ________ value in the what-if scenario.

Where does Excel create a Scenario Summary report?

If Solver is loaded,it will appear on this tab.

How many scenarios can Scenario Manager manage?

A(n)________ is the changeable input value used in a what-if analysis.

Goal Seek is a what-if analysis tool.

________ analysis enables you to compare how changes affect a related outcome.

A(n)________ is a structured report organized as a worksheet to summarize multiple scenarios.

To add a column header of Payment for the calculation column in a one-variable data table,Select the cell with the calculation formula and then ________.

What-if analysis always provides a definitive solution to a problem.

Solver has the ability to generate an answer report.

________ is an add-in application that searches for the optimum solution by manipulating variables using constraints you set.

What is an Excel Add-in?

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

A one-variable data table can be built ________.

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

Where would you setup the two substitution values in a two-variable data table?

If you are analyzing how much a 30 year mortgage would cost with different interest rates,the interest rate would be the ________ value in the what-if scenario.

Where does Excel create a Scenario Summary report?

If Solver is loaded,it will appear on this tab.

How many scenarios can Scenario Manager manage?

A(n)________ is the changeable input value used in a what-if analysis.

Goal Seek is a what-if analysis tool.

________ analysis enables you to compare how changes affect a related outcome.

A(n)________ is a structured report organized as a worksheet to summarize multiple scenarios.

To add a column header of Payment for the calculation column in a one-variable data table,Select the cell with the calculation formula and then ________.

What-if analysis always provides a definitive solution to a problem.

Solver has the ability to generate an answer report.

________ is an add-in application that searches for the optimum solution by manipulating variables using constraints you set.

What is an Excel Add-in?

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

A one-variable data table can be built ________.

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