Question 1

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 2

The what-if analysis tool best suited to evaluating multiple scenarios within a formula is ________.

Accepted Answer

The answer of The what-if analysis tool best suited to...

Question 3

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 4

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

Accepted Answer

A) True 
 B)False

Question 5

Which is the best what-if analysis tool to determine the optimal combination of products to produce in order to maximize profit?

Accepted Answer

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

Question 6

Which of these characters is not an acceptable character to use in a range name?

Accepted Answer

A) _ 
B) z 
C) ! 
D) 1 
A) _ 
B) z 
C) ! 
D) 1

Question 7

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 8

What tool would be most effective when comparing the impact of changes in interest rate and purchase price on a new car loan?

Accepted Answer

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

Question 9

What tool would you use to rename a named range?

Accepted Answer

A) A range cannot be renamed. 
B) Define Names 
C) Name Manager 
D) Range Tool 
A) A range cannot be renamed. 
B) Define Names 
C) Name Manager 
D) Range Tool

Question 10

Match between columns
                        Premises: Scenario
Scenario Manager
Scenario Summary PivotTable
Scenario Summary Report
Changing Cell

Accepted Answer

The Answer of Values that represent different possible situations and is...

Question 11

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 12

What is this an example of?

Accepted Answer

A) Solver Report 
B) Scenario Summary Report 
C) Goal Seek Report 
D) Multi-value Data Table 
A) Solver Report 
B) Scenario Summary Report 
C) Goal Seek Report 
D) Multi-value Data Table

Question 13

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 14

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

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

Accepted Answer

scenario s

Question 17

The ________ are the cells containing variables whose values change within the constraints until the objective cell reaches its optimum value.

Accepted Answer

A) goal seek cells 
B) changing variable cells 
C) objective cells 
D) constraints 
A) goal seek cells 
B) changing variable cells 
C) objective cells 
D) constraints

Question 18

Match between columns
                        Premises: 10YearGoal
Ten_Year_Goal!
Ten Year Goal
Goal10Year
Ten_Year_Goal

Accepted Answer

The Answer of No Special characters and Spaces are not is...

Question 19

The number of scenarios that Scenario Manager can manage is unlimited.

Accepted Answer

A) True 
 B)False

Question 20

Solver is an Excel Add-in.

Accepted Answer

A) True 
 B)False

How do you start Goal Seek?

The what-if analysis tool best suited to evaluating multiple scenarios within a formula is ________.

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.

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

Which is the best what-if analysis tool to determine the optimal combination of products to produce in order to maximize profit?

Which of these characters is not an acceptable character to use in a range name?

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

What tool would be most effective when comparing the impact of changes in interest rate and purchase price on a new car loan?

What tool would you use to rename a named range?

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

What is this an example of?

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

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

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

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

The ________ are the cells containing variables whose values change within the constraints until the objective cell reaches its optimum value.

The number of scenarios that Scenario Manager can manage is unlimited.

Solver is an Excel Add-in.

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

How do you start Goal Seek?

The what-if analysis tool best suited to evaluating multiple scenarios within a formula is ________.

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.

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

Which is the best what-if analysis tool to determine the optimal combination of products to produce in order to maximize profit?

Which of these characters is not an acceptable character to use in a range name?

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

What tool would be most effective when comparing the impact of changes in interest rate and purchase price on a new car loan?

What tool would you use to rename a named range?

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

What is this an example of?

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

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

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

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

The ________ are the cells containing variables whose values change within the constraints until the objective cell reaches its optimum value.

The number of scenarios that Scenario Manager can manage is unlimited.

Solver is an Excel Add-in.

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