(Excel) Module TEN
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
---|---|---|---|---|---|
show | revenue equals expenses.
🗑
|
||||
show | False
🗑
|
||||
show | False
🗑
|
||||
show | What-If Analysis button e
🗑
|
||||
5. You should always clearly label the row or column containing the input and result values. | show 🗑
|
||||
show | False
🗑
|
||||
7. When you create a one-variable data table, you select the range that contains the data table, making sure to include the column headings. | show 🗑
|
||||
show | false
🗑
|
||||
9.Two-variable data tables are often used to explore the impact of changing two values on a single result. | show 🗑
|
||||
10. Changing cells can be located anywhere in the worksheet. | show 🗑
|
||||
show | false
🗑
|
||||
show | true
🗑
|
||||
13. It is possible for Solver to be installed but not activated on your computer. | show 🗑
|
||||
show | true
🗑
|
||||
15. That an order must meet store demand, or that it cannot exceed the available parts, are examples of constraints. | show 🗑
|
||||
16. References, or limits, in Solver are important because they ensure a realistic solution to your problem. | show 🗑
|
||||
show | true
🗑
|
||||
18.A limits report is best utilized when your problem contains integer constraints. | show 🗑
|
||||
19. Fixed expenses change in proportion to the company’s sales volume. | show 🗑
|
||||
20. CVP analysis is sometimes called breakthrough analysis. | show 🗑
|
||||
21. In traditional what-if analysis, you change result values in worksheet cells. | show 🗑
|
||||
show | false
🗑
|
||||
23. An array argument performs multiple calculations on one or more sets of values and then returns either a single value or multiple values. | show 🗑
|
||||
24. You can view a scenario by clicking its name in the Scenarios box in the Scenario Manager dialog box. | show 🗑
|
||||
25. When measuring elasticity, when e<1, the price elasticity of demand is perfectly inelastic. | show 🗑
|
||||
26. When measuring elasticity, if e=1, then the elasticity is referred to as unit elastic because any change in price is met by an equal and opposite change in demand. | show 🗑
|
||||
show | false
🗑
|
||||
28. A(n) optimal cell is a cell that Excel changes to produce the desired result in the target cell. | show 🗑
|
||||
29. The default convergence value is 0.001, which means that if the change in the target cell between one solution and the next is less than or equal to 0.001, Solver will consider that it has converged to the solution. | show 🗑
|
||||
show | false
🗑
|
||||
show | false
🗑
|
||||
show | true
🗑
|
||||
33. ____ analysis is an important business decision-making tool because it predicts the effect of cutting overhead or raising prices on net income. | show 🗑
|
||||
show | cvp
🗑
|
||||
35. Which of the following expense types can be used in a CVP analysis? ____ | show 🗑
|
||||
36. A business must pay insurance and rent.these are examples of ____ expenses. | show 🗑
|
||||
show | Variable, fixed and mixed
🗑
|
||||
show | What-if
🗑
|
||||
show | Result
🗑
|
||||
40. With Goal Seek, Excel changes the ____ values to produce the result values you are looking for. | show 🗑
|
||||
41. If you orient a one-variable table so that the input values are in the first row, you would use the ____ input cell option. | show 🗑
|
||||
show | upper-left
🗑
|
||||
43. {=SUM(B1:B10*C1:C10)} is an example of a(n) ____. | show 🗑
|
||||
show | curly braces
🗑
|
||||
show | trend, minverse, mmult
🗑
|
||||
46. To calculate multiple cells values, select the range and type the array formula, then press the ____ keys to enter the formula. | show 🗑
|
||||
47. ____ are a powerful feature of Excel. If used properly, they help you perform complex calculations within a single formula and extend a single formula over a range of cells. | show 🗑
|
||||
show | names
🗑
|
||||
49. To perform a what-if analysis with more than two input cells, you ____. | show 🗑
|
||||
50. To select nonadjacent changing cells, press and hold the ____ key as you click each cell. | show 🗑
|
||||
51. You can switch from one scenario to another by clicking the ____ button in the Scenario Manager dialog box. | show 🗑
|
||||
show | summary report
🗑
|
||||
53. A scenario summary report’s ____ layout makes it simpler to compare the results of each scenario, and the automatic formatting makes it useful for reports and meetings. | show 🗑
|
||||
54. Elasticity measures how changing prices can affect the ____ a good or service. | show 🗑
|
||||
55. When change in price has no impact on demand, the situation is referred to as ____. | show 🗑
|
||||
56. You can use the Load/Save button in the Solver ____ dialog box to save the Solver model to the current worksheet. | show 🗑
|
||||
57. In measuring elasticity, if e=0.1, then increasing the price of an item by 10% decreases demand by ____. | show 🗑
|
||||
58. In measuring elasticity, if e=0, then changes in price have no impact on demand, which is referred to as a ____ situation and occurs when the item being sold is rare or essential. | show 🗑
|
||||
show | 10%
🗑
|
||||
60. 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. | show 🗑
|
||||
61. ____ is a program that searches for the optimal solution of a problem involving several variables. | show 🗑
|
||||
show | solver
🗑
|
||||
63. The three items that you must specify when using Solver are ____. | show 🗑
|
||||
64. In Solver, changing cells are sometimes referred to as ____ cells. | show 🗑
|
||||
show | constraints
🗑
|
||||
66. Aside from Solver, other Excel ____ provide the ability to perform statistical analyses, generate business reports, and retrieve financial data from the Internet. | show 🗑
|
||||
show | add-in dialog box
🗑
|
||||
show | analysis
🗑
|
||||
69. A(n) ____ is a limit that is placed on a Solver problem's solution. | show 🗑
|
||||
70. ____ are important because they ensure a realistic solution to your problem. | show 🗑
|
||||
show | status bar
🗑
|
||||
show | solver results
🗑
|
||||
show | iterative
🗑
|
||||
74. A(n) ____ procedure means that Solver starts with an initial solution and uses that as a basis to calculate a series of solutions. | show 🗑
|
||||
show | esc
🗑
|
||||
show | show iteration results
🗑
|
||||
77. The default length of time that Solver will spend on the iterative process is ____ seconds. | show 🗑
|
||||
78. The default convergence value in Solver is ____. | show 🗑
|
||||
show | 100
🗑
|
||||
80. You can include an analysis of the constraints and conditions by which Solver arrived at its solution by creating a(n) ____ report. | show 🗑
|
||||
81. Solver can create what three different report types? | show 🗑
|
||||
82. The ____ report summarizes the results of a successful solution by displaying information about the target cell, changing cells, and constraints. | show 🗑
|
||||
show | limit, constraint
🗑
|
||||
show | answer
🗑
|
||||
show | limits
🗑
|
||||
86. The answer report is divided into ____ sections. | show 🗑
|
||||
87. The last column on the right in an answer report shows the ____ for each constraint. | show 🗑
|
||||
88. The slack is the difference between the value in the cell and the value at the limit of the ____. | show 🗑
|
||||
89. Binding constraints always show a slack of ____. | show 🗑
|
||||
90. Cells that display the value ____ indicate that all of the values in the worksheet satisfy the Solver constraints. | show 🗑
|
||||
show | false
🗑
|
||||
92. Scenario summary tables and scenario ____ can be used to obtain a quick snapshot of several possible outcomes. | show 🗑
|
||||
show | result
🗑
|
||||
show | variable
🗑
|
||||
show | fixed
🗑
|
||||
show | goal seek
🗑
|
||||
show | result
🗑
|
||||
show | input
🗑
|
||||
show | data
🗑
|
||||
show | two-variable
🗑
|
||||
101. The ____________________ input cell is the cell on which you base values placed in the first row of the data table. | show 🗑
|
||||
show | column
🗑
|
||||
show | outline
🗑
|
||||
104. Click the Scenario PivotTable ____________________ option button to create a PivotTable describing the scenarios. | show 🗑
|
||||
show | add-ins
🗑
|
||||
106. In Solver, a(n) ____________________ cell is a cell that you want to maximize, minimize, or change to a specific value. | show 🗑
|
||||
show | input
🗑
|
||||
108. The ____________________ is the difference between the value in a cell and the value at the limit of the constraint. | show 🗑
|
||||
109. ____________________ constraints always show a slack of 0. | show 🗑
|
||||
show | price elasticity
🗑
|
||||
111. When elasticity is e>1, the price elasticity is ____________________ elastic. | show 🗑
|
||||
show | Goal Seek uses a different approach from traditional what-if analysis, when you change input values in worksheet cells, and Excel uses these values to calculate result values. With Goal Seek, you specify the result values you want, and Excel changes the i
🗑
|
||||
show | Insert a formula that references the input cell in the upper-left cell of the table. Insert input values in either the first row or first column of the table. For input values in the first row, insert formulas referencing result cells in the table’s first
🗑
|
||||
114. How many different types of reports can Solver create? What are the characteristics of these report types, and which is the most useful? | show 🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Created by:
galvanl
Popular Computers sets