MSIS 3223 EXAM 1 QUESTIONS AND 100% CORRECT ANSWERS
\Q\.Common Mathematical Operators - ANSWERS✔-Addition +
Subtraction -
Multiplication *
Division /
Exponential - ^
\Q\.Relative Addressing - ANSWERS✔-Usin
...
MSIS 3223 EXAM 1 QUESTIONS AND 100% CORRECT ANSWERS
\Q\.Common Mathematical Operators - ANSWERS✔-Addition +
Subtraction -
Multiplication *
Division /
Exponential - ^
\Q\.Relative Addressing - ANSWERS✔-Using just the row/column label in cell references
Example: A2, C5, D10
\Q\.Absolute Addressing - ANSWERS✔-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
\Q\.Using a $ sign before a row label (for example, B$4) keeps the reference... - ANSWERS✔-fixed to row 4 but allows the column reference to change if the formula is copied to another cell.
\Q\.Using a $ sign before a column label (for example, $B4) keeps the reference to column B.. - ANSWERS✔-fixed but allows the row reference to change.
\Q\.Using a $ sign before both the row and column labels (for example, $B$4) keeps the reference to cell B4... - ANSWERS✔-fixed no matter where the formula is copied.
\Q\.How to copy formulas - ANSWERS✔-Copy/Paste button in home tab
Ctrl C/V
Drag bottom right corner of cell (fill handle) across a row or column
\Q\.Basic Excel Functions - ANSWERS✔-=MIN(range)
=MAX(range)
=SUM(range)
=AVERAGE(range)
=COUNT(range) - (must contain numbers)
=COUNTIF(range,criteria)
\Q\.Locating a particular function in Excel - ANSWERS✔-Formulas - function library
\Q\.Net Present Value - ANSWERS✔-measures the worth of a stream of cash flows, taking into account the time value of money
=NPV(rate, value1, value2,...)
\Q\.Descriptive Analytics - ANSWERS✔-Use of data to understand past/current business performance and make informed decisions. Provides insight into the past.
"What has happened?"
\Q\.Predictive Analytics - ANSWERS✔-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?"
\Q\.Prescriptive analytics - ANSWERS✔-identify the best alternatives to minimize or maximize some objective.
"What should we do?"
\Q\.Data - ANSWERS✔-numbers or textual data that are collected through some type of measurement process
\Q\.Information - ANSWERS✔-result of analyzing data; that is, extracting meaning from data to support evaluation and decision making
\Q\.Reliability - ANSWERS✔-data are accurate and consistent.
\Q\.Validity - ANSWERS✔-data correctly measures what it is supposed to measure.
\Q\.Model - ANSWERS✔-an abstraction or representation of a real system, idea, or object. Captures the most important features. Can be a written or verbal description, a visual representation, a mathematical formula, or a spreadsheet.
\Q\.Decision Models - ANSWERS✔-a logical or mathematical representation of a problem or business situation that can be used to understand, analyze, or facilitate making a decision.
[Show More]
