MSIS 3223 Exam 1 Appendix A1, Ch. 1-4 Latest

MSIS 3223 Exam 1 (Appendix A1, Ch. 1-4) Latest Update - 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