Exam 10: Data Tables, scenario Manager, and Solver

A manager may want to highlight cells for employees who exceeded monthly sales quotas or products that are selling below cost.This is an example of ________.

(Multiple Choice)

4.8/5

(37)

Question 61

Which of the following is NOT in the What-If Analysis command in the Data Tools group on the Data tab?

(Multiple Choice)

5.0/5

(42)

Question 62

In the Scenario Manager dialog box,click ________ to start creating your first scenario.

(Short Answer)

4.9/5

(39)

Question 63

________ are rules you establish when formulating your Solver model.

(Multiple Choice)

4.8/5

(41)

Question 64

Which of the following is TRUE about scenario reports?

(Multiple Choice)

4.9/5

(42)

Question 65

The Goal Seek command is located in the What-If Analysis tool of the ________ tab.

(Short Answer)

4.9/5

(31)

Question 66

Goal Seek repeatedly enters new values in the variable cell through a process called ________.

(Short Answer)

4.8/5

(37)

Question 67

Which of the following is NOT one of the three parameters in Solver?

(Multiple Choice)

4.7/5

(34)

Question 68

A(n)________ is an application with specific functionality geared toward accomplishing a specific goal.

(Multiple Choice)

4.9/5

(32)

Question 69

The value you want to achieve in Goal Seek needs to be entered in the To value box in the Goal Seek dialog box.

(True/False)

4.8/5

(43)

Question 70

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

(Multiple Choice)

4.8/5

(31)

Question 71

Click the ________ button in the Scenario Manager dialog box to view scenario report options.

(Short Answer)

4.9/5

(32)

Question 72

In the Goal Seek dialog box,the ________ box must contain a formula.

(Multiple Choice)

4.8/5

(39)

Question 73

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

(Multiple Choice)

4.9/5

(29)

Question 74

Managers use ________ to determine the minimum volume the business needs to make and sell if it is a manufacturer,or buy and sell if it is a retail business,to be sustainable.

(Short Answer)

5.0/5

(32)

Question 75

Match the following terms to their description.

Unit elasticity

If the elasticity is less than one,large changes in price will cause small changes in demand.

Perfectly inelastic

If the elasticity is greater than one,demand is very responsive to changes in price.

Perfectly elastic

For high elasticity values,any change in price causes a vast change in demand.

Correct Answer:

Verified

Unit elasticity

Perfectly inelastic

Perfectly elastic

Relatively inelastic

Relatively elastic

(Matching)

5.0/5

(40)

Question 76

If a product or service is not responsive to change,it is inelastic.

(True/False)

4.8/5

(46)

Question 77

Solver models can be saved and restored by clicking the Load/Save button on the ________ dialog box.

(Multiple Choice)

4.9/5

(42)

Question 78

The Scenario Manager dialog box enables you to do all of the following EXCEPT ________.

(Multiple Choice)

4.9/5

(42)

Question 79

In Solver,the recommended first step to creating an analysis is deciding on a(n)________.

(Short Answer)

4.9/5

(34)

Question 80

A manager may want to highlight cells for employees who exceeded monthly sales quotas or products that are selling below cost.This is an example of ________.

Which of the following is NOT in the What-If Analysis command in the Data Tools group on the Data tab?

In the Scenario Manager dialog box,click ________ to start creating your first scenario.

________ are rules you establish when formulating your Solver model.

Which of the following is TRUE about scenario reports?

The Goal Seek command is located in the What-If Analysis tool of the ________ tab.

Goal Seek repeatedly enters new values in the variable cell through a process called ________.

Which of the following is NOT one of the three parameters in Solver?

A(n)________ is an application with specific functionality geared toward accomplishing a specific goal.

The value you want to achieve in Goal Seek needs to be entered in the To value box in the Goal Seek dialog box.

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

Click the ________ button in the Scenario Manager dialog box to view scenario report options.

In the Goal Seek dialog box,the ________ box must contain a formula.

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

Managers use ________ to determine the minimum volume the business needs to make and sell if it is a manufacturer,or buy and sell if it is a retail business,to be sustainable.

If a product or service is not responsive to change,it is inelastic.

Solver models can be saved and restored by clicking the Load/Save button on the ________ dialog box.

The Scenario Manager dialog box enables you to do all of the following EXCEPT ________.

In Solver,the recommended first step to creating an analysis is deciding on a(n)________.

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