Busy. Please wait.
Log in with Clever
or

show password
Forgot Password?

Don't have an account?  Sign up 
Sign up using Clever
or

Username is available taken
show password

Your email address is only used to allow you to reset your password. See our Privacy Policy and Terms of Service.


Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.

CTS 230 EM10 Test

Enter the letter for the matching Answer
incorrect
1.
97. In Goal Seek, the ____________________ cell is the cell containing the values you want to examine.
incorrect
2.
59. In measuring elasticity, if e=2.0, then increasing the price of an object by ____ decreases demand by 20%.
incorrect
3.
69. A(n) ____ is a limit that is placed on a Solver problem's solution.
incorrect
4.
40. With Goal Seek, Excel changes the ____ values to produce the result values you are looking for.
incorrect
5.
6. If your input values are in a column, you will use the Row input cell option when you use the Data Table command.
incorrect
6.
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.
incorrect
7.
73. Solver arrives at optimal solutions through a(n) ____ procedure.
incorrect
8.
68. To open the Solver Parameters dialog box, click the Solver button in the ____ group on the Data tab.
incorrect
9.
65. When you use Solver, you must specify the ____ that apply to your problem.
incorrect
10.
17. The sensitivity report is most often used in science and engineering environments.
incorrect
11.
56. You can use the Load/Save button in the Solver ____ dialog box to save the Solver model to the current worksheet.
incorrect
12.
83. Which report type is used to quantify the reliability of a solution?
incorrect
13.
103. If you want to concentrate on only a few key cells, the scenario summary report has ____________________ tools so you can hide and expand different parts of the report.
incorrect
14.
100. When creating a(n) ____________________ data table, you must identify the row input cell and the column input cell.
incorrect
15.
34. ____ analysis expresses the relationship between a company’s expenses, its volume of business, and the resulting profit.
incorrect
16.
8. In a two-variable data table, the values of two result cells are displayed.
incorrect
17.
57. In measuring elasticity, if e=0.1, then increasing the price of an item by 10% decreases demand by ____.
incorrect
18.
4. To open the Goal Seek dialog box, first click the __________in the Data Tools group.
incorrect
19.
1. At the break-even point, ____________.
incorrect
20.
87. The last column on the right in an answer report shows the ____ for each constraint.
A.
False
B.
array functions
C.
iterative
D.
limit, constraint
E.
analysis
F.
constraints
G.
true
H.
constraint
I.
10%
J.
slack
K.
cvp
L.
result
M.
revenue equals expenses.
N.
outline
O.
two-variable
P.
What-If Analysis button e
Q.
1%
R.
false
S.
input
T.
parameters
Type the Answer that corresponds to the displayed Question.
incorrect
21.
42. In two-variable tables, you must always place a reference to the result cell in the ____ corner of the table at the intersection of the row values and the column values.
incorrect
22.
22. The output cell is the cell containing the values you want to examine.
incorrect
23.
46. To calculate multiple cells values, select the range and type the array formula, then press the ____ keys to enter the formula.
incorrect
24.
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.
incorrect
25.
11. You cannot merge scenarios in situations involving multiple workbooks.
incorrect
26.
72. After trying out solutions for a short time, Solver displays the ____ dialog box, which displays the message that indicates Solver has found a solution that satisfies the constraints.
incorrect
27.
61. ____ is a program that searches for the optimal solution of a problem involving several variables.
incorrect
28.
38. Goal Seek uses a different approach from traditional ____ analysis.
incorrect
29.
96. With ____________________, you specify the result values you want, and Excel changes the input values to produce them.
incorrect
30.
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.

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
Created by: galvanl
Popular Computers sets