Exam (elaborations)
MSIS 3223 Exam 1 (Appendix A1, Ch. 1-4) Questions With Complete Solutions
- Course
- Institution
MSIS 3223 Exam 1 (Appendix A1, Ch. 1-4) Questions With Complete Solutions
[Show more]
Content preview
MSIS 3223 Exam 1 (Appendix A1, Ch. 1-4) Questions WithComplete Solutions
$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.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Classroom. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
72042 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now