Exam 10: Performing What-If Analyses

In measuring elasticity,as the value of e increases,the result is that any change in price causes a huge change in demand,resulting in a ____ relationship between price and demand.

(Multiple Choice)

4.9/5

(36)

Question 81

Once you enter an array formula,Excel will enclose the formula in a set of ____.

(Multiple Choice)

4.9/5

(42)

Question 82

Which of the following reports is used to quantify the reliability of a solution?

(Multiple Choice)

4.7/5

(43)

Question 83

With Goal Seek,Excel changes the ____ values to produce the result values you are looking for.

(Multiple Choice)

4.8/5

(42)

Question 84

A(n)mixed expense is an expense that is part variable and part fixed._________________________

(True/False)

4.8/5

(33)

Question 85

MATCHING Identify the letter of the choice that best matches the phrase or definition. -When any change in price is met by an equal and opposite change in demand

(Multiple Choice)

4.7/5

(39)

Question 86

The Scenario Manager refers to ____________________ cells as changing cells because these worksheet cells contain values that are changed under the scenario.

(Short Answer)

4.9/5

(36)

Question 87

When using Goal Seek,select the ____ cell in the Set cell box,and then specify its value (goal)in the To value box.

(Multiple Choice)

4.8/5

(35)

Question 88

A(n)____ is a limit that is placed on a Solver problem's solution.

(Multiple Choice)

4.8/5

(36)

Question 89

To open the dialog box in the accompanying figure,click the What-If Analysis button in the ____ group.

(Multiple Choice)

4.8/5

(36)

Question 90

In Solver,changing cells are sometimes referred to as ____ cells.

(Multiple Choice)

4.7/5

(41)

Question 91

Case-Based Critical Thinking Questions Case 10-1 You have been having some difficulty in your economics class this semester,so you have requested support from a tutor.One topic that is giving you trouble at the moment is the price elasticity of demand. -Increasing the price of an object by 10% decreases demand by 20%.This is an example of what kind of elasticity,according to your tutor?

(Multiple Choice)

4.9/5

(38)

Question 92

To perform a what-if analysis with more than two input cells,you ____.

(Multiple Choice)

4.8/5

(27)

Question 93

A(n)____________________ is a customized program that adds commands and features to Microsoft Office programs.

(Short Answer)

4.7/5

(37)

Question 94

In Goal Seek,the ____________________ cell is the cell containing the values you want to examine.

(Short Answer)

4.9/5

(33)

Question 95

Changing cells can be located anywhere in the worksheet.

(True/False)

4.9/5

(34)

Question 96

-The item marked 4 in the accompanying figure indicates the ____ expenses.

(Multiple Choice)

4.7/5

(33)

Question 97

A(n)optimal cell is a cell that Excel changes to produce the desired result in the target cell._________________________

(True/False)

4.8/5

(41)

Question 98

Solver can create the following three different reports: ____.

(Multiple Choice)

4.9/5

(49)

Question 99

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Cannot be used when a problem contains integer constraints

(Multiple Choice)

4.8/5

(39)

Question 100

Showing 81 - 100 of 150

In measuring elasticity,as the value of e increases,the result is that any change in price causes a huge change in demand,resulting in a ____ relationship between price and demand.

Once you enter an array formula,Excel will enclose the formula in a set of ____.

Which of the following reports is used to quantify the reliability of a solution?

With Goal Seek,Excel changes the ____ values to produce the result values you are looking for.

A(n)mixed expense is an expense that is part variable and part fixed._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -When any change in price is met by an equal and opposite change in demand

The Scenario Manager refers to ____________________ cells as changing cells because these worksheet cells contain values that are changed under the scenario.

When using Goal Seek,select the ____ cell in the Set cell box,and then specify its value (goal)in the To value box.

A(n)____ is a limit that is placed on a Solver problem's solution.

To open the dialog box in the accompanying figure,click the What-If Analysis button in the ____ group.

In Solver,changing cells are sometimes referred to as ____ cells.

To perform a what-if analysis with more than two input cells,you ____.

A(n)____________________ is a customized program that adds commands and features to Microsoft Office programs.

In Goal Seek,the ____________________ cell is the cell containing the values you want to examine.

Changing cells can be located anywhere in the worksheet.

-The item marked 4 in the accompanying figure indicates the ____ expenses.

A(n)optimal cell is a cell that Excel changes to produce the desired result in the target cell._________________________

Solver can create the following three different reports: ____.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Cannot be used when a problem contains integer constraints

Getting Started With Excel

Formatting a Workbook

Working With Formulas and Functions

Enhancing a Workbook With Charts and Graphs

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters