Business Computer Applications
Exam Answer Key
Course Introduction
Business Computer Applications introduces students to the essential computer technologies and software tools used in modern business environments. The course covers practical skills in word processing, spreadsheets, presentations, and database management using industry-standard applications such as Microsoft Office Suite or Google Workspace. Students will learn to create professional documents, manage data, analyze information, and effectively communicate through digital platforms, while also gaining an understanding of cybersecurity, cloud computing, and collaborative tools. By the end of the course, participants will be well-equipped to leverage computer applications for efficient problem-solving and decision-making in business settings.
Recommended Textbook Skills for Success with Office 2013 1st Edition Volume 1 by Kris Townsend
Available Study Resources on Quizplus
20 Chapters
2051 Verified Questions
2051 Flashcards
Source URL: https://quizplus.com/study-set/2707 Page 2
Chapter 1: Create Database Tables
Available Study Resources on Quizplus for this Chatper
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/54000
Sample Questions
Q1) The Enforce Referential Integrity option is available from the ________ dialog box.
A) File
B) Get External Data
C) Edit Relationships
D) List Answer: C
Q2) A(n) ________ key is a field used to relate records in a second table. Answer: foreign
Q3) Portrait is the default view that is applied each time a table is opened.
A)True
B)False
Answer: True
Q4) The Currency data type stores numbers formatted as monetary values.
A)True
B)False Answer: True
Q5) In the Datasheet Formatting dialog box, a(n) ________ of the selected formatting displays.
Answer: sample
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Create Select Queries
Available Study Resources on Quizplus for this Chatper
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/54001
Sample Questions
Q1) Because dates are stored as ________ numbers, you can include arithmetic and comparison operators in your criteria.
Answer: serial
Q2) It is NOT best practice to run a query to test it before adding criteria.
A)True
B)False
Answer: False
Q3) The Sum operator calculates the total of the values in each group.
A)True
B)False
Answer: True
Q4) The last step in creating a query in Design view is to add the tables.
A)True
B)False
Answer: False
Q5) When a value must not match, type <> and then type the value.
A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Create Forms
Available Study Resources on Quizplus for this Chatper
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/54002
Sample Questions
Q1) As you drag a field within a layout, a horizontal or vertical bar indicates where it will be placed when you release the mouse button.
A)True
B)False
Answer: True
Q2) To deselect one of the selected multiple controls, press and hold ________ while clicking with the pointer.
A) [Tab]
B) [Ctrl]
C) [Alt]
D) [Esc]
Answer: B
Q3) To create a one-to-many form, click the ________ button.
Answer: Form
Q4) When formatting a form in Layout view, only one control can be selected and formatted at a time.
A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Create Reports
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/54003
Sample Questions
Q1) Access formats a label report to match the dimensions of the label size.
A)True
B)False
Q2) Use the ________ to modify a report's design.
Q3) ________ view can be used to format a report while viewing the report's data.
Q4) To copy all the formatting of one control to other controls, use the Format Painter.
A)True
B)False
Q5) The Blank Report tool does NOT make it easy to arrange and format text controls.
A)True
B)False
Q6) In a tabular layout, labels are below each column.
A)True
B)False
Q7) In Print Preview view, ________ is the only Ribbon tab that displays.
Q8) When a report is based on a query, the query criteria is applied to the report.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 6
Q9) Access reports have three main sections-the header(s), footer(s), and ________.
Chapter 5: Common Features of Office 2013
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/54004
Sample Questions
Q1) When a word is ________, it will be replaced by whatever is typed next.
A) underlined
B) selected
C) bolded
D) italicized
Q2) Replace text in placeholders so the text prints.
A)True
B)False
Q3) When you are logged in to your Microsoft account, your name and picture display in the ________ of the window.
A) upper right corner
B) lower left corner
C) upper left corner
D) lower right corner
Q4) Templates for Office applications can be opened from the ________.
Q5) The ________ pane is used to move through a Word document.
A) Preview
B) Task
C) Navigation
D) Search
Page 7
To view all questions and flashcards with answers, click on the resource link above.
Chapter 6: Getting Started With Computer Concepts
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/54005
Sample Questions
Q1) When a tile displays a larger view of the program, it is in ________ mode.
Q2) A(n) ________ program is a small program designed to perform routine tasks.
Q3) There is a difference between Microsoft Windows and Microsoft Office.
A)True
B)False
Q4) A lightweight laptop computer is called a(n) ________.
A) ultrabook
B) desktop
C) server
D) monitor
Q5) Because computers are everywhere in society, it is important to have an understanding of how they work.
A)True
B)False
Q6) An intranet is a website that the public can access.
A)True
B)False
Q7) Desktop applications are programs that run on all mobile devices.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Create Workbooks With Excel 2013
Available Study Resources on Quizplus for this Chatper
114 Verified Questions
114 Flashcards
Source URL: https://quizplus.com/quiz/54006
Sample Questions
Q1) Pressing ________ makes A1 the active cell.
A) Home
B) Ctrl + Home
C) Ctrl + Left Arrow
D) Ctrl + Right Arrow
Q2) A formula in a worksheet begins with a(n) ________.
Q3) When a cell is part of an active function, it is ________.
A) surrounded by a solid border
B) highlighted
C) surrounded by a moving border
D) preceded by an Options button
Q4) If content exists in cell B1, and a long text value is entered into cell A1, the A1 display is ________.
A) wrapped
B) truncated
C) hidden
D) deleted
Q5) In a worksheet the intersection of a column and row is a(n) ________.
Q6) If the Tab key is pressed when B7 is the active cell, ________ will become the active cell.
Page 9
To view all questions and flashcards with answers, click on the resource link above.
Chapter 8: Insert Summary Functions and Create Charts
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/54007
Sample Questions
Q1) The ________, the line that borders the chart plot border area, is used as a frame of reference for measurement.
A) chart border
B) gridline
C) category border
D) axis
Q2) A ________ is a prebuilt chart format that applies an overall visual look to a chart.
A) chart layout
B) chart style
C) chart design
D) chart template
Q3) A(n) ________ chart is a chart that is displayed with its source data.
Q4) SUM and AVERAGE are the only functions listed in the options displayed by the AutoSum arrow.
A)True
B)False
Q5) A green triangle in the upper left corner of a cell is a(n) ________.
Q6) A function argument is the cell range that appears in ________.
Q7) In the Move Chart dialog box, the default name for a new worksheet is ________.
Page 10
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Manage Multiple Worksheets
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/54008
Sample Questions
Q1) A worksheet inserted into a workbook using the New Sheet button is inserted
A) at the beginning of the Tab group
B) in the middle of the Tab group
C) at the end of the Tab group
D) in the location designated by the user in the dialog box that appears
Q2) When it is not clear which chart type is best for the selected data, select ________ from the Charts group on the Insert tab.
Q3) The ________ is the destination for cut or copied data.
Q4) When the date is selected as the Number Category in the Format Cells dialog box, the Sample is actually the preview of the date in the active cell displayed as the option selected.
A)True
B)False
Q5) The usual positions for a chart legend are top, bottom, right, and left.
A)True
B)False
Q6) There are several ways to delete cell content.
A)True
B)False
Page 11
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: More Functions and Excel Tables
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/54009
Sample Questions
Q1) The Unfreeze Panes option appears when the ________ button is clicked.
A) New Window
B) Freeze Panes
C) Arrange All
D) Full Screen
Q2) Converting a range of cells in a worksheet to an Excel table is done primarily to have a larger selection of styles.
A)True
B)False
Q3) What is applied to a cell when the value of the cell meets a specified condition?
A) Logical formatting
B) Conditional formatting
C) Criteria formatting
D) Provisional formatting
Q4) Arguments in a function are separated by a(n) ________.
A) colon
B) comma
C) semi-colon
D) exclamation point
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 11: Browse With Internet Explorer
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/54010
Sample Questions
Q1) Large websites can consist of thousands of individual pages.
A)True
B)False
Q2) A Uniform Resource Locator is a unique address of a page on the Internet.
A)True
B)False
Q3) When you have multiple tabs open, you can rearrange the tabs in the tab row by dragging them.
A)True
B)False
Q4) A web archive has the ________ file extension.
Q5) App commands display in the ________ of an application window.
A) bottom
B) top
C) corner
D) middle
Q6) As you browse the web, Internet Explorer does NOT store copies of visited websites.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 12: Getting Started With Powerpoint 2013
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/54011
Sample Questions
Q1) If you have a conservative audience, it is best to select transitions from the Dynamic Content group.
A)True
B)False
Q2) A set of characters with the same design and shape is a(n) ________.
Q3) Slide Sorter view can be used to reorganize a presentation.
A)True
B)False
Q4) The ________ displays when you start PowerPoint 2013.
Q5) PowerPoint does NOT give you an option to add words to the dictionary.
A)True
B)False
Q6) Users can add headers to slides but NOT to handouts.
A)True
B)False
Q7) Which of the following is NOT displayed on the status bar?
A) Comments button
B) Fit slide to current window button
C) Link to open other presentations
D) Zoom level
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 13: Format a Presentation
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/54012
Sample Questions
Q1) Background graphics can be hidden.
A)True
B)False
Q2) When you change theme variants, it must affect all slides in the presentation.
A)True
B)False
Q3) Keyboard shortcut for Cut
Q4) If you already have a blank presentation started and want to view a list of available templates, click ________.
A) File, Share
B) File, Open
C) File, New
D) File, Import
Q5) You add a picture to the slide background under ________ in the Format Background pane.
Q6) Gradient Fill - Dark Green, Accent 1, Reflection is an example of a WordArt style.
A)True
B)False
Q7) The ________ pane is used to modify slide backgrounds.
Page 15
To view all questions and flashcards with answers, click on the resource link above.
Chapter 14: Enhance Presentations With Graphics
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/54013
Sample Questions
Q1) Click the ________ button in the SmartArt Styles group on the SmartArt Design tab to display the Color gallery.
Q2) ________ effects are a combination of other effects.
Q3) ________ can be converted into a SmartArt graphic.
Q4) Insert text boxes
A)Format tab, Video Styles
B)Layout tab, Format Video
C)Home tab, Insert Shapes
D)Design tab, Boxes
E)Insert tab, Text Box
F)Insert tab, Online Pictures
G)Format tab, Insert Pictures
H)Format tab, Picture Effects
I)Insert tab, Add Effects
J)Insert tab, Shapes
Q5) When a text box is inserted, it does not include ________ colors.
Q6) Video formatting and editing tools display on the Ribbon.
A)True
B)False
Q7) The Reuse Slides ________ displays after clicking Reuse Slides.
To view all questions and flashcards with answers, click on the resource link above. Page 16
Chapter 15: Present Data Using Tables, Charts, and Animation
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/54014
Sample Questions
Q1) The Select Row pointer is a(n) ________.
A) arrow pointing left
B) series of dots
C) arrow pointing right
D) single circles
Q2) The height and width of an entire table can be modified.
A)True
B)False
Q3) Chart placeholders are consistent regardless of the chart layout selected.
A)True
B)False
Q4) The column headings displayed in the Excel worksheet used to create a chart in PowerPoint will display in the ________ of the resulting chart.
A) category labels
B) legend
C) data series
D) value labels
Q5) There are no effects available that can be applied to tables. A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 17
Chapter 16: Getting Started With Windows 8
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/54015
Sample Questions
Q1) Ribbons contain commands placed in groups that are organized by ________.
Q2) The lock screen appears when you boot your PC or when it is sleeping.
A)True
B)False
Q3) Buttons accessed from the right edge of the screen
A)Commands
B)Records
C)Icons
D)Fields
E)Folders
F)Files
G)Apps
H)Screen shots
I)Badges
J)Charms
Q4) The type of snip that captures your entire screen is a ________ snip.
A) Free-form
B) Rectangular
C) Window
D) Full-screen
To view all questions and flashcards with answers, click on the resource link above. Page 18
Chapter 17: Create Letters and Memos
Available Study Resources on Quizplus for this Chatper
114 Verified Questions
114 Flashcards
Source URL: https://quizplus.com/quiz/54016
Sample Questions
Q1) Selecting text
A)Mini toolbar appears
B)Dialog box appears
C)Formatting marks appear
D)Paste Options button appears
E)Shortcut menu appears
Q2) One inch equals ________ points.
A) 25
B) 47
C) 72
D) 100
Q3) When a word is selected with a double-click and deleted, both the word and the space after it are deleted.
A)True
B)False
Q4) A zoom level of 52% usually displays ________ page(s).
A) one
B) two
C) three
D) four
To view all questions and flashcards with answers, click on the resource link above. Page 19
Chapter 18: Create Business Reports
Available Study Resources on Quizplus for this Chatper
114 Verified Questions
114 Flashcards
Source URL: https://quizplus.com/quiz/54017
Sample Questions
Q1) In a report, a list is typically indented 0.5 inch on the left and a hanging indent of ________ is set for the first line.
A) 0.25 inch
B) 0.5 inch
C) 0.75 inch
D) 1 inch
Q2) Orphan
A)Spacing above and below a paragraph
B)Spacing between text and top, bottom, right, and left edges of paper
C)Last line of paragraph displayed as first line of a page
D)Distance between text lines in a paragraph
E)First line of a paragraph displayed as last line of a page
Q3) A(n) ________ is used to put in order a series of steps, a sequence of actions, or chronology.
Q4) Indent
A)The position of first line of paragraph relative to left edge of rest of paragraph
B)Position of paragraph lines relative to page margins
C)First line of a paragraph extends to left of rest of paragraph
D)Keeping a heading and at least two lines of text that follows on same page
To view all questions and flashcards with answers, click on the resource link above. Page 20
Chapter 19: Create Flyers
Available Study Resources on Quizplus for this Chatper
107 Verified Questions
107 Flashcards
Source URL: https://quizplus.com/quiz/54018
Sample Questions
Q1) The Table Style gallery is on the Table Tools contextual ________ tab.
A) Design
B) Page Layout
C) Layout
D) View
Q2) Square
A)Line that is displayed when an object is aligned with a document object such as a margin or heading
B)Layout option that sets an image to float so it can be moved independent of its associated paragraph
C)Button that displays to the right of a selected image and provides text-wrapping settings
D)Symbol to the left of a paragraph indicating that the paragraph is associated with a picture
E)Movement of an object by small increments
Q3) Text in a table is usually aligned ________.
Q4) Single-clicking a marker for a tab stop on the horizontal ruler opens the Tabs dialog box.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 21
Chapter 20: Create Newsletters and Mail Merge Documents
Available Study Resources on Quizplus for this Chatper
106 Verified Questions
106 Flashcards
Source URL: https://quizplus.com/quiz/54019
Sample Questions
Q1) Serif
A)Document section that can be formatted differently from rest of document
B)Extra details or hooks at the end of each stroke in a character
C)Font in which characters lack extra details or hooks at the end of each stroke
D)A mark indicating the end of one section and the beginning of another
E)Aligns text with left margin and right margin
Q2) The styles that appear as thumbnails in any Ribbon gallery are ________.
Q3) Data source
A)Document section that can be formatted differently from rest of document
B)Extra details or hooks at the end of each stroke in a character
C)Font in which characters lack extra details or hooks at the end of each stroke
D)A mark indicating the end of one section and the beginning of another
E)Aligns text with left margin and right margin
Q4) When column setting are being adjusted, the insertion point needs to be positioned only in the section to which Column Layout has been applied.
A)True
B)False
Q5) Themes applied to text formatted in columns CANNOT be modified.
A)True
B)False
Page 22
To view all questions and flashcards with answers, click on the resource link above.