Decision Support Systems Practice Exam
Course Introduction
Decision Support Systems explores the concepts, methodologies, and technologies essential for supporting decision-making processes in organizations. The course covers the design, development, and implementation of computerized systems that aid in problem-solving and strategic planning, including data management, modeling, analysis, and user interface considerations. Students will analyze real-world applications, examine the integration of artificial intelligence and business analytics, and gain hands-on experience with tools and techniques that enhance managerial decision quality in complex and dynamic environments.
Recommended Textbook
Succeeding in Business with Microsoft Excel 2013 by Frank Akaiwa
Available Study Resources on Quizplus
10 Chapters
1500 Verified Questions
1500 Flashcards
Source URL: https://quizplus.com/study-set/709
Page 2
Chapter 1: Applying Fundamental Excel Skills and Tools in Problem Solving
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/13819
Sample Questions
Q1) The ____ function calculates the average of a list of values.
A) AVE
B) AVG
C) SUM/DIVIDE
D) AVERAGE
Answer: D
Q2) In the formula =$B$1*B11*C5, the cell reference B11 is a(n) ____________________ reference.
Answer: relative
Q3) Which cell would have the formula =C5*C6?
A) C8
B) D8
C) E8
D) C16
Answer: A
Q4) The Accounting Number Style displays values with commas and two decimal places, but no dollar signs. _________________________
A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Solving Problems with Statistical Analysis Tools
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/13820
Sample Questions
Q1) If the Human Resources director wanted a list of people who do have 100% attendance, the correct formula would be ____.
A) =COUNTIF(E3:E13,"<>1")
B) =COUNTIF(E3:E13,"=1")
C) =COUNTIF(E3:E13,">=1")
D) =COUNTIF(E3:E13,"<1")
Answer: B
Q2) The Step button in Goal Seek ____.
A) allows you to step through each iteration one step at a time
B) returns the data in separate spreadsheets
C) walks you through the steps similar to a wizard
D) none of the above
Answer: A
Q3) Goal Seek allows you to vary ____ input(s).
A) a single
B) up to 3
C) up to 5
D) up to 10
Answer: A
To view all questions and flashcards with answers, click on the resource link above.
Page 4
Chapter 3: Determining Effective Data Display with Charts
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/13821
Sample Questions
Q1) ____ graphically illustrate trends in the data using a statistical technique known as regression.
A) Graph lines
B) Average lines
C) Trendlines
D) Datalines
Answer: C
Q2) With the ____ sub-type, the data to be plotted must be placed by column in this order: high stock value for the day, low stock value, and, finally, closing stock value.
A) High-Low-Close
B) Low-Close-High
C) Low-High-Close
D) High-Close-Low
Answer: A
Q3) Use a pie chart when it's most important to show relative percentages rather than values.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above.
Page 5
Chapter 4: Applying Logic in Decision Making
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/13822
Sample Questions
Q1) If Nathan entered the dates shown in column B directly into a formula, Excel would interpret the entry as a(n) ____.
A) date
B) numerical expression
C) error
D) text entry
Q2) The syntax of the IF function is =IF(logical_test,value_if_true,value_if_false).
A)True
B)False
Q3) The result of the formula =OR(I3:I21>90), where cell I5 is 92, is ____.
A) FALSE
B) TRUE
C) ERROR
D) both a and b
Q4) The syntax of the NOT function is as follows: ____.
A) NOT(logical1)
B) NOT(logical1,logical2,...)
C) NOT(reference1)
D) NOT(value1,value2,...)
Q5) The > symbol represents the ____________________ relational operator.
Page 6
To view all questions and flashcards with answers, click on the resource link above.
Chapter 5: Retrieving Data for Computation, Analysis, and Reference
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/13823
Sample Questions
Q1) Write the correct syntax for the LOOKUP function. Give a brief explanation of each of the three arguments that are included in LOOKUP.
Q2) The V in VLOOKUP stands for velocity. _________________________
A)True
B)False
Q3) Looks up the greatest value that does not exceed a specified value anywhere in a table or range
A)vertical lookup table
B)horizontal lookup table
C)LOOKUP function
D)INDEX function
E)MATCH function
F)CHOOSE function
G)IFERROR
Q4) In a one-dimensional table, Excel searches one dimension, such as the columns, and then searches another dimension, such as the rows, to find the value at the intersection of a single row and column.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Evaluating the Financial Impact of Loans and Investments
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/13824
Sample Questions
Q1) Most financial instruments, such as loans and CDs, use compound interest.
A)True
B)False
Q2) In a PMT function, the ____ argument is the original principal value at the beginning of the financial transaction.
A) rate
B) nper
C) pv
D) type
Q3) Ending period
A)#1
B)#2
C)#3
D)#4
E)#5
F)#6
Q4) When using the NPV function, the hurdle rate must match the ____________________ duration, so that a yearly cash flow would apply to a yearly discount rate, for example.
To view all questions and flashcards with answers, click on the resource link above. Page 8
Q5) When cash is paid out, it is considered ____________________ cash flow.
Chapter 7: Organizing Data for Effective Analysis
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/13825
Sample Questions
Q1) The Subtotal command creates summary reports that let you ____ the level of detail in a report.
A) collapse
B) expand
C) both a and b
D) neither a nor b
Q2) The syntax for the RIGHT function is as follows: ____.
A) =RIGHT(text,[num_chars])
B) =RIGHT(num_chars,[text])
C) =RIGHT(range,[num_chars])
D) =RIGHT(num_chars,[range])
Q3) A(n) ____________________ is similar in appearance and functionality to an Excel table, but the data is mapped to XML elements.
Q4) You can use a text function to ____, or concatenate, the information from multiple cells into one cell.
A) look up
B) link together
C) transform
D) calculate
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Using Data Tables and Excel Scenarios for What
If Analysis
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/13826
Sample Questions
Q1) ____ results are those that are based on realistic but not actual data.
A) Simulated
B) Fictional
C) Approximated
D) Produced
Q2) Although Excel does not consider case when evaluating cell names, the use of case differences in cell names can make them ____.
A) easier to read
B) easier to interpret
C) both a and b
D) neither a nor b
Q3) After you create a PivotTable report, you can analyze the information in a different form by generating an associated ____, which contains the same elements as a regular Excel chart.
A) ScenarioChart
B) PivotChart
C) Data Chart
D) Data File
Q4) The Scenario Manager refers to output cells as ____________________ cells.
10
Q5) The Scenario Manager refers to input cells as ____________________ cells.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Enhancing Decision Making with Solver
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/13827
Sample Questions
Q1) ____________________ are the boundaries that define the feasible solution area.
Q2) In a Solver model, a value of TRUE indicates a constraint that could not be satisfied.
A)True
B)False
Q3) The cells in a worksheet usually display combinations of text or numbers; the math that generates the answers is ____ in the worksheet itself.
A) visible
B) not visible
C) written in bold text
D) none of the above
Q4) It is a good idea to use ____________________ in the worksheet to identify which Solver model is stored in the different ranges of the worksheet.
Q5) After you load the Solver Add-in, the Solver command is available in the Data group on the DATA tab.
A)True B)False
Q6) The ____________________ constraint assigns the value 0 or 1 to variable cells.
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Troubleshooting Workbooks and Automating Excel Applications
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/13828
Sample Questions
Q1) The formula auditing tool called ____ toggles between displaying formulas or results of formulas in the worksheet.
A) Show Formulas
B) View Formulas
C) Trace Dependents
D) Watch Window
Q2) A(n) ____________________ is a note that you attach to a cell, separate from other cell content.
Q3) All Excel ____________________, including the ones you record, consist of VBA code.
Q4) For optimal password security, Microsoft recommends that you always assign a password to open and view a file.
A)True
B)False
Q5) Excel applications are workbooks that you design so that others can use them in a relatively error-free manner. _________________________
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 12
Q6) A(n) ____________________ cell contains a formula that refers to other cells.