DECISION SUPPORT SYSTEMS EXAM #1
STUDY GUIDE 2026 COMPLETE REVIEW
NOTES PRACTICE QUESTIONS ANSWER
KEY AND EXPLANATIONS
Which of the following tips can be helpful when you can't figure
out what formula needs to be entered in an output cell? -
CORRECT ANSWER-Do some calculations by hand
Which of the following should be entered first when building a
spreadsheet model? - CORRECT ANSWER-The data cells
How many cells should be used to represent each constraint? -
CORRECT ANSWER-3
What are some ways to distinguish data cells, changing cells,
output cells, and target cells on a spreadsheet?
a. Borders
b. Shading
c. Color
d. All of these - CORRECT ANSWER-All of these
,When testing a spreadsheet model by entering values in the
changing cells, which of the following are appropriate values to
enter?
a. Zeros
b. Values for which you know what the values of the output cells
should be
c. Large numbers
d. All of these - CORRECT ANSWER-All of these
Which of the following is an appropriate first step when building a
spreadsheet model? - CORRECT ANSWER-Visualize where
you want to finish
Which of the following is not an advantage of using range names?
- CORRECT ANSWER-They make the model easier to modify
Which of the following is not a part of the planning step when
building a spreadsheet model? - CORRECT ANSWER-Test the
spreadsheet model
Which of the following is not a major step in the process of
modeling with spreadsheets?
a. Plan
b. Build
c. Test
, d. Analyze
e All of these are major steps - CORRECT ANSWER-All of
these are major steps
Which of the following best describes spaghetti code? -
CORRECT ANSWER-Code that is not logically organized and
jumps all over the place
Network representations can be used for the following problems:
a. project planning
b. facilities location
c. financial planning
d. resource management
e. All of these - CORRECT ANSWER-All of these
Which of the following will have negative net flow in a minimum
cost flow problem? - CORRECT ANSWER-Demand nodes
Which of the following is not an assumption of a minimum cost
flow problem? - CORRECT ANSWER-There is an equal
number of supply and demand nodes
Which of the following is an example of a transshipment node?
a. storage facilities
STUDY GUIDE 2026 COMPLETE REVIEW
NOTES PRACTICE QUESTIONS ANSWER
KEY AND EXPLANATIONS
Which of the following tips can be helpful when you can't figure
out what formula needs to be entered in an output cell? -
CORRECT ANSWER-Do some calculations by hand
Which of the following should be entered first when building a
spreadsheet model? - CORRECT ANSWER-The data cells
How many cells should be used to represent each constraint? -
CORRECT ANSWER-3
What are some ways to distinguish data cells, changing cells,
output cells, and target cells on a spreadsheet?
a. Borders
b. Shading
c. Color
d. All of these - CORRECT ANSWER-All of these
,When testing a spreadsheet model by entering values in the
changing cells, which of the following are appropriate values to
enter?
a. Zeros
b. Values for which you know what the values of the output cells
should be
c. Large numbers
d. All of these - CORRECT ANSWER-All of these
Which of the following is an appropriate first step when building a
spreadsheet model? - CORRECT ANSWER-Visualize where
you want to finish
Which of the following is not an advantage of using range names?
- CORRECT ANSWER-They make the model easier to modify
Which of the following is not a part of the planning step when
building a spreadsheet model? - CORRECT ANSWER-Test the
spreadsheet model
Which of the following is not a major step in the process of
modeling with spreadsheets?
a. Plan
b. Build
c. Test
, d. Analyze
e All of these are major steps - CORRECT ANSWER-All of
these are major steps
Which of the following best describes spaghetti code? -
CORRECT ANSWER-Code that is not logically organized and
jumps all over the place
Network representations can be used for the following problems:
a. project planning
b. facilities location
c. financial planning
d. resource management
e. All of these - CORRECT ANSWER-All of these
Which of the following will have negative net flow in a minimum
cost flow problem? - CORRECT ANSWER-Demand nodes
Which of the following is not an assumption of a minimum cost
flow problem? - CORRECT ANSWER-There is an equal
number of supply and demand nodes
Which of the following is an example of a transshipment node?
a. storage facilities
