Business Computer Applications
Exam Questions
Course Introduction
Business Computer Applications introduces students to essential computer skills and software commonly used in the business environment. The course covers topics such as word processing, spreadsheets, presentations, databases, and email communication, with a focus on practical applications in real-world business scenarios. Students will learn to efficiently manage information, create professional documents, analyze data, and use technology to solve problems and enhance productivity. By the end of the course, students will be proficient in using industry-standard software tools and will understand the importance of computer literacy in a modern business context.
Recommended Textbook
GO with Microsoft Excel 2016 Comprehensive 1st edition by Shelley Gaskin
Available Study Resources on Quizplus
12 Chapters
1128 Verified Questions
1128 Flashcards
Source URL: https://quizplus.com/study-set/2442
Page 2
Chapter 1: Introduction to Microsoft Office 2016 Features
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/48546
Sample Questions
Q1) For syncing to occur,a device must be connected to the Internet.
A)True
B)False
Answer: True
Q2) When you select an object for editing,the ________ displays commands that are commonly used with the selected object.
Answer: Mini toolbar
Q3) On the Save As screen,when you click ________,the Save As dialog box displays.
Answer: Browse
Q4) The first step in saving a file is to ________.
A)insert a storage device
B)open OneDrive
C)determine the location to save file
D)name the file
Answer: C
Q5) By default,when you enter text in an Office program it will overwrite existing text.
A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 1: Excell: Creating a Worksheet and Charting Data
Available Study Resources on Quizplus for this Chatper
97 Verified Questions
97 Flashcards
Source URL: https://quizplus.com/quiz/48535
Sample Questions
Q1) AutoFit adjusts the width of a column to fit the cell content of the widest cell in the column.
A)True
B)False
Answer: True
Q2) Scaling often works well for printing formulas since it shrinks the width and/or height of a printed worksheet.
A)True
B)False
Answer: True
Q3) When you type data in a cell and press Enter,what cell becomes the active cell?
A)The cell to the right
B)The cell below
C)The cell above
D)The insertion point does not move
Answer: B
Q4) A(n)________ is a prewritten formula that uses one or more cell references,performs an operation,and then returns a value. Answer: function
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 2: Excell: Using Functions, Creating Tables, and Managing Large Workbooks
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/48536
Sample Questions
Q1) Data can be edited on more than one worksheet at a time.
A)True
B)False
Answer: True
Q2) If a sheet tab has ________ you know that it is not selected.
A)a dotted background
B)a background color
C)a bolded border
D)a red border
Answer: B
Q3) You can double-click a sheet tab to rename it.
A)True
B)False
Answer: True
Q4) An Excel ________ is a range of cells converted in Excel used to analyze a group of related data.
Answer: table
Q5) A(n)________ illustrates the value of a cell relative to other cells in the worksheet. Answer: data bar
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 3: Excell: Analyzing Data With Pie Charts, Line
Charts, and What-If Analysis Tools
Available Study Resources on Quizplus for this Chatper
79 Verified Questions
79 Flashcards
Source URL: https://quizplus.com/quiz/48537
Sample Questions
Q1) Which of the following resides along the left side of a column chart?
A)The x-axis
B)The plot area
C)The y-axis
D)The legend
Q2) In Excel,you should use parentheses in order to specify the order in which operations needs to occur.
A)True
B)False
Q3) Match each of the following terms to its definition:
i.absolute cell reference
II.relative cell reference
III.data point
IV.data marker
v.data series
A)a group of related data points
B)the representation in a chart of a value from a worksheet
C)a value that originates in a worksheet cell and is used in a chart
D)changes when a formula is copied and pasted
E)does not change when a formula is copied and pasted
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 4: Excell: Use Financial and Lookup Functions,
Define Names, Validate Data, and Audit Worksheets
Available Study Resources on Quizplus for this Chatper
99 Verified Questions
99 Flashcards
Source URL: https://quizplus.com/quiz/48538
Sample Questions
Q1) An advantage to naming a range of cells is that you can use the name in a formula in other parts of your workbook.
A)True
B)False
Q2) Match the following five terms to their meanings:
i.validation list
II.data validation
III.defined name
IV.Watch Window
v.scope
A)technique to improve accuracy when completing a worksheet
B)location within which a defined name is recognized without qualification
C)displays the results of specified cells
D)a list that controls type of data entered for a group of cells
E)word or string of characters that represents a cell,a range of cells,a formula,or a constant value
Q3) When using a validation list,any value not on the list is considered ________.
Q4) The ________ command displays arrows that indicate what cells are affected by the value of the selected cell.
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 5: Excell: Managing Large Workbooks and Using Advanced Sorting and Filtering
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/48539
Sample Questions
Q1) By using a(n)________ filter,you can apply complex criteria to a single column.
Q2) You can use criteria to compare two values by using ________ operators.
Q3) Which of the following are some frequently and commonly used file formats for Excel?
A)Bitmap or JPEG
B)MDB or PDF
C)Excel Template,Excel 97-2003 Workbook,CSV or tab delimited D)TXT or DOC
Q4) Defining data as a table prior to sorting the data is optional.
A)True B)False
Q5) When you add subtotals,Excel defines groups and these groupings form a(n)________ of your worksheet that displays along the left side of the worksheet.
Q6) Data can be pulled out or copied from a filtered list and placed below the table of data.
A)True
B)False
Page 8
Q7) A sort on a group of numbers that is sorted from highest to lowest is known as a(n)________ sort.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 6: Excell: Creating Charts, Diagrams, and Templates
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/48540
Sample Questions
Q1) An Excel template is saved with the ________ extension.
Q2) To add text to a SmartArt graphic,you can type in the shape placeholders or you can open the ________.
Q3) Templates can have built-in ________ that display the results of calculations based on the data that is entered into the template.
A)tables
B)information
C)formulas
D)ranges
Q4) The key that defines the colors assigned to categories in a chart is called a(n)________.
A)object
B)element
C)legend
D)marker
Q5) ________ display alongside each row of data and provide a quick visual trend summary.
To view all questions and flashcards with answers, click on the resource link above. Page 9
Q6) The ________ controls the minimum,maximum,and incremental values on the value axis.
Chapter 7: Excell: Creating Pivottables and Pivotcharts
Available Study Resources on Quizplus for this Chatper
91 Verified Questions
91 Flashcards
Source URL: https://quizplus.com/quiz/48541
Sample Questions
Q1) In Microsoft Access,the field used to uniquely identify a record is the ________.
Q2) The Clear Filter command removes a filter.
A)True
B)False
Q3) A Data Model enables you to use a PivotTable by using the data from multiple,related tables.
A)True
B)False
Q4) In Microsoft Access,the field used to uniquely identify a record is called a
A)field
B)record
C)primary key
D)relationship
Q5) You cannot update or refresh PivotTable report data.
A)True
B)False
Q6) In Microsoft Access,each row is a ________ where all the categories of data pertaining to one person,place,event,thing,or idea is stored.
Page 10
To view all questions and flashcards with answers, click on the resource link above.
Chapter
Available Study Resources on Quizplus for this Chatper
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/48542
Sample Questions
Q1) Excel offers tools to help you project ________ results based on past performance.
A)recent
B)current
C)present
D)future
Q2) A moving average calculates an average for a group of numbers over a specified interval allowing you to see ________ for widely fluctuating numbers.
A)an objective
B)a trend
C)a scenario
D)a constraint
Q3) In a chart,a moving average events out the ________ in data,thus showing a pattern or trend more clearly.
Q4) A moving average is a ________ of averages computed from parts of a data series.
A)sequence
B)chart
C)combination
D)total
11
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Excell: Using Macros and Visual Basic for Applications
Available Study Resources on Quizplus for this Chatper
97 Verified Questions
97 Flashcards
Source URL: https://quizplus.com/quiz/48543
Sample Questions
Q1) Use caution when assigning a shortcut key to a macro so you do NOT override an existing shortcut within Excel.
A)True
B)False
Q2) ActiveX controls are useful for forms that are completed online,because you can control different events that occur when the control is used.
A)True
B)False
Q3) If you make an error when entering code and need to correct the error,you can click the ________.
A)Error Button
B)Fix Button
C)Jump Button
D)Debug button
Q4) A worksheet that contains fields and controls that enables someone to easily enter or edit data is a ________.
Q5) A macro will record the actions to automate a task.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 10: Excell: External Data, Database Functions, and
Side-By-Side Tables
Available Study Resources on Quizplus for this Chatper
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/48544
Sample Questions
Q1) If a worksheet is slightly wider and taller than the normal margins,use ________ to keep all the information on one page.
A)Scale to Fit
B)Page Layout
C)Orientation
D)Margins
Q2) Database functions are identified by the letters DF.
A)True
B)False
Q3) The ________ function will capitalize the first letter of each word.
A)TRIM
B)LEFT
C)MID
D)PROPER
Q4) The ________ function returns the specified number of characters from the beginning of a string of characters.
A)FRONT
B)LEFT
C)MID
D)RIGHT
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 11: Excell: Collaborating With Others and Preparing a
Workbook for Distribution
Available Study Resources on Quizplus for this Chatper
95 Verified Questions
95 Flashcards
Source URL: https://quizplus.com/quiz/48545
Sample Questions
Q1) To ensure that a workbook CANNOT be edited,you must ________.
A)click the Edit Anyway button
B)rename the workbook
C)password protect the workbook
D)apply the Mark as Final status
Q2) If you need to edit a read-only file,save it with the same file name,which preserves the original file.
A)True
B)False
Q3) The change history information includes the name of ________,when the change was made,and what data was changed.
A)the computer that was used
B)the file that was opened
C)the person who made the change
D)the folder that was opened
Q4) If your workbook is password protected,it can be opened without a password.
A)True
B)False
Page 14
Q5) To change the Attributes area in the Properties dialog box of a file,the file must be
To view all questions and flashcards with answers, click on the resource link above.