Quantitative Methods in Business Exam Review
Course Introduction
Quantitative Methods in Business provides students with a comprehensive introduction to the mathematical and statistical techniques essential for effective decision-making in the business environment. The course covers key topics such as data analysis, probability, hypothesis testing, linear programming, forecasting, and decision theory.
Emphasizing the practical application of quantitative models, students learn how to analyze real-world business problems, interpret quantitative data, and select appropriate methods to support managerial decisions. Through case studies and problem-solving exercises, students gain proficiency in using quantitative tools to improve business operations and strategy.
Recommended Textbook
New Perspectives on Microsoft Excel 2010 Comprehensive 1st Edition by June Jamrich Parsons
Available Study Resources on Quizplus
14 Chapters
2100 Verified Questions
2100 Flashcards
Source URL: https://quizplus.com/study-set/1597 Page 2
Chapter 1: Getting Started With Excel
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31705
Sample Questions
Q1) Text is truncated when the cell that it resides in is not wide enough to display all of it.
A)True
B)False
Answer: True
Q2) Text data is any combination of ____.
A) letters and numbers
B) letters,numbers,and dates
C) only letters
D) letters,numbers,and symbols
Answer: D
Q3) Copying a range of cells is similar to moving a range,except that you must press the ____ key while you drag the selection to its new location.
A) Shift
B) F3
C) Esc
D) Ctrl
Answer: D
Q4) SUM,MAX,and MIN are ____________________.
Answer: functions
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Formatting a Workbook
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31706
Sample Questions
Q1) To change the font size one point at a time,in the Font group on the Home tab,click the ____ button.
A) Increase Font Size
B) Decrease Font Size
C) Change Font Size
D) either a or b
Answer: D
Q2) In Microsoft Excel,you can open an extended color palette of 134 standard colors._________________________
A)True
B)False
Answer: True
Q3) In conditional formatting,to highlight only cells that contain a specific date,select the rule____.
A) A Date Occurring
B) Duplicate Values
C) Text That Contains
D) Between
Answer: A
To view all questions and flashcards with answers, click on the resource link above.
Page 4
Chapter 3: Working With Formulas and Functions
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31707
Sample Questions
Q1) After you describe a function in the Insert Function dialog box,click ____.
A) Go
B) Select
C) Insert
D) Next
Answer: A
Q2) Arguments can be ____.
A) cell references
B) numbers
C) text
D) all of the above
Answer: D
Q3) The ____ category of Excel functions retrieves and analyzes data.
A) Text
B) Database
C) Information
D) Logical
Answer: B
Q4) The ____________________ is the middle value from a sample.
Answer: median
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Enhancing a Workbook With Charts and Graphs
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31708
Sample Questions
Q1) A(n)____ chart is similar to a line chart,but uses a fill color to shade areas under the lines.
A) bar
B) area
C) stock
D) column
Q2) In Excel,typing ____ in the Format Code: box would result in that month's full name being displayed on a chart.
A) m
B) mm
C) mmm
D) mmmm
Q3) You can use the 3-D Format options to add drop shadows,raised or beveled corners,and textured surfaces that give the illusion of ____ reflecting off the chart elements.
A) light
B) color
C) water
D) shadows
Q4) Excel supports ____________________ built-in charts.
Page 6
To view all questions and flashcards with answers, click on the resource link above.
Chapter
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31709
Sample Questions
Q1) When you click in each cell in the Total row,a(n)____ appears that you can click to open a list of the most commonly used functions.
A) menu
B) arrow
C) button
D) status bar
Q2) Each column in a range represents a(n)____________________ that describes some attribute or characteristic of a person,place,or thing.
Q3) Press ____ to return to cell A1 in a worksheet.
A) Ctrl+Home
B) Ctrl+Esc
C) F1
D) Alt+Esc
Q4) The ____ report layout displays one column for each field and leaves space for column headers.
A) Outline
B) Design
C) Tabular
D) Headers
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Managing Multiple Worksheets and Workbooks
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31710
Sample Questions
Q1) Some of the task-specific tasks available from the Office.com site include: Monthly Family Budget,Inventory List,and Time sheets._________________________
A)True
B)False
Q2) If Excel has not attempted to update the links in a given session,the Edit Links dialog box will show the status of the links as not checked._________________________
A)True
B)False
Q3) After you have saved a template,you can access the template from the New tab in ________________ view.
Q4) Excel has some templates that are automatically installed on your hard disk.
A)True B)False
Q5) The active worksheet in a group is indicated by ____ text.
A) bold
B) italicized
C) underlined
D) red
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Using Advanced Functions and Conditional Formatting
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31711
Sample Questions
Q1) With the DATEDIF function,the ____ interval code means months.
A) m
B) mo
C) mon
D) mth
Q2) The COUNTIF function is sometimes referred to as a(n)____ count.
A) network
B) criterion
C) conditional
D) basic
Q3) You cannot nest more than one IF function._________________________
A)True
B)False
Q4) The ____ error value means that,for example,a function name is misspelled.
A) #NAME?
B) #N/A
C) #NULL!
D) #NUM!
Page 9
Q5) The ____________________ function can determine if a cell contains an error value and displays the message you choose rather than the default error value.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 8: Developing an Excel Application
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31712
Sample Questions
Q1) In Office 2010,you can define a set of locations (file paths)where you can place files you consider trustworthy.This feature is known as ____ Locations.
A) Safe
B) Secure
C) Trusted
D) Quarantined
Q2) By digitally signing a workbook that contains a macro that she intends to publicly distribute,Renee assures her audience ____.
A) of the identity of the creator of the macro
B) that the macro has not been altered since the digital signature was created
C) that the macro will perform as expected
D) both a.and b.
Q3) Sometimes when you build a worksheet for other users,you may decide to add a(n)____ message to a cell even if you don't validate the data in that cell.
A) value
B) input
C) key
D) user
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Working With Financial Tools and Functions
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31713
Sample Questions
Q1) The ____ function calculates the number of payment periods in an investment or loan.
A) RATE
B) PV
C) NPER
D) FV
Q2) With ____ depreciation,the asset depreciates by equal amounts each year of its lifetime until it reaches the salvage value.
A) straight-line
B) double-declining
C) declining
D) sum of years' digit
Q3) The item marked ____________________ in the accompanying figure is the annual interest rate.
Q4) If you plan to invest money for 18 months,the value of the nper argument in the PMT function is 1.5._________________________
A)True
B)False
Q5) How do you determine which method of depreciation is most appropriate?
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Performing What-If Analyses
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31714
Sample Questions
Q1) The ____________________ input cell is the cell on which values placed in the first column of the data table are based.
Q2) The answer report is divided into ____ sections.
A) two
B) three
C) four
D) five
Q3) ____ is a program that searches for the optimal solution of a problem involving several variables.
A) Trial and error
B) Solver
C) Goal Seek
D) Scenario Manager
Q4) The ____________________ is the difference between the value in a cell and the value at the limit of the constraint.
Q5) In Solver,a(n)____________________ cell is a cell that you want to maximize,minimize,or change to a specific value.
Q6) Check the item marked 3 in the accompanying figure to hide the scenario in a(n)____________________ worksheet.
Page 12
To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: Connecting to External Data
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31715
Sample Questions
Q1) Contains data in an XML document
A)delimiter
B)database
C)record
D)field
E)table
F)query
G)criteria
H)common field
I)element
J)Rich Text
K)data map
L)schema
Q2) The ____ is the address of a Web page.
A) FTP
B) HTTP
C) HTML
D) URL
Q3) The point at which one column ends and another begins in the Text Import Wizard is called a(n)____________________ break.
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 12: Expanding Excel With Visual Basic for Applications
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31716
Sample Questions
Q1) The ____ control structure allows you to repeat a series of commands a set number of times.
A) If-Then-ElseIf
B) For-Next
C) Case Select
D) Do-For
Q2) ____ operators are used to combine expressions within a condition.
A) Conditional
B) Logical
C) Key
D) Concatenation
Q3) Closing a workbook or printing a worksheet's contents are examples of ____.
A) modules
B) properties
C) selections
D) methods
Q4) A project might contain several different modules._________________________
A)True
B)False
Q5) It is a good coding practice to write code in ____________________ text. Page 14
To view all questions and flashcards with answers, click on the resource link above.
Page 15
Chapter 14: Getting Started With Microsoft Office 2010
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31704
Sample Questions
Q1) In Backstage view,you will find the ____ along the left side of the screen.
A) Ribbon
B) Properties
C) navigation bar
D) file's author and other related people
Q2) Access is often referred to as a(n)relational database program._________________________
A)True
B)False
Q3) Mary is becoming more comfortable in PowerPoint.She is experimenting with adding bullets to a list she is creating in PowerPoint,but she is wondering why bullets appear and disappear in her workspace before she selects one in the Bullet Library.Her friend Polly explains to her that the feature she is experiencing is ____.
A) Live Preview
B) Live Gallery
C) Print Preview
D) Bullet Preview
Q4) In some cases,pressing the ____________________ key while a ScreenTip is displayed opens the Help window with the relevant topic displayed.
To view all questions and flashcards with answers, click on the resource link above. Page 17