Quantitative Methods for Business Final Exam
Course Introduction
Quantitative Methods for Business provides students with the analytical tools and techniques used to support effective decision-making in business environments. The course covers topics such as descriptive statistics, probability theory, linear programming, forecasting, statistical inference, regression analysis, and decision analysis. Students will learn how to apply mathematical models and quantitative reasoning to solve real-world business problems, interpret data, and enhance operational efficiency. Emphasis is placed on problem-solving, the use of software tools, and the practical application of quantitative methods across various business functions including finance, marketing, operations, and management.
Recommended Textbook
Exploring Microsoft Office Excel 2016 Comprehensive 1st Edition by Mary Anne Poatsy
Available Study Resources on Quizplus
13 Chapters
1286 Verified Questions
1286 Flashcards
Source URL: https://quizplus.com/study-set/1601 Page 2
Chapter 1: Introduction to Excel
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/31798
Sample Questions
Q1) The contents of a cell can be seen in the naming box.
A)True
B)False
Answer: False
Q2) A range is specified by its ________.
A)top and bottom row and left and right column
B)top row and leftmost column
C)top right and bottom left cells
D)top left and bottom right cells
Answer: D
Q3) You can move a range by using the cut and paste commands.
A)True
B)False
Answer: True
Q4) One point is how big?
A)1/72 of an inch
B)1/36 of an inch
C)The same as a pixel
D)The same as one character
Answer: A
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Formulas and Functions
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/31799
Sample Questions
Q1) Functions can be nested inside the arguments in the various lookup functions.
A)True
B)False
Answer: True
Q2) Which of the following is not a valid lookup function?
A)HLOOKUP
B)VLOOKUP
C)LLOOKUP
D)LOOKUP
Answer: C
Q3) The COUNTA function only counts text entries.It does not count calculable values or blank cells.
A)True
B)False
Answer: False
Q4) The most used logical function is the IF function.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Charts
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/31800
Sample Questions
Q1) How many variations of the stock chart does Excel have?
A)1
B)2
C)3
D)4
Answer: D
Q2) Which chart type is a visual "dashboard" of your data?
A)Bar chart
B)Sparkline
C)Line chart
D)Column chart
Answer: B
Q3) In the Insert Chart dialog box,after you pick a chart type where are the subtypes listed?
A)Bottom left
B)Bottom right
C)Top left
D)Top right
Answer: D
To view all questions and flashcards with answers, click on the resource link above.
Page 5
Chapter 4: Datasets and Tables
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/31801
Sample Questions
Q1) To print row labels on the left side of each page you would select the row(s)that contain the labels in the rows to repeat at left box.
A)True
B)False
Q2) In a structured reference what do you use to indicate a column heading or field name?
A)Brackets []
B)Parenthesis ()
C)Curly brackets {}
D)Quotes ""
Q3) When would you not need to use a fully qualified structured reference?
A)When referring to a cell outside the table
B)When referring to a cell on a different worksheet
C)When referring to a cell on a different workbook
D)When referring to a cell within the table
Q4) In a structured reference,when you use field headings without row references it is called a(n)________ reference.
Q5) The print ________ is the range of cells that will be printed.
Q6) Using the Print ________ can help you save paper.
Page 6
To view all questions and flashcards with answers, click on the resource link above.
Chapter 5: Subtotals, Pivot-tables, and Pivot-charts
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/31802
Sample Questions
Q1) A(n)________ quickly formats a PivotTable with bold,fonts,shading,headers.
Q2) What does applying a banded row format do to a Pivot Table?
A)Puts a band around subtotals
B)Shades odd and even rows differently
C)Keeps totals together
D)Puts a line between each row
Q3) If you would like to show a subtotal of the wholesale price of a number of items of clothing on a PivotTable of data of both men and women.You have the following fields: Gender,Item and Price.Sum of Price is in the VALUES area.Gender is in the ROWS area.How do you get a subtotal of shirts and pants to display for each gender?
A)Drag the Item field to VALUES.
B)Drag the Item field above Gender in ROWS.
C)Drag the Gender field off the ROWS.
D)Drag the Item field beneath Gender in ROWS.
Q4) You can clear all fields from a PivotTable.
A)True
B)False
Q5) A slicer can be formatted so the ________ display in one or many columns.
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: What-If Analysis
Available Study Resources on Quizplus for this Chatper
92 Verified Questions
92 Flashcards
Source URL: https://quizplus.com/quiz/31803
Sample Questions
Q1) A(n)________ is a rule that Solver has to enforce to reach the objective value.
Q2) The what-if analysis tool which uses two substitution values is a(n)________ data table.
Q3) What selections in the File tab do you make to load an add-in?
A)Properties and then Solutions
B)Properties and then Add-ins
C)Options and then Solutions
D)Options and then Add-ins
Q4) A variable is an input value that changes the outcome of the situation.
A)True
B)False
Q5) What tool would be most effective when comparing the impact of changes in interest rate and purchase price on a new car loan?
A)Scenario Manager
B)Solver
C)Goal Seek
D)Two-variable data table
Q6) ________ analysis enables you to compare how changes affect a related outcome.
Q8) How many scenarios can Scenario Manager manage? Page 8
Q7) Use the ________ to edit,delete and create range names.
To view all questions and flashcards with answers, click on the resource link above.
Page 9
Chapter 7: Specialized Functions
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/31804
Sample Questions
Q1) The EOMONTH function returns the last day of the month of the specified number of months from a given date.
A)True
B)False
Q2) The ________ database function will add the values on a specified criteria range.
Q3) An empty cell in the criteria in an Advanced Filter will display no records.
A)True
B)False
Q4) Why would you nest MATCH in an INDEX function?
A)To handle multiple outcomes
B)To find the highest or lowest value in an array
C)To use the position returned in the Match function as an argument in the index function
D)To use the value returned in the Match function as a lookup in the index function
Q5) This is a correct example of the structure of an IPMT function.=IPMT(rate,per,nper,pv,[fv],[type])
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 8: Statistical Functions
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/31805
Sample Questions
Q1) ________ determines how two sets of data from a sample vary simultaneously.
A)STDEV.S
B)COVARIANCE.S
C)CORREL
D)STDEV.P
Q2) The ________ function calculates the average,or arithmetic mean,of all cells in a range that meet a specific condition.
Q3) ________ is a statistical hypothesis test that helps determine if samples of data were taken from the same population.
Q4) What is MS in an ANOVA summary report?
A)Mean of the sample squared
B)Maximum of squared value
C)Minimum of squared value
D)Multiplier of sample
Q5) The ________ is the square root of the variance.
Q6) The ________ function counts the number of cells in a range that meet multiple criteria.
Q7) The ________ function returns the length of the repetitive pattern Excel detects for the time series.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Multiple-Sheet Workbook Management
Available Study Resources on Quizplus for this Chatper
89 Verified Questions
89 Flashcards
Source URL: https://quizplus.com/quiz/31806
Sample Questions
Q1) If you cannot immediately see the source of an error in a nested formula,this tool will walk you through the intermediary calculations.
A)Evaluate Formula
B)Trace Dependents
C)Trace Precedents
D)IFERROR
Q2) View Side by Side locks two worksheets to scroll together.
A)True
B)False
Q3) What is a 3-D reference?
A)A data cube function
B)A reference to multiple cells
C)A circular reference to the cell
D)A cell reference to another worksheet
Q4) A(n)________ is where you go when you click a hyperlink.
Q5) The #NAME?
error means that at least one argument is missing in the function. A)True
B)False
Q6) '[StPaul.xlsx]Qtr3'!A3 is an example of a(n)________.
Page 12
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: Imports, xml, and Power Add-Ins
Available Study Resources on Quizplus for this Chatper
88 Verified Questions
88 Flashcards
Source URL: https://quizplus.com/quiz/31807
Sample Questions
Q1) Power Query is ________.
A)installed by default
B)enabled in Options
C)downloadable Excel add-in
D)on the Data tab
Q2) What governing body developed XML?
A)NSA
B)ICANN
C)Word Wide Web Consortium (W3C)
D)IEEE
Q3) Embedded data in an excel workbook is ________.
A)uneditable data linked to a web source
B)data that imported using Power Query
C)any imported data
D)editable data with no link back to its original source
Q4) There are 27 Text string manipulation functions.
A)True
B)False
Q5) ________ is an industry standard for structuring data across applications,operating systems and hardware.
Page 13
To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: Collaboration and Workbook Distribution
Available Study Resources on Quizplus for this Chatper
87 Verified Questions
87 Flashcards
Source URL: https://quizplus.com/quiz/31808
Sample Questions
Q1) What cloud based storage service is integrated in Excel 2016?
A)iCloud
B)OneDrive
C)Dropbox
D)SyncUp
Q2) The menu which displays when you click the File tab is the ________.
Q3) The ________is a tool that reviews a workbook for hidden or personal data stored in the workbook or personal document properties.
A)History Worksheet
B)Issue Checker
C)Review Panel
D)Document Inspector
Q4) History worksheets are ________ when the file is saved.
Q5) Documents can have only one author defined in the document properties.
A)True
B)False
Q6) A workbook marked as final is shared.
A)True
B)False
Q7) The Share Workbook command is on the ________ tab.
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 12: Templates, styles, and Macros
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/31809
Sample Questions
Q1) On which tab is the Themes Gallery?
A)File
B)Insert
C)Page Layout
D)View
Q2) There are many templates available online.
A)True
B)False
Q3) Which of the following is false about a VBA object?
A)Contains data
B)Contains code
C)Starts with '
D)Represents a Range
Q4) A(n)________ performs actions on a workbook but doesn't necessarily return a specific value.
Q5) Which of the following is false about recording a macro?
A)Cell selections can be recorded as absolute references.
B)There is a pause button which allows you to remove mistakes as you record.
C)The recorder records everything you do.
D)It is a good idea to plan your steps and practice them before recording.
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 13: Office 2016 Common Features
Available Study Resources on Quizplus for this Chatper
91 Verified Questions
91 Flashcards
Source URL: https://quizplus.com/quiz/31797
Sample Questions
Q1) The ________ provides fast access to commonly executed tasks such as saving a file and undoing recent actions.
Q2) Office's ________ is an area of memory reserved to temporarily hold selections that have been cut or copied.
A)gallery
B)Clipboard
C)contextual tab
D)Ribbon
Q3) You can use the ________ to quickly and easily copy all formatting from one area to another.
Q4) Clicking a Dialog Box ________ button on the Ribbon opens a corresponding dialog box.
A)Group
B)Header
C)Tab
D)Launcher
Q5) The Mini toolbar is not customizable.
A)True
B)False
Q6) A(n)________ consists of one or more lines at the top of each page.
Page 16
To view all questions and flashcards with answers, click on the resource link above.