FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 10: Data Tables, scenario Manager, and Solver

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

Matching

Review LaterAdd Note

Review Later

Match the following terms to their description.

Premises

Responses

Color Scales

Applies a color gradient or solid fill bar

Highlight Cells Rules

Formats cells with values in the top 10 items,top 10%,bottom 10 items,bottom 10 %,above average,or below average

Icon Sets

Inserts an icon from the icon palette

Data Bars

Highlights cells with a fill color,font color,or border if values are greater than,less than,between two values,equal to a value,or duplicate values

Top/Bottom Rules

Formats different cells with different colors; one color is assigned to the lowest group of values,another color to the highest group of values,and gradient colors for other values

Premises

Color Scales

Highlight Cells Rules

Icon Sets

Data Bars

Top/Bottom Rules

Responses

Applies a color gradient or solid fill bar

Formats cells with values in the top 10 items,top 10%,bottom 10 items,bottom 10 %,above average,or below average

Inserts an icon from the icon palette

Highlights cells with a fill color,font color,or border if values are greater than,less than,between two values,equal to a value,or duplicate values

Formats different cells with different colors; one color is assigned to the lowest group of values,another color to the highest group of values,and gradient colors for other values

Show Answer

Correct Answer

Premises

Responses

Color Scales

Highlight Cells Rules

Icon Sets

Data Bars

Top/Bottom Rules

Premises

Color Scales

Highlight Cells Rules

Icon Sets

Data Bars

Top/Bottom Rules

Responses

Question 52

Multiple Choice

Review LaterAdd Note

Review Later

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

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.

Correct Answer

verified

Show Answer

Question 53

True/False

Review LaterAdd Note

The number of scenarios you can create is limitless.

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

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 Solver ________ Report lists the objective cell and the changing cells with their corresponding original and final values for the problem,input variables,and constraints.

All of the following statements are TRUE regarding Solver EXCEPT:

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

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

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

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

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

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

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

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.

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

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

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

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

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