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.
24. You can view a scenario by clicking its name in the Scenarios box in the Scenario Manager dialog box.
incorrect
2.
109. ____________________ constraints always show a slack of 0.
incorrect
3.
113. What are the steps to create a one-variable data table?
incorrect
4.
38. Goal Seek uses a different approach from traditional ____ analysis.
incorrect
5.
8. In a two-variable data table, the values of two result cells are displayed.
incorrect
6.
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
7.
84. Which of the following reports is used when your problem contains integer constraints?
incorrect
8.
62. ____ can be used to find the curve or line that best fits a set of data or to minimize production costs for a product or service.
incorrect
9.
89. Binding constraints always show a slack of ____.
incorrect
10.
76. If you want to see the iterative process in action, click the ____ check box, and Excel will pause after each iteration and show the intermediate solutions that it finds.
incorrect
11.
87. The last column on the right in an answer report shows the ____ for each constraint.
incorrect
12.
77. The default length of time that Solver will spend on the iterative process is ____ seconds.
incorrect
13.
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.
incorrect
14.
40. With Goal Seek, Excel changes the ____ values to produce the result values you are looking for.
incorrect
15.
12. Solver is an add-in, a program that adds customized commands and features to Microsoft Office programs such as Excel.
incorrect
16.
106. In Solver, a(n) ____________________ cell is a cell that you want to maximize, minimize, or change to a specific value.
incorrect
17.
39. With Goal Seek, you specify the ____ values you want.
incorrect
18.
90. Cells that display the value ____ indicate that all of the values in the worksheet satisfy the Solver constraints.
incorrect
19.
102. The ____________________ input cell is the cell on which values placed in the first column of the data table are based.
incorrect
20.
35. Which of the following expense types can be used in a CVP analysis? ____
A.
false
B.
0
C.
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
D.
perfectly inelastic
E.
False
F.
What-if
G.
false
H.
objective
I.
answer
J.
true
K.
true
L.
mixed, variable, fixed
M.
input
N.
Result
O.
show iteration results
P.
solver
Q.
slack
R.
binding
S.
column
T.
100
Type the Answer that corresponds to the displayed Question.
incorrect
21.
83. Which report type is used to quantify the reliability of a solution?
incorrect
22.
104. Click the Scenario PivotTable ____________________ option button to create a PivotTable describing the scenarios.
incorrect
23.
94. ____________________ expenses change in proportion to the amount of business a company does.
incorrect
24.
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
25.
45. What array functions that can return multiple values to multiple cells include ____.
incorrect
26.
31. Not binding constraints always show a slack of 0.
incorrect
27.
91. If a value in the worksheet violates one of the constraints, the Solver parameter cells will display the value ____
incorrect
28.
1. At the break-even point, ____________.
incorrect
29.
46. To calculate multiple cells values, select the range and type the array formula, then press the ____ keys to enter the formula.
incorrect
30.
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.

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