Computer Applications in Business Study Guide
Questions
Course Introduction
Computer Applications in Business explores the fundamental role of computer technologies in modern business operations. The course covers essential software tools such as word processors, spreadsheets, databases, and presentation programs, emphasizing their practical use in managing business information, supporting decision making, and streamlining processes. Students learn how to apply these applications in areas including accounting, marketing, human resources, and supply chain management, while also gaining an understanding of emerging digital trends like cloud computing and collaborative platforms. By the end of the course, students develop the skills to efficiently leverage computer applications to solve real-world business problems and improve organizational productivity.
Recommended Textbook
Your Office Microsoft Excel 2013 Comprehensive 1st Edition by Amy S. Kinser
Available Study Resources on Quizplus 16 Chapters
1553 Verified Questions
1553 Flashcards
Source URL: https://quizplus.com/study-set/1565 Page 2
Chapter 1: Navigate, manipulate, and Print Worksheets
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/30981
Sample Questions
Q1) Which of the following is NOT contained in a cell?
A)Functions
B)Formulas
C)Subroutines
D)Text
Answer: C
Q2) The intersection of a row and column is called a ________.
A)cell
B)container
C)chamber
D)cubicle
Answer: A
Q3) The keyboard shortcut to move one column to the right is ________.
Answer: Tab
Q4) ________ data is automatically left-aligned by Excel.
Answer: Text
Q5) The ________ view is used to show page margins,print headers and footers,and page breaks.
Answer: Page Layout
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Formatting, functions, and Formulas
Available Study Resources on Quizplus for this Chatper
94 Verified Questions
94 Flashcards
Source URL: https://quizplus.com/quiz/30987
Sample Questions
Q1) The MAX function finds the largest number in a range of numeric cells.
A)True
B)False
Answer: True
Q2) Adding a total row to a table only allows you to sum the columns.
A)True
B)False
Answer: False
Q3) To hide or show gridlines in a worksheet,you click Gridlines in the ________.
A)Workbook Views group on the VIEW tab
B)Show group on the VIEW tab
C)Workbook Views group on the HOME tab
D)Show group on the HOME tab
Answer: B
Q4) Show Formulas is a toggle button.
A)True
B)False
Answer: True
Q5) Pressing the ________ key deactivates Format Pointer.
Answer: Esc
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Cell References, named Ranges, and Functions
Available Study Resources on Quizplus for this Chatper
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/30988
Sample Questions
Q1) The result of =LEN("54")is 9.
A)True
B)False Answer: False
Q2) Which of the following is NOT a financial function?
A)PMT
B)PPMT
C)NPV
D)APR
Answer: D
Q3) =$B$2 - C5 is an example of mixed cell referencing.
A)True
B)False Answer: False
Q4) ________ indicates that an error occurred when using the DATEDIF function Answer: #NUM!
Q5) Excel's ________ function returns the smallest number from a set of numbers. Answer: MIN
Q6) Excel's ________ returns the current date and time. Answer: NOW
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Effective Charts
Available Study Resources on Quizplus for this Chatper
94 Verified Questions
94 Flashcards
Source URL: https://quizplus.com/quiz/30989
Sample Questions
Q1) To show the relationship between two numeric variables,you would use a ________ chart.
A)Cluster
B)Surface
C)Scatter
D)Radar
Q2) To create a line chart,at least one set of labels and at least one set of corresponding data are needed.
A)True
B)False
Q3) When working with a chart,you click the ________ to display the CHART TOOLS.
Q4) To illustrate the relationship of the parts to the whole,you would use a(n)________ chart.
A)Line
B)Pie
C)Scatter
D)Area
Q5) A common use for ________ charts is for project management.
Q6) A common enhancement for a scatter chart is the addition of ________.
Q7) ________ gridlines are displayed at each of the designated label values.
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Complex Conditional and Retrieval Functions
Available Study Resources on Quizplus for this Chatper
97 Verified Questions
97 Flashcards
Source URL: https://quizplus.com/quiz/30990
Sample Questions
Q1) The ________ function is appropriate when there are many options that do fit the desired criteria and only one option that does not fit the criteria.
Q2) The correct syntax for the COUNTIF function is: COUNTIF(range,logical_test).
A)True
B)False
Q3) The ________ function is used when the lookup_value argument checks the top row of the table_array.
A)HLOOKUP
B)VLOOKUP
C)RLOOKUP
D)TLOOKUP
Q4) The AVERAGEIFS function expands on the AVERAGEIF function,allowing multiple criteria to determine the subset of data.
A)True
B)False
Q5) The ________ function is a useful tool for detecting an error and displaying something more user friendly than the error message.
Q6) A(n)________ aggregate function incorporates calculation and a logical decision.
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Analyze Data Using Tables
Available Study Resources on Quizplus for this Chatper
97 Verified Questions
97 Flashcards
Source URL: https://quizplus.com/quiz/30991
Sample Questions
Q1) To edit or view existing named ranges,click the Define Name button on the Formulas tab.
A)True
B)False
Q2) It is NOT recommended to use the standard formatting techniques found on the ________ tab with PivotTables.
A)Home
B)Insert
C)Design
D)Layout
Q3) Summarize Values By located on the ________ tab offers a list of alternatives for summarizing data values.
Q4) Using Excel's Hide Rows feature is a recommended feature when filtering data. A)True
B)False
Q5) A PivotTable can be created on a new or an existing ________.
Q6) Convert to ________ located on the Design tab is used to convert a table to data.
Q7) ________ is a process of hiding records that do not meet specified criteria in a data set.
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Multiple Worksheets workbooks and Templates
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/30992
Sample Questions
Q1) Links to workbooks are easily broken,especially if files are moved or deleted.
A)True
B)False
Q2) Excel 2013 addresses linked workbooks using absolute addresses,where prior versions of Excel used relative addresses.
A)True
B)False
Q3) If a workbook contains multiple worksheets that contain either an identical structure or data with identical row and column labels,a user can create a summary worksheet using the ________ feature.
Q4) If you want to summarize data from multiple places and want to arrange the data in all the worksheets in identical order and location,you would use the ________ option.
A)consolidate by category
B)consolidate by formula
C)PivotTable report
D)consolidate by position
Q5) Consolidation by ________ is more flexible than consolidation by position.
Q6) Excel 2013 addresses linked workbooks using ________ addresses.
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Refine an Excel Application
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/30993
Sample Questions
Q1) Whole number validation is functionally identical to codified validation with the exception that only integer values are valid.
A)True
B)False
Q2) A(n)________ cell is a cell whose value depends on the value in the active cell for its result.
Q3) Whole number validation is functionally identical to ________ validation with the exception that only integer values are valid.
A)decimal
B)numeric
C)fractional
D)percentage
Q4) Macros can be run from the ________ tab or from a button added to a worksheet.
Q5) At its most basic,a ________ in Excel is a recording of keystrokes and mouse clicks performed to complete a task.
A)sparkline
B)callout
C)macro
D)hyperlink
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Organize, import, export, and Cleanse Data Sets
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/30994
Sample Questions
Q1) To remove any nonprinting characters from a text string,use the ________ function.
A)CLEAN
B)PROPER
C)TRIM
D)SUBSTITUTE
Q2) You can import tables and queries from Access by dragging the object from the Navigation Pane and dropping it into the desired starting cell.
A)True
B)False
Q3) An XML document uses ________ that include start tags,end tags and the data itself.
A)map
B)markup
C)schema
D)elements
Q4) HTML describes the content of the data between tags.
A)True
B)False
Q5) Formatting for an XML document is saved with the ________ file extension.
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Data Tables, scenario Manager, and Solver
Available Study Resources on Quizplus for this Chatper
94 Verified Questions
94 Flashcards
Source URL: https://quizplus.com/quiz/30982
Sample Questions
Q1) Which What-If Analysis tool would be best at determining how much you can borrow for a car loan while paying only $275 a month?
A)Scenario Manager
B)Solver
C)Data Table
D)Goal Seek
Q2) When the golf course is open for business,they have to pay management salaries,insurance,depreciation of building and equipment,and so on,regardless of how many customers they have during the day.These are examples of variable costs.
A)True
B)False
Q3) Which What-If Analysis tool would be best at comparing how interest rates affect a monthly car payment?
A)Goal Seek
B)Scenario Manager
C)One-variable data table
D)Two-variable data table
Q4) To add a scroll bar,you first need to add the ________ tab.
Q5) To compare scenarios,create a scenario ________ report.
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 11: Loan Amortization, investment Analysis, and Asset Depreciation
Available Study Resources on Quizplus for this Chatper
94 Verified Questions
94 Flashcards
Source URL: https://quizplus.com/quiz/30983
Sample Questions
Q1) The NPER function can be useful if you do not have all the information you need to calculate loan payments with the PMT function or you would like to verify the actual interest rate of the loan.
A)True
B)False
Q2) To calculate a monthly loan payment for a 30-year mortgage loan with a monthly rate of 4%,where A5 = 4%,you would enter ________ for the rate argument.
Q3) The ________ function calculates what an investment would be worth in today's dollars.
A)FV
B)NPV
C)PV
D)PMT
Q4) An amortization table shows the interest rate for each payment.
A)True
B)False
Q5) The FV function requires ________ arguments.
Page 13
Q6) Banks measure ________,or potential losses,when assessing a corporate loan.
Q7) The IRR and ________ functions are used for capital budgeting purposes.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 12: Business Statistics and Regression Analysis
Available Study Resources on Quizplus for this Chatper
97 Verified Questions
97 Flashcards
Source URL: https://quizplus.com/quiz/30984
Sample Questions
Q1) In administering a survey where respondents answer "Yes" or "No" to a specific question,ordinal variables could be used to categorize the responses,such as 1 = Yes and 2 = No.
A)True
B)False
Q2) The more random the sample,the more accurate the statistical analysis will be,in part,because randomness eliminates bias.
A)True
B)False
Q3) ________ is a method used to predict future values by analyzing the relationships between two or more variables.
A)The R square value
B)The correlation coefficient
C)The regression analysis
D)The intercept coefficient
Q4) Interval data measures the size of the difference between values.
A)True
B)False
Q5) ________ is the practice of collecting,analyzing,and interpreting data.
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 13: Excels Data Model, Power-pivot, and Power View
Available Study Resources on Quizplus for this Chatper
92 Verified Questions
92 Flashcards
Source URL: https://quizplus.com/quiz/30985
Sample Questions
Q1) ________ is a powerful tool that creates engaging,interactive user experiences.
A)Sparklines
B)Power View
C)Slicers
D)Silverlight
Q2) ________ provide a way to graphically summarize a row or column of data in a single cell.
Q3) One of the primary goals of a dashboard is to help the user navigate and interpret a large quantity of data at a glance.This is an example of the ________ design concept.
A)Making Sure It Is Well Defined
B)Keeping It Simple
C)Knowing Your Users
D)Designing with White Space
Q4) The number of sick days in a specific time period is an example of a ________.
A)positive KPI
B)negative KPI
C)KPI
D)bidirectional KPI
Q5) The ________ provides a structure for managing complex IT projects.
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 14: Visual Basic for Applications
Available Study Resources on Quizplus for this Chatper
92 Verified Questions
92 Flashcards
Source URL: https://quizplus.com/quiz/30986
Sample Questions
Q1) Creating a lookup table and using the ________ function is a common approach to linking values to various form controls.
Q2) Names for Sub procedures must begin with a(n)________ and cannot contain any spaces.
Q3) Press F3 in the VBE to display the Object Browser,which shows properties,methods,and events for an object.
A)True
B)False
Q4) An object model consists of a(n)________ collection of objects,consisting of properties,methods,and events that can be manipulated using VBA.
Q5) ________ are used to execute a series of statements multiple times.
A)Data ports
B)Variables
C)Elements
D)Loops
Q6) A function procedure is a group of VBA statements that perform a calculation and return a single value.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 16
Chapter 15: Appendix:efficient Interaction With a Touch Screen
Available Study Resources on Quizplus for this Chatper
62 Verified Questions
62 Flashcards
Source URL: https://quizplus.com/quiz/30996
Sample Questions
Q1) ________ are small pictures representing commands,programs,and documents.
A)Menus
B)Buttons
C)Clicks
D)Icons
Q2) Both Surface covers come with a built-in ________.
Q3) One of the key features that sets Windows 8 apart from previous versions is the built-in ________.
A)speech recognition
B)stylus recognition
C)touch-screen recognition
D)digital recognition
Q4) The Surface Pro tablet comes with a(n)________ -a device that allows you to write on a touch screen like a pen does on paper.
Q5) One major discriminator in determining which tablet to choose is the ________ it runs.
A)operating system
B)software
C)apps
D)network
To view all questions and flashcards with answers, click on the resource link above. Page 17
Chapter 16: The Common Features of Microsoft Office
Available Study Resources on Quizplus for this Chatper
77 Verified Questions
77 Flashcards
Source URL: https://quizplus.com/quiz/30995
Sample Questions
Q1) Traditionally,files have been saved locally on a hard drive or external storage device.
A)True
B)False
Q2) Files created by Excel are called ________.
A)workbooks
B)tables
C)documents
D)worksheets
Q3) The ________,located in the lower-right corner of some groups,opens a corresponding dialog box or task pane.
A)Task Pane Launcher
B)Dialog Box Launcher
C)Toggle buttons
D)Charms bar
Q4) If there is no Internet access,only files installed on the computer will display in the Help window.
A)True
B)False
Q5) The ________ window provides information about a multitude of topics.
To view all questions and flashcards with answers, click on the resource link above. Page 18