MSIS 3223 Exam 1 (Appendix A1, Ch. 1-4) Latest Update 2024-2025 Actual Exam from Credible Sources with 100+ Questions and Verified Correct Answers Golden Ticket to Guaranteed A+ Verified by Professor
$B$4 - CORRECT ANSWER: Using a dollar sign ($) before both the row and column
(for example _____) will keep the reference fixed for both the row and column.
- Categorical (Nominal)
- Ordinal
- Interval
- Ratio - CORRECT ANSWER: Data is classified into 4 groups:
- Data
- Uncontrollable inputs
- Decision options - CORRECT ANSWER: The 3 types of input in a Decision Model:
- Recognizing the problem
- Defining the problem
- Structuring the problem
- Analyzing the problem
- Interpreting results & making a decision - CORRECT ANSWER: Phases of problem
solving:
a structured collection of related files and data - CORRECT ANSWER: What is a
database?
- / 2
Absolute - CORRECT ANSWER: A(n) _____ address uses a dollar sign ($) before
either the row or column or both ($A2, C$23, or $B$15).
AND(condition 1, condition 2...) - CORRECT ANSWER: Function in Excel: a logical function that returns TRUE if all conditions are true and FALSE if not.
Area - CORRECT ANSWER: An _____ chart combines the features of a pie chart with
those of line charts.
Average - CORRECT ANSWER: The _____ is formally called the arithmetic mean (or
simply the mean) which is the sum of the observations divided by the number of observations.
AVERAGE(range) - CORRECT ANSWER: Function in Excel: finds the average of the values in a range of cells.
B$4 - CORRECT 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.
Bubble - CORRECT ANSWER: A _____ chart is a type of scatter chart in which the size of the data corresponds to the value of a third variable; consequently, it is a way to plot three variables in two dimensions.
Categorical (Nominal) Data - CORRECT ANSWER: Data which are sorted into
categories according to specified characteristics.
Cell references - CORRECT ANSWER: _____ in formulas can be written with either
relative addresses or absolute addresses.
- / 2