MSIS 3223 FINAL EXAM SCRIPT 2026 FULL
QUESTIONS AND CORRECT ANSWERS
GRADED A+
◉ Which of the following is a difference between relative addressing
and
absolute addressing when using cell formulas in Excel? Answer: A
relative address uses just the row and column label in the cell reference;
an
absolute address uses a dollar sign before either the row or column label.
◉ To copy a formula from a single cell or range of cells down a column
or
across a row, first________, click and hold the mouse on the small
square in
the lower right-hand corner of the cell, and drag the formula to the
"target"
cells which you wish to copy. Answer: select the cell or range
◉ The easiest way to locate a particular function is to select a cell and
click on
, the Insert function button represented by ________ on the Excel ribbon.
Answer: fx
◉ The Excel function of ________ is used to find the largest value in a
range of
cells. Answer: MAX(range)
◉ ________ measures the worth of a stream of cash flows, taking into
account
the time value of money. Answer: Net present value
◉ Descriptive analytics: Answer: helps companies classify their
customers into segments to develop specific
marketing campaigns.
◉ Predictive analytics: Answer: detects patterns in historical data and
extrapolates them forward in time
◉ Which of the following questions will prescriptive analytics help a
company
address? Answer: What is the best way of shipping goods from their
factories to minimize costs?
◉ The demand for coffee beans over a period of three months has been
QUESTIONS AND CORRECT ANSWERS
GRADED A+
◉ Which of the following is a difference between relative addressing
and
absolute addressing when using cell formulas in Excel? Answer: A
relative address uses just the row and column label in the cell reference;
an
absolute address uses a dollar sign before either the row or column label.
◉ To copy a formula from a single cell or range of cells down a column
or
across a row, first________, click and hold the mouse on the small
square in
the lower right-hand corner of the cell, and drag the formula to the
"target"
cells which you wish to copy. Answer: select the cell or range
◉ The easiest way to locate a particular function is to select a cell and
click on
, the Insert function button represented by ________ on the Excel ribbon.
Answer: fx
◉ The Excel function of ________ is used to find the largest value in a
range of
cells. Answer: MAX(range)
◉ ________ measures the worth of a stream of cash flows, taking into
account
the time value of money. Answer: Net present value
◉ Descriptive analytics: Answer: helps companies classify their
customers into segments to develop specific
marketing campaigns.
◉ Predictive analytics: Answer: detects patterns in historical data and
extrapolates them forward in time
◉ Which of the following questions will prescriptive analytics help a
company
address? Answer: What is the best way of shipping goods from their
factories to minimize costs?
◉ The demand for coffee beans over a period of three months has been
