MSIS 3223 EXAM 1 2025 QUESTIONS
AND ANSWERS
Common Mathematical Operators - ANS Addition +
Subtraction -
Multiplication *
Division /
Exponential - ^
Relative Addressing - ANS Using just the row/column label in cell references
Example: A2, C5, D10
Absolute Addressing - ANS Using a $ before either the row, column, or both. This makes it to
where it does not change when copied or filed. Use this to keep a row or column constant.
Example: $A$2, $C5, D$10
Using a $ sign before a row label (for example, B$4) keeps the reference... - ANS fixed to row
4 but allows the column reference to change if the formula is copied to another cell.
Using a $ sign before a column label (for example, $B4) keeps the reference to column B.. -
ANS fixed but allows the row reference to change.
Using a $ sign before both the row and column labels (for example, $B$4) keeps the reference
to cell B4... - ANS fixed no matter where the formula is copied.
1 Copyright ©BRIGHSTARS ALL RIGHTS RESERVED 2025
, How to copy formulas - ANS Copy/Paste button in home tab
Ctrl C/V
Drag bottom right corner of cell (fill handle) across a row or column
Basic Excel Functions - ANS =MIN(range)
=MAX(range)
=SUM(range)
=AVERAGE(range)
=COUNT(range) - (must contain numbers)
=COUNTIF(range,criteria)
Locating a particular function in Excel - ANS Formulas - function library
Net Present Value - ANS measures the worth of a stream of cash flows, taking into account
the time value of money
=NPV(rate, value1, value2,...)
Descriptive Analytics - ANS Use of data to understand past/current business performance
and make informed decisions. Provides insight into the past.
"What has happened?"
Predictive Analytics - ANS predict the future by examining historical data, detecting patterns
or relationships in these data, and then extrapolating these relationships forward in time.
"What could happen?"
2 Copyright ©BRIGHSTARS ALL RIGHTS RESERVED 2025
AND ANSWERS
Common Mathematical Operators - ANS Addition +
Subtraction -
Multiplication *
Division /
Exponential - ^
Relative Addressing - ANS Using just the row/column label in cell references
Example: A2, C5, D10
Absolute Addressing - ANS Using a $ before either the row, column, or both. This makes it to
where it does not change when copied or filed. Use this to keep a row or column constant.
Example: $A$2, $C5, D$10
Using a $ sign before a row label (for example, B$4) keeps the reference... - ANS fixed to row
4 but allows the column reference to change if the formula is copied to another cell.
Using a $ sign before a column label (for example, $B4) keeps the reference to column B.. -
ANS fixed but allows the row reference to change.
Using a $ sign before both the row and column labels (for example, $B$4) keeps the reference
to cell B4... - ANS fixed no matter where the formula is copied.
1 Copyright ©BRIGHSTARS ALL RIGHTS RESERVED 2025
, How to copy formulas - ANS Copy/Paste button in home tab
Ctrl C/V
Drag bottom right corner of cell (fill handle) across a row or column
Basic Excel Functions - ANS =MIN(range)
=MAX(range)
=SUM(range)
=AVERAGE(range)
=COUNT(range) - (must contain numbers)
=COUNTIF(range,criteria)
Locating a particular function in Excel - ANS Formulas - function library
Net Present Value - ANS measures the worth of a stream of cash flows, taking into account
the time value of money
=NPV(rate, value1, value2,...)
Descriptive Analytics - ANS Use of data to understand past/current business performance
and make informed decisions. Provides insight into the past.
"What has happened?"
Predictive Analytics - ANS predict the future by examining historical data, detecting patterns
or relationships in these data, and then extrapolating these relationships forward in time.
"What could happen?"
2 Copyright ©BRIGHSTARS ALL RIGHTS RESERVED 2025
