MSIS 3223 EXAM 1 FINAL PAPER TEST
BANK WITH VERIFIED QUESTIONS AND
DETAILED SOLUTIONS
●● Relative
Answer: A(n) _____ address uses just the row and column label in the
cell reference (for example A4 or C23).
●● Absolute
Answer: A(n) _____ address uses a dollar sign ($) before either the row
or column or both ($A2, C$23, or $B$15).
●● B$4
Answer: Using a dollar sign ($) before a row label (for example _____)
keeps the reference fixed to row 4 but allows the column reference to
change if the formula is copied to another cell.
●● $B$4
Answer: Using a dollar sign ($) before both the row and column (for
example _____) will keep the reference fixed for both the row and
column.
●● Insert
,Answer: The easiest way to locate a particular function is to select a cell
and click the _____ function button (fx) which can be found under the
ribbon next to the formula bar.
●● MIN(range)
Answer: Function in Excel:
finds the smallest value in a range of cells.
●● MAX(range)
Answer: Function in Excel:
finds the largest value in a range of cells.
●● SUM(range)
Answer: Function in Excel:
finds the sum of values in a range of cells.
●● AVERAGE(range)
Answer: Function in Excel:
finds the average of the values in a range of cells.
●● COUNT(range)
Answer: Function in Excel:
finds the number of cells in a range that contains numbers.
, ●● COUNTIF(range, criteria)
Answer: Function in Excel:
finds the number of cells within a range that meet a specified criterion.
●● Net Present Value (NPV)
Answer: Measures the worth of a stream of cash flows, taking into
account the time value of money.
●● Discount Rate
Answer: The _____ reflects the opportunity costs of spending funds now
versus achieving a return through another investment, as well as the
risks associated with not receiving returns until a later time.
●● positive NPV
Answer: A _____ means that the investment will provide added value
because the projected return exceeds the discount rate.
●● Descriptive Analytics
Answer: The most commonly used and most-well understood type of
analytics. Summarizes data into meaningful charts & reports, for
example, about budgets, sales, revenues, or cost.
●● Predictive Analytics
BANK WITH VERIFIED QUESTIONS AND
DETAILED SOLUTIONS
●● Relative
Answer: A(n) _____ address uses just the row and column label in the
cell reference (for example A4 or C23).
●● Absolute
Answer: A(n) _____ address uses a dollar sign ($) before either the row
or column or both ($A2, C$23, or $B$15).
●● B$4
Answer: Using a dollar sign ($) before a row label (for example _____)
keeps the reference fixed to row 4 but allows the column reference to
change if the formula is copied to another cell.
●● $B$4
Answer: Using a dollar sign ($) before both the row and column (for
example _____) will keep the reference fixed for both the row and
column.
●● Insert
,Answer: The easiest way to locate a particular function is to select a cell
and click the _____ function button (fx) which can be found under the
ribbon next to the formula bar.
●● MIN(range)
Answer: Function in Excel:
finds the smallest value in a range of cells.
●● MAX(range)
Answer: Function in Excel:
finds the largest value in a range of cells.
●● SUM(range)
Answer: Function in Excel:
finds the sum of values in a range of cells.
●● AVERAGE(range)
Answer: Function in Excel:
finds the average of the values in a range of cells.
●● COUNT(range)
Answer: Function in Excel:
finds the number of cells in a range that contains numbers.
, ●● COUNTIF(range, criteria)
Answer: Function in Excel:
finds the number of cells within a range that meet a specified criterion.
●● Net Present Value (NPV)
Answer: Measures the worth of a stream of cash flows, taking into
account the time value of money.
●● Discount Rate
Answer: The _____ reflects the opportunity costs of spending funds now
versus achieving a return through another investment, as well as the
risks associated with not receiving returns until a later time.
●● positive NPV
Answer: A _____ means that the investment will provide added value
because the projected return exceeds the discount rate.
●● Descriptive Analytics
Answer: The most commonly used and most-well understood type of
analytics. Summarizes data into meaningful charts & reports, for
example, about budgets, sales, revenues, or cost.
●● Predictive Analytics
