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.
1. Categorical (Nominal)
2. Ordinal
3. Interval
4. Ratio - CORRECT ANSWER: Data is classified into 4 groups:
1. Data
2. Uncontrollable inputs
3. Decision options - CORRECT ANSWER: The 3 types of input in a Decision Model:
1. Recognizing the problem
2. Defining the problem
3. Structuring the problem
4. Analyzing the problem
5. 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?
, 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.
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.
1. Categorical (Nominal)
2. Ordinal
3. Interval
4. Ratio - CORRECT ANSWER: Data is classified into 4 groups:
1. Data
2. Uncontrollable inputs
3. Decision options - CORRECT ANSWER: The 3 types of input in a Decision Model:
1. Recognizing the problem
2. Defining the problem
3. Structuring the problem
4. Analyzing the problem
5. 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?
, 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.
