MISY 5325 PRACTICE EXAM QUESTIONS AND
DETAILED SOLUTIONS 2026
▶ What-If Models? Answer:They provide easy-to-use, sophisticated
mathematical and logical functions, allowing for easy instantaneous
recalculation for a change in model inputs
▶ Influence diagram? Answer:Visual representation that shows which
entities influence others in a model
▶ Data Table? Answer:Excel tool which quantifies the impact of changing
the value of a specific input on an output of interest
▶ One-way data table? Answer:Summarizes a single input's impact on the
output
▶ Two-way data table? Answer:summarizes two inputs' impact on the
output.
▶ Goal Seek? Answer:Excel tool that allows the user to determine the
value of an input cell that will cause the value of a related output cell to
equal some specified value (the goal).
▶ SUMPRODUCT? Answer:Function that returns the sum of the products
of elements in a set of arrays
▶ COUNTIF? Answer:Counts the number of components having a positive
order quantity
▶ VLOOKUP? Answer:This function allows the user to pull a subset of data
from a larger table of data based on some criterion
▶ Trace Precedents button? Answer:After selecting cells, this button
creates arrows pointing to the selected cell from cells that are part of the
formula in that cell
, ▶ Trace Dependents button? Answer:Shows arrows pointing from the
selected cell to cells that depend on the selected cell
▶ Evaluate Formulas? Answer:This button allows you to investigate the
calculations of a cell in great detail
▶ Error Checking? Answer:This button provides an automatic means of
checking for mathematical errors within formulas of a worksheet
▶ Watch Window? Answer:Located in the Formula Auditing group, allows
the user to observe the values of cells included in the Watch Window box
list
▶▶ An information system can be defined technically as a set of
interrelated components that collect, process, store, and distribute
information to support which of the following ? Answer: decision making
and control in a organization
▶ the four changes that present challenges in management information
systems include the growth of cloud computing the use of big data and
internet of things , the mobile platform, and the application of ____ to help
managers understand their business and products Answer: artificial
intelligence
▶ new _____ require that accountants have intimate knowledge of
databases, reporting systems, and networks to trace financial transactions
Answer: public laws
▶ for pcl construction implementing new info technologies ____ Answer:
changed its business operations
▶ worldwide non us expenditures for info technology exceeded ____ trillion
in 2019 Answer: 3.8
▶ With new laws requiring the storage of emails and other important
documents, estimates of information systems storage now exceeds
4.7____ Answer: zettabytes
▶ which of the following is a business driver which focuses on ways to
achieve better efficiencies to increase profits Answer: operational
excellence
DETAILED SOLUTIONS 2026
▶ What-If Models? Answer:They provide easy-to-use, sophisticated
mathematical and logical functions, allowing for easy instantaneous
recalculation for a change in model inputs
▶ Influence diagram? Answer:Visual representation that shows which
entities influence others in a model
▶ Data Table? Answer:Excel tool which quantifies the impact of changing
the value of a specific input on an output of interest
▶ One-way data table? Answer:Summarizes a single input's impact on the
output
▶ Two-way data table? Answer:summarizes two inputs' impact on the
output.
▶ Goal Seek? Answer:Excel tool that allows the user to determine the
value of an input cell that will cause the value of a related output cell to
equal some specified value (the goal).
▶ SUMPRODUCT? Answer:Function that returns the sum of the products
of elements in a set of arrays
▶ COUNTIF? Answer:Counts the number of components having a positive
order quantity
▶ VLOOKUP? Answer:This function allows the user to pull a subset of data
from a larger table of data based on some criterion
▶ Trace Precedents button? Answer:After selecting cells, this button
creates arrows pointing to the selected cell from cells that are part of the
formula in that cell
, ▶ Trace Dependents button? Answer:Shows arrows pointing from the
selected cell to cells that depend on the selected cell
▶ Evaluate Formulas? Answer:This button allows you to investigate the
calculations of a cell in great detail
▶ Error Checking? Answer:This button provides an automatic means of
checking for mathematical errors within formulas of a worksheet
▶ Watch Window? Answer:Located in the Formula Auditing group, allows
the user to observe the values of cells included in the Watch Window box
list
▶▶ An information system can be defined technically as a set of
interrelated components that collect, process, store, and distribute
information to support which of the following ? Answer: decision making
and control in a organization
▶ the four changes that present challenges in management information
systems include the growth of cloud computing the use of big data and
internet of things , the mobile platform, and the application of ____ to help
managers understand their business and products Answer: artificial
intelligence
▶ new _____ require that accountants have intimate knowledge of
databases, reporting systems, and networks to trace financial transactions
Answer: public laws
▶ for pcl construction implementing new info technologies ____ Answer:
changed its business operations
▶ worldwide non us expenditures for info technology exceeded ____ trillion
in 2019 Answer: 3.8
▶ With new laws requiring the storage of emails and other important
documents, estimates of information systems storage now exceeds
4.7____ Answer: zettabytes
▶ which of the following is a business driver which focuses on ways to
achieve better efficiencies to increase profits Answer: operational
excellence
