Data Analysis for Business Final Exam
Course Introduction
Data Analysis for Business introduces students to the fundamental concepts and techniques of analyzing data to support effective decision-making in business environments. The course covers key topics such as data collection, data cleaning, statistical analysis, data visualization, and predictive modeling, with a focus on practical applications relevant to marketing, finance, operations, and management. Students will work with real-world datasets and utilize software tools such as Excel and introductory statistical programming languages to interpret results, identify trends, and present actionable insights. By the end of the course, students will develop the analytical and critical thinking skills necessary to transform data into strategic business value.
Recommended Textbook
Succeeding in Business with Microsoft Excel 2013 A Problem Solving Approach 1st Edition by Debra
Available Study Resources on Quizplus
10 Chapters
1500 Verified Questions
1500 Flashcards
Source URL: https://quizplus.com/study-set/656
2
Chapter 1: Applying Fundamental Excel Skills and Tools in Problem Solving
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/12469
Sample Questions
Q1) The error message #REF! means that there is ____.
A) insufficient width in the cell to display data, or negative date/time
B) an invalid cell reference
C) an invalid numeric value in a formula or function
D) no answer
Answer: B
Q2) Two cell references separated by a colon are referred to as a ____.
A) cell format
B) cell group
C) cell range
D) cell block
Answer: C
Q3) The dollar sign syntax is used by Excel to indicate that a cell reference is absolute.
A)True
B)False
Answer: True
Q4) The rules programmed into the function are referred to as the function's
Answer: algorithm
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Solving Problems with Statistical Analysis Tools
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/12470
Sample Questions
Q1) In the Goal Seek dialog box, the cell containing the data to vary in order to reach the desired output is labeled ____.
A) By changing cell
B) What to change
C) What if
D) Vary
Answer: A
Q2) The COUNTONLY function counts the number of items in a range that meet specified criteria.
A)True
B)False
Answer: False
Q3) The Paste option button option called ____ pastes the formulas and formatting from the original cell(s), but not the format of the cell borders.
A) Keep Source Formatting
B) No Borders
C) Document Theme
D) Destination Formatting
Answer: B
To view all questions and flashcards with answers, click on the resource link above.
Page 4
Chapter 3: Determining Effective Data Display with Charts
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/12471
Sample Questions
Q1) The ____ option of splitting a pie data series into a second, smaller pie chart assigns a specific number of values to the second plot.
A) Position
B) Value
C) Percent Value
D) Custom
Answer: A
Q2) #5
A)Data series
B)Chart title
C)Data table
D)X-axis labels
E)X-axis
F)Legend
G)Y-axis
H)Y-axis labels
I)Gridlines
J)Data point with data label
Answer: J
To view all questions and flashcards with answers, click on the resource link above.
Page 5
Chapter 4: Applying Logic in Decision Making
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/12472
Sample Questions
Q1) NOT(FALSE) returns the value ____.
A) TRUE
B) FALSE
C) EQUAL
D) ERROR
Q2) The function =C2="Hello" uses relational operators to evaluate text labels.
A)True
B)False
Q3) TRUE and FALSE are referred to as Boolean logical values.
A)True
B)False
Q4) Use the logical construct of OR(A1) to change a single TRUE to FALSE or a single FALSE to TRUE.
A)True
B)False
Q5) The NOT function takes only one argument and essentially changes a single TRUE value to FALSE, or a single FALSE value to TRUE.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Retrieving Data for Computation, Analysis, and Reference
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/12473
Sample Questions
Q1) You can often use a LOOKUP function instead of a VLOOKUP or HLOOKUP function with a TRUE lookup type.
A)True
B)False
Q2) A lookup table in which the data to be searched is organized in rows
A)vertical lookup table
B)horizontal lookup table
C)LOOKUP function
D)INDEX function
E)MATCH function
F)CHOOSE function
G)IFERROR
Q3) If you use a match_type of 0 (exact match), you can use the ____ to match any sequence of characters.
A) asterisk (*)
B) question mark (?)
C) exclamation point (!)
D) dollar sign ($)
Q4) A data list that categorizes values you want to retrieve is called a(n) ____________________ table.
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Evaluating the Financial Impact of Loans and Investments
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/12474
Sample Questions
Q1) ____ returns the cumulative principal paid on a loan between start_period and end_period.
A) CUMPRINC
B) ICUMPR
C) PRINCUM
D) CUMPRI
Q2) Payments that are inflows should be ____________________, and payments that are outflows should be negative.
Q3) The present value is the amount, or initial outlay, at the beginning of the transaction.
A)True
B)False
Q4) Initial loan amount (pv)
A)#1
B)#2
C)#3
D)#4
E)#5
F)#6
Page 8
Q5) This function rounds the taxes owed: =-____________________(Taxrate*C16,0).
To view all questions and flashcards with answers, click on the resource link above.
Chapter 7: Organizing Data for Effective Analysis
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/12475
Sample Questions
Q1) The SEARCH function is case sensitive.
A)True
B)False
Q2) The term ____________________ is commonly used in the XML community to describe an XML document that is properly structured, and meets established rules and guidelines for how data is described and defined using XML.
Q3) When you add a schema to a workbook, Excel generates an ____ to create mapped ranges of data, and define the relationships between these ranges and the elements in the XML schema.
A) XML map
B) XML diagram
C) XML linked table
D) XML flow chart
Q4) The data format that separates the values in each record with commas is often called ____.
A) comma-separated values (CSV)
B) comma-separated data (CSD)
C) comma data (CD)
D) comma-separated records (CSR)
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Using Data Tables and Excel Scenarios for
What-If Analysis
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/12476
Sample Questions
Q1) ____________________ is a process of changing values to see how those changes affect the outcome of formulas in an Excel worksheet.
Q2) A defined name can be used outside its scope if it is ____, which means if its original scope is identified in its reference.
A) qualified
B) saved
C) archived
D) linked
Q3) To set up a scenario, you create or use a worksheet that contains sets of input and output cells, as you do with data tables. For example, in a worksheet listing sales assumptions and projections, the projections are ____.
A) input cells
B) output cells
C) guiding cells
D) lead cells
Q4) A(n) ____________________ is a set of values stored in a worksheet that describes different situations, such as worst-case, likely case, and best-case scenarios.
Q5) The Scenario Manager refers to output cells as ____________________ cells.
Page 10
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Enhancing Decision Making with Solver
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/12477
Sample Questions
Q1) Solver can produce four different reports: summary, answer, sensitivity, and limits.
A)True
B)False
Q2) A(n) ____ function is a mathematical formula that relates the decision variables or variable cells to the desired outcome.
A) objective
B) subjective
C) relative
D) absolute
Q3) Saving a(n) ____________________ saves the Solver parameters that were used in the Solver model so you can load them later, if necessary.
Q4) The objective function or formula that you use in the objective cell can be ____.
A) linear
B) nonlinear
C) either a or b
D) neither a nor b
Q5) The ____________________ constraint assigns the value 0 or 1 to variable cells.
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Troubleshooting Workbooks and Automating Excel Applications
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/12478
Sample Questions
Q1) A(n) ____________________ cell contains a value that is used in a formula in the active cell.
Q2) A(n) ____________________ is a series of commands that you store and then run when you need to perform a task.
Q3) ____ tracer arrows point to another cell that provides data for the active cell.
A) Blue
B) Yellow
C) Green
D) Orange
Q4) The error message #NAME? indicates ____.
A) unrecognized text in a formula
B) not enough column space for text
C) a name is required
D) an unrecognized name in a cell
Q5) Which of the following is NOT one of the three tabs in the Data Validation dialog box?
A) Settings
B) Input Message
C) Error Alert
D) Audit
To view all questions and flashcards with answers, click on the resource link above. Page 12