Business Computer Applications Mock Exam - 1553 Verified Questions
Business Computer Applications
Mock Exam
Course Introduction
Business Computer Applications introduces students to the fundamental concepts and practical uses of computer technology in a business environment. The course covers software applications such as word processing, spreadsheets, databases, and presentations, emphasizing their role in enhancing productivity and decision-making. Students learn to use common business software tools, manage digital data efficiently, and apply information technology to solve real-world business problems. Through hands-on projects and case studies, the course prepares students to leverage computer applications for effective communication, data analysis, and business operations.
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) If you mistakenly delete a worksheet,you can recover it by pressing Undo.
A)True
B)False
Answer: False
Q2) Which of the following is NOT contained in a cell?
A)Functions
B)Formulas
C)Subroutines
D)Text
Answer: C
Q3) To remove a cell from a worksheet,you select the cell and press the Delete key.
A)True
B)False
Answer: False
Q4) Which of the follow is NOT a worksheet view?
A)Normal view
B)Page Layout view
C)Spreadsheet Preview
D)Page Break Preview
Answer: C
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 AutoSum button is located in the Editing group on the HOME tab.
A)True
B)False Answer: True
Q2) Only visible data is a table is used by the SUBTOTAL function in calculating results.
A)True
B)False
Answer: True
Q3) Following Excel's order of operations,the result of the formula =2*4-2^3 is
Answer: 0
Q4) A table style is a predefined set of formatting properties that control the appearance of a table.
A)True
B)False Answer: True
Q5) ________ color is the background color of a cell. Answer: Fill
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) If you want to find the time between two dates,you would use the ________ function.
A)DATE
B)TIME
C)DATEDIF
D)WEEKNUM
Answer: C
Q2) ________ indicates that an error occurred when using the DATEDIF function
Answer: #NUM!
Q3) When cell A4 containing the formula =$B$5/$C$6 is copied to cell F6,the formula in cell F6 is ________.
A)=G7/H8
B)=$G$7/$H$8
C)=B5/C6
D)=$B$5/$C$6
Answer: D
Q4) Excel's AVERAGE function returns the mean of a set of numbers.
A)True
B)False
Answer: True
Page 5
To view all questions and flashcards with answers, click on the resource link above.
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) When adding colors to a chart,more is better.
A)True
B)False
Q2) After inserting a shape into a graph,you can enter text in the shape.
A)True
B)False
Q3) A(n)________ is a line that uses current data to display the progress or general direction of the data.
A)major gridline
B)minor gridline
C)trendline
D)axis
Q4) Care must be taken when adding or removing chart elements,since the position of other elements may change.
A)True
B)False
Q5) A scatter chart is a variation of a stacked line chart emphasizing the amount of change over time.
A)True
B)False
Page 6
To view all questions and flashcards with answers, click on the resource link above.
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) A(n)________ allows you to break down potential decisions in a logical,structured format.
A)decision model
B)decision tree
C)true/false diagram
D)IF function diagram
Q2) The ________ function allows for multiple criteria in multiple ranges to be evaluated and counted.
A)COUNT
B)COUNTA
C)COUNTIF
D)COUNTIFS
Q3) All of the following statements are TRUE about an Excel database EXCEPT:
A)An Excel database is a way of storing data that is made up of records and fields.
B)In a database, each record is one unit of data.
C)All database functions are named using the format DBXXX()where XXX is the name of the corresponding nondatabase Excel function.
D)All database functions include the same three arguments.
Q4) 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) PivotTable data formatted through the ________ dialog box applies to all other cells within the same field.
A)Value Field Settings
B)Format Data
C)Data Settings
D)Format Fields
Q2) All of the following statements are TRUE regarding raw data EXCEPT:
A)Raw data may be numeric or text.
B)Raw data without context is meaningless to users.
C)Information is another name for data.
D)Raw data is unorganized.
Q3) The PivotTable ________ tab focuses on formatting and the appearance aspect of designing the PivotTable.
A)Layout
B)Options
C)Design
D)Format
Q4) Using Excel's Hide Rows feature is a recommended feature when filtering data.
A)True
B)False
Page 8
To view all questions and flashcards with answers, click on the resource link above.
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) A 3-D named range can be defined in the Name box.
A)True
B)False
Q2) A(n)________ named range cannot be defined in the Name box.
Q3) An Excel template is saved with the ________ extension.
Q4) A worksheet can store only ________ consolidation(s).
Q5) Although it is possible for multiple users to collaborate in creating a workbook,it is more common for users to collaborate in keeping ________ in a workbook up-to-date once the workbook has been developed.
Q6) Excel addresses linked workbooks by using ________ addresses.
A)relative
B)absolute
C)comparative
D)bound
Q7) Consolidating by category is more ________ than consolidating by position.
Q8) The ________ command will compare the changes made in each shared workbook and then provide you with the option to update the workbook with those changes.
Q9) A(n)________ references the same cell,or range of cells,across multiple worksheets in a workbook. Page 9
To view all questions and flashcards with answers, click on the resource link above.
Page 10
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) Active code such as macros and ActiveX controls should be opened from a Trusted Location.
A)True
B)False
Q2) ________ validation presents the user with a list of data values from which the user can choose.
A)Directory
B)Registry
C)Index
D)List
Q3) To hide the horizontal scroll bar on a workbook,click the ________ tab,click Options,click Advanced,and uncheck Show horizontal scroll bar.
A)File
B)Page Layout
C)Review
D)View
Q4) ________ validation is generally used to limit the number of characters that can be entered into a cell.
Q5) Completely hiding formulas in a worksheet is a(n)________-step process.
To view all questions and flashcards with answers, click on the resource link above. Page 11
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) Text functions help to extract and standardize data.
A)True
B)False
Q2) Because Flash Fill involves less typing than traditional text functions,it can be easier to use on ________ devices.
Q3) Copy and pasting data from a website and using a web query have the same result.
A)True
B)False
Q4) To save a web query in Excel,use the ________ on the Data tab.
A)Data Validation command
B)Connections command
C)Edit Links command
D)Properties
Q5) To remove any nonprinting characters from a text string,use the ________ function.
A)CLEAN
B)PROPER
C)TRIM
D)SUBSTITUTE
Q6) A(n)________ document is saved as an .xsd file.
To view all questions and flashcards with answers, click on the resource link above. Page 12
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) PivotTables allow even more manipulation of data because of the three-dimensional view they provide.
A)True
B)False
Q2) Changing a binding constraint also changes the optimal solution.
A)True
B)False
Q3) Input values are listed in both columns and rows in a(n)________ data table.
Q4) The scroll bar is a type of ________ tool because of the ability to calculate numerous outputs in other cells by referencing the target cell in formulas and functions.
Q5) If a change in price is accompanied by a large change in quantity demanded,a product or service is considered ________.
Q6) If a large change in price is accompanied by a small amount of change in demand,a product or service is considered ________.
Q7) The Solver ________ Report shows the upper and lower bounds for the optimal value.
Q8) Of the three What-If Analysis tools available on the Data tab,the ________ can compare more than two variables.
Page 13
To view all questions and flashcards with answers, click on the resource link above.
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) A(n)________ is a legal document that can be bought and sold and holds some financial value.
Q2) Interest and principal make up EVERY payment in an amortization table.
A)True
B)False
Q3) When using the PMT function,you should type a negative sign in front of the present value of the loan so that the payment will result in a positive value.
A)True
B)False
Q4) Identify the correct formula to calculate the cumulative interest paid on a mortgage loan for the second year of the loan (periods 13-24,where rate =9%,nper= 5,present value = $250,000.
A)=CUMIPMT(.09/12, 5*12, 250000,13,24,0)
B)=CUMIPMT(.09/12, 5*12, 250000,24,13,0)
C)=CUMIPMT(.09*12, 30/12,-250000,13,24,0)
D)=CUMIPMT(.09/12, 30/12,-250000,24,13,0)
Q5) ________ is a reduction in the value of a fixed asset from its original cost.
Q6) The ________ is the unpaid balance amount of the loan.
Q7) The ________ method of depreciation spreads cost of an asset over its life.
To view all questions and flashcards with answers, click on the resource link above. Page 14
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) A normal distribution is displayed as a bell curve on a chart.
A)True
B)False
Q2) If the cumulative argument of the NORM.DIST function is set to FALSE,the result will be the probability of a value being equal to the value of the x argument,known as the ________ distribution function.
Q3) Calculating the range,variance,and kurtosis of a data set are all methods used to determine the dispersion of a data set.
A)True
B)False
Q4) ________ are only useful with discrete data that is sorted in either ascending or descending order.
A)Means
B)Medians
C)Modes
D)Central tendencies
Q5) Mathematically,the ________ is calculated by taking the square root of the variance.
Q6) To calculate the mean in Excel,the ________ function is used.
To view all questions and flashcards with answers, click on the resource link above. Page 15
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) Calculated Fields can be created in any of the cells in the Calculation Area of the PowerPivot window.
A)True
B)False
Q2) All of the following statements are TRUE about creating PivotTables and PivotCharts with PowerPivot EXCEPT:
A)PowerPivot gives you the same options as a Pivot Table except you can use relational data to build it.
B)PivotTables and PivotCharts are a major component in any dashboard.
C)PivotTables and PivotCharts can be created with data from multiple sources without any additional software or add-ins as long as it is relational data.
D)Not only can you create a single PivotTable or PivotChart on a worksheet with PowerPivot, but you can also create a PivotTable and PivotChart on the same worksheet as well as two PivotCharts arranged vertically or horizontally, or four PivotCharts on the same worksheet.
Q3) There are three different types of sparklines: line,pie,and win/loss.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 16
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) ________ are visual controls that allow you to quickly and easily filter your data in an interactive way.
Q2) A run-time error occurs when the code is executed,displaying a description of the error.
A)True
B)False
Q3) The Properties window contains a list of all the properties of a selected object such as name,size,and color.
A)True
B)False
Q4) A function procedure is a group of VBA statements that perform a calculation and return a single value.
A)True
B)False
Q5) A parameter is a special kind of variable used to refer to one of the pieces of data provided in a method.
A)True B)False
Q6) A(n)________ is a dialog box object that is created using the MsgBox command.
Page 17
To view all questions and flashcards with answers, click on the resource link above.
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) When a keyboard is not available,a ________ can be used.
A)mouse
B)touchpad
C)touch-screen keyboard
D)finger
Q2) GUI stands for Gradient User Interface.
A)True
B)False
Q3) The edge of the screen is called the ________.
Q4) Windows 8 supports ________ recognition,which allows you to control the computer with gestures instead of mouse clicks.
Q5) ________ are quick short gestures that can be made with a finger or a pen.
Q6) The Surface comes with two types of covers: the type cover and ________.
A)touch cover
B)click cover
C)custom cover
D)traditional cover
Q7) Speech recognition is a new feature in Windows 8.
A)True
B)False Page 18
To view all questions and flashcards with answers, click on the resource link above.
Page 19
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) Each Office program has its own Help window.
A)True
B)False
Q2) PDF files are commonly used to share files for business because free readers are readily available.
A)True
B)False
Q3) If you have not yet saved your document,it is stored only ________.
A)in temporary memory
B)on the hard drive
C)on a USB drive
D)on SkyDrive
Q4) Office 365 has several advantages over Office 2013,but requires payment of an annual fee.
A)True
B)False
Q5) One way to switch between windows is to use Alt + Tab.
A)True
B)False
Q6) The ________ window provides information about a multitude of topics.
To view all questions and flashcards with answers, click on the resource link above. Page 20
