MSIS 3223 EXAM 2 FINAL PAPER TEST
BANK WITH VERIFIED QUESTIONS AND
DETAILED SOLUTIONS
●● Relative cell reference
Answer: Refers to cells based on their position in relation to (relative to)
the cell that contains the formula.
Ex: A4
●● Absolute cell reference
Answer: Cell reference that does not adjust to the new cell location
when copied or moved
Ex: $A3, $A$3 or A$3
the reference is absolute to location with the dollar sign in front of it
●● To copy a formula into a single cell or range of cells:
Answer: select the cell or range
click and hold the mouse on the small square in the lower right hand
corner, drag the formula to the target cells you wish to copy
OR use CTRL c and v
●● What is the easiest way to locate a particular function?
,Answer: select a cell and click on the insert function button (fx) below
the ribbon
●● MIN(range)
Answer: finds the smallest value in a range of cells
●● MAX(range)
Answer: finds the largest value in a range of cells
●● SUM(range)
Answer: finds the sum of values in a range of cells
●● Average(range)
Answer: finds the average of the values in a range of cells
●● COUNT(range)
Answer: finds the number of cells in a range that contains numbers
●● COUNTIF(range, criteria)
Answer: finds the number of cells within a range that meet a specified
criterion
●● Net Present Value (NPV)
, Answer: measures the worth of a streak of cash flows, taking into
account the time value of money
●● discount rate
Answer: reflects the opportunity cost of spending funds versus achieving
a return through another investment, as well as the risks associated with
not receiving returns until a later time
●● a positive NPV means...
Answer: the investment will provide added value because the project
return exceeds the discount rate
●● Descriptive analytics
Answer: summarizes data into meaningful charts and reports
●● predictive analytics
Answer: seeks to predict the future by examining historical data,
detecting patterns or relationships in these data and then extrapolating
these relationships forward in time
●● prescriptive analytics
Answer: uses optimization to identify the best alternatives to minimize
or maximize an objective
BANK WITH VERIFIED QUESTIONS AND
DETAILED SOLUTIONS
●● Relative cell reference
Answer: Refers to cells based on their position in relation to (relative to)
the cell that contains the formula.
Ex: A4
●● Absolute cell reference
Answer: Cell reference that does not adjust to the new cell location
when copied or moved
Ex: $A3, $A$3 or A$3
the reference is absolute to location with the dollar sign in front of it
●● To copy a formula into a single cell or range of cells:
Answer: select the cell or range
click and hold the mouse on the small square in the lower right hand
corner, drag the formula to the target cells you wish to copy
OR use CTRL c and v
●● What is the easiest way to locate a particular function?
,Answer: select a cell and click on the insert function button (fx) below
the ribbon
●● MIN(range)
Answer: finds the smallest value in a range of cells
●● MAX(range)
Answer: finds the largest value in a range of cells
●● SUM(range)
Answer: finds the sum of values in a range of cells
●● Average(range)
Answer: finds the average of the values in a range of cells
●● COUNT(range)
Answer: finds the number of cells in a range that contains numbers
●● COUNTIF(range, criteria)
Answer: finds the number of cells within a range that meet a specified
criterion
●● Net Present Value (NPV)
, Answer: measures the worth of a streak of cash flows, taking into
account the time value of money
●● discount rate
Answer: reflects the opportunity cost of spending funds versus achieving
a return through another investment, as well as the risks associated with
not receiving returns until a later time
●● a positive NPV means...
Answer: the investment will provide added value because the project
return exceeds the discount rate
●● Descriptive analytics
Answer: summarizes data into meaningful charts and reports
●● predictive analytics
Answer: seeks to predict the future by examining historical data,
detecting patterns or relationships in these data and then extrapolating
these relationships forward in time
●● prescriptive analytics
Answer: uses optimization to identify the best alternatives to minimize
or maximize an objective
