MSIS 3223 Exam 1 (Appendix A1, Ch.
1-4) fully solved passed
_____ in formulas can be written with either relative addresses or absolute addresses. - correct
answer ✔✔Cell references
A(n) _____ address uses just the row and column label in the cell reference (for example A4 or
C23). - correct answer ✔✔Relative
A(n) _____ address uses a dollar sign ($) before either the row or column or both ($A2, C$23, or
$B$15). - correct answer ✔✔Absolute
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. - correct
answer ✔✔B$4
Using a dollar sign ($) before both the row and column (for example _____) will keep the
reference fixed for both the row and column. - correct answer ✔✔$B$4
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. - correct answer
✔✔Insert
Function in Excel:
finds the smallest value in a range of cells. - correct answer ✔✔MIN(range)
Function in Excel:
, finds the largest value in a range of cells. - correct answer ✔✔MAX(range)
Function in Excel:
finds the sum of values in a range of cells. - correct answer ✔✔SUM(range)
Function in Excel:
finds the average of the values in a range of cells. - correct answer ✔✔AVERAGE(range)
Function in Excel:
finds the number of cells in a range that contains numbers. - correct answer ✔✔COUNT(range)
Function in Excel:
finds the number of cells within a range that meet a specified criterion. - correct answer
✔✔COUNTIF(range, criteria)
Measures the worth of a stream of cash flows, taking into account the time value of money. -
correct answer ✔✔Net Present Value (NPV)
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. - correct answer ✔✔Discount Rate
A _____ means that the investment will provide added value because the projected return
exceeds the discount rate. - correct answer ✔✔positive NPV
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. - correct
answer ✔✔Descriptive Analytics
1-4) fully solved passed
_____ in formulas can be written with either relative addresses or absolute addresses. - correct
answer ✔✔Cell references
A(n) _____ address uses just the row and column label in the cell reference (for example A4 or
C23). - correct answer ✔✔Relative
A(n) _____ address uses a dollar sign ($) before either the row or column or both ($A2, C$23, or
$B$15). - correct answer ✔✔Absolute
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. - correct
answer ✔✔B$4
Using a dollar sign ($) before both the row and column (for example _____) will keep the
reference fixed for both the row and column. - correct answer ✔✔$B$4
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. - correct answer
✔✔Insert
Function in Excel:
finds the smallest value in a range of cells. - correct answer ✔✔MIN(range)
Function in Excel:
, finds the largest value in a range of cells. - correct answer ✔✔MAX(range)
Function in Excel:
finds the sum of values in a range of cells. - correct answer ✔✔SUM(range)
Function in Excel:
finds the average of the values in a range of cells. - correct answer ✔✔AVERAGE(range)
Function in Excel:
finds the number of cells in a range that contains numbers. - correct answer ✔✔COUNT(range)
Function in Excel:
finds the number of cells within a range that meet a specified criterion. - correct answer
✔✔COUNTIF(range, criteria)
Measures the worth of a stream of cash flows, taking into account the time value of money. -
correct answer ✔✔Net Present Value (NPV)
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. - correct answer ✔✔Discount Rate
A _____ means that the investment will provide added value because the projected return
exceeds the discount rate. - correct answer ✔✔positive NPV
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. - correct
answer ✔✔Descriptive Analytics
