Office 365 Common Features Full Test Bank Ch.1 - Microsoft Access 2019 1e Complete Test Bank by Mary Anne Poatsy. DOCX document preview.
Exploring Microsoft Office 2019 Introductory (Poatsy/Grauer)
Chapter 1 Office 365 Common Features
1) Which of the following applications is not included with Microsoft Office?
A) Photoshop
B) Word
C) Excel
D) Access
Diff: 3
Objective: CF1.01 Start an Office Application
2) Which of the following Microsoft Office applications is used to produce documents, including memos, newsletters, forms, brochures?
A) Access
B) Excel
C) Word
D) Photoshop
Diff: 1
Objective: CF1.01 Start an Office Application
3) Which of the following Microsoft Office applications is used to create dynamic presentations to inform and persuade audiences?
A) Access
B) Word
C) PowerPoint
D) Photoshop
Diff: 1
Objective: CF1.01 Start an Office Application
4) Which of the following Microsoft Office applications is a relational database software application that is used to record and link data, query databases, and create forms and reports?
A) Access
B) Word
C) PowerPoint
D) Excel
Diff: 2
Objective: CF1.01 Start an Office Application
5) When using Microsoft Office, the default location for saving files is ________.
A) DropBox
B) OneDrive
C) Google Drive
D) iCloud
Diff: 3
Objective: CF1.01 Start an Office Application
6) The ________ identifies the current file name and the application in which you are working.
A) Title bar
B) Status bar
C) Quick Access Toolbar
D) ribbon
Diff: 2
Objective: CF1.03 Use Common Interface Components
7) The ________ is the command center of Office application containing tabs, groups, and commands.
A) title bar
B) mini toolbar
C) ribbon
D) status bar
Diff: 2
Objective: CF1.03 Use Common Interface Components
8) A ________ contains groups of commands related to the selected object.
A) ribbon
B) contextual tab
C) status bar
D) title bar
Diff: 2
Objective: CF1.03 Use Common Interface Components
9) A ________ is a subset of a tab and is used to organize similar tasks together.
A) group
B) header
C) template
D) gallery
Diff: 2
Objective: CF1.03 Use Common Interface Components
10) Clicking a Dialog Box ________ button on the ribbon opens a corresponding dialog box.
A) Group
B) Header
C) Tab
D) Launcher
Diff: 3
Objective: CF1.03 Use Common Interface Components
11) Depending on the application, a ________ is an area that provides additional text styles, choices of chart styles, or transitions.
A) command
B) gallery
C) tab
D) template
Diff: 2
Objective: CF1.03 Use Common Interface Components
12) Which of the following would not be found on the shortcut menu for a picture.
A) group objects
B) provide a caption
C) open the Thesaurus
D) wrap text
Diff: 2
Objective: CF1.03 Use Common Interface Components
13) Microsoft Office's ________ box enables you to search for help and information about a command or task.
A) Help
B) Ask me anything
C) What can I do for you
D) Tell me what you want to do
Diff: 2
Objective: CF1.04 Get Help
14) You can use ________ to find information about tasks or commands in Office or to search for general information on a topic.
A) Live Preview
B) Smart Lookup
C) Backstage view
D) the Thesaurus
Diff: 2
Objective: CF1.04 Get Help
15) A ________ is a small message box that displays when the pointer is placed over a command button.
A) contextual tab
B) dialog box
C) mini toolbar
D) Enhanced ScreenTip
Diff: 2
Objective: CF1.04 Get Help
16) A(n) ________ is a custom program or additional command that is installed to extend the functionality of a Microsoft Office program.
A) template
B) theme
C) add-in
D) gallery
Diff: 2
Objective: CF1.05 Install Add-Ins
17) You would apply a ________, which is a collection of design choices that includes colors, fonts, and special effects, to give a consistent look to your work.
A) template
B) theme
C) view
D) gallery
Diff: 2
Objective: CF1.06 Use Templates and Apply Themes
18) A(n) ________ is a predesigned file that incorporates formatting elements and may include content that can be modified.
A) template
B) add-in
C) view
D) gallery
Diff: 2
Objective: CF1.06 Use Templates and Apply Themes
19) Which of the following is not true about templates?
A) It incorporates formatting elements.
B) They slow down the process of creating presentations.
C) It incoprorates layout options.
D) It may include content that can be modified.
Diff: 1
Objective: CF1.06 Use Templates and Apply Themes
20)
The figure shown above shows the ________ gallery.
A) Themes
B) Templates
C) Styles
D) Views
Diff: 2
Objective: CF1.06 Use Templates and Apply Themes
21) When using Word, to select a paragraph, you ________.
A) triple-click in the paragraph
B) press and hold Ctrl and click in the paragraph
C) double-click the paragraph
D) press and hold Shift and press the left arrow
Diff: 3
Objective: CF1.07 Modify Text
22) ________ gives you access to the most common formatting selections, such as adding bold or italic, or changing font type or color.
A) An enhanced ScreenTip
B) A gallery
C) Live Preview
D) The Mini toolbar
Diff: 2
Objective: CF1.07 Modify Text
23)
The figure shown above shows the ________.
A) Quick Access Toolbar
B) Mini toolbar
C) ribbon
D) Clipboard
Diff: 2
Objective: CF1.07 Modify Text
24)
Clicking the icon shown in the figure above, activates the________ feature.
A) Live Preview
B) Clipboard
C) OneDrive
D) Format Painter
Diff: 1
Objective: CF1.07 Modify Text
25) Office's ________ is an area of memory reserved to temporarily hold selections that have been cut or copied.
A) gallery
B) Clipboard
C) contextual tab
D) ribbon
Diff: 2
Objective: CF1.08 Relocate Text
26) Which of the following keyboard shortcuts is used to paste the contents of the Clipboard?
A) Ctrl+P
B) Ctrl+C
C) Ctrl+V
D) Ctrl+X
Diff: 3
Objective: CF1.08 Relocate Text
27) Which of the following keyboard shortcut removes a selection from the original location and places it in the Clipboard?
A) Ctrl+A
B) Ctrl+C
C) Ctrl+V
D) Ctrl+X
Diff: 3
Objective: CF1.08 Relocate Text
28) Which of the following keyboard shortcut duplicates a selection from the original location and places it in the Clipboard?
A) Ctrl+A
B) Ctrl+C
C) Ctrl+V
D) Ctrl+X
Diff: 3
Objective: CF1.08 Relocate Text
29) The Ctrl+C keyboard shortcut ________.
A) duplicates a selection from the original location and places it in the Clipboard
B) removes a selection from the original location and places it in the Clipboard
C) places a cut or copied selection into another location
D) empties the Clipboard
Diff: 3
Objective: CF1.08 Relocate Text
30) A potential misspelled word is underlined with a ________ wavy line.
A) yellow
B) green
C) blue
D) red
Diff: 2
Objective: CF1.09 Review a Document
31) A grammatical error is underlined with a ________ wavy line.
A) green
B) yellow
C) orange
D) red
Diff: 2
Objective: CF1.09 Review a Document
32) When an image is selected, how many sizing handle are displayed?
A) 4
B) 6
C) 8
D) 10
Diff: 3
Objective: CF1.10 Work with Pictures
33) ________is an Office component that provides a series of commands related to the open file.
A) OneDrive
B) Live Preview
C) Format Painter
D) Backstage view
Diff: 2
Objective: CF1.14 Configure Document Properties
34) The ________ is located at the bottom of the program window, contains information relative to the open file and is specific to each application.
A) title bar
B) Dialog Box Launcher
C) status bar
D) Quick Access Toolbar
Diff: 2
Objective: CF1.11 Change Document Views
35)
The object depicted in the figure above, is the ________.
A) Quick Access Toolbar
B) ribbon
C) status bar
D) title bar
Diff: 2
Objective: CF1.11 Change Document Views
36) A(n) ________ is the area of blank space that displays to the left, right, top, and bottom of a document.
A) margin
B) indent
C) tab
D) border
Diff: 1
Objective: CF1.12 Change the Page Layout
37) A ________ consists of one or more lines at the bottom of each page.
A) header
B) endnote
C) footnote
D) footer
Diff: 1
Objective: CF1.13 Create a Header and Footer
38) You can use Excel to organize records, financial transactions, and business information in the form of worksheets.
Diff: 1
Objective: CF1.01 Start an Office Application
39) The status bar identifies the current file name and the application in which you are working.
Diff: 2
Objective: CF1.03 Use Common Interface Components
40) A tab is a button or area within a group that you click to perform a task.
Diff: 2
Objective: CF1.03 Use Common Interface Components
41) The Quick Access Toolbar gives you one-click access to commonly executed tasks such as saving a file or undoing recent actions.
Diff: 2
Objective: CF1.03 Use Common Interface Components
42) You can customize the Quick Access Toolbar.
Diff: 1
Objective: CF1.03 Use Common Interface Components
43) You can customize the ribbon.
Diff: 1
Objective: CF1.03 Use Common Interface Components
44)
The object shown in the figure above is a gallery.
Diff: 2
Objective: CF1.03 Use Common Interface Components
45) Microsoft Office's Ask me anything box enables you to search for help and information about a command or task.
Diff: 2
Objective: CF1.04 Get Help
46) An add-in is a custom program or additional command that you can use to extend the functionality of a Microsoft Office program.
Diff: 2
Objective: CF1.05 Install Add-Ins
47) A template is a collection of design choices that includes colors, fonts, and special effects used to give a consistent look to your work.
Diff: 2
Objective: CF1.06 Use Templates and Apply Themes
48) A theme is a predesigned file that incorporates formatting elements, such as layouts and may include content that can be modified.
Diff: 2
Objective: CF1.06 Use Templates and Apply Themes
49) To select the entire document, you press Ctrl+E.
Diff: 3
Objective: CF1.07 Modify Text
50) Bold and Italic are examples of toggle command buttons.
Diff: 2
Objective: CF1.07 Modify Text
51) The Mini toolbar provides access to the most common formatting selections.
Diff: 2
Objective: CF1.07 Modify Text
52) The Mini toolbar is not customizable.
Diff: 2
Objective: CF1.07 Modify Text
53) The Clipboard is an area of memory that is used to temporarily hold selections that you have cut or copied, and it allows you to paste the selections.
Diff: 1
Objective: CF1.08 Relocate Text
54) When you paste a selection, it is removed from its original location and placed it in the Clipboard.
Diff: 1
Objective: CF1.08 Relocate Text
55) Word checks your spelling and grammar as you type.
Diff: 1
Objective: CF1.09 Review a Document
56) PowerPoint checks your spelling and grammar as you type.
Diff: 2
Objective: CF1.09 Review a Document
57) Excel does not include a spelling checker.
Diff: 2
Objective: CF1.09 Review a Document
58) A grammatical error is underlined with a blue wavy line.
Diff: 2
Objective: CF1.09 Review a Document
59) If you used bear instead of bare, bear would be underlined with a red wavy line.
Diff: 1
Objective: CF1.09 Review a Document
60) Right-clicking a word or phrase that is identified as a mistake will display a shortcut menu that suggests the correct spelling.
Diff: 1
Objective: CF1.09 Review a Document
61) A picture that you download from the Internet does not require permission from the creator.
Diff: 2
Objective: CF1.10 Work with Pictures
62)
The figure shown above depicts Backstage view.
Diff: 1
Objective: CF1.02 Work with Files
63) The title bar contains information relative to the open file including tools for changing the view of the file and for changing the zoom size of onscreen file contents.
Diff: 2
Objective: CF1.11 Change Document Views
64) You can use the Zoom slider to increase or decrease the size of the document onscreen.
Diff: 1
Objective: CF1.11 Change Document Views
65) A footnote consists of one or more lines at the bottom of each page.
Diff: 1
Objective: CF1.13 Create a Header and Footer
66) A header consists of one or more lines at the top of each page.
Diff: 1
Objective: CF1.13 Create a Header and Footer
67) Microsoft Office ________ is an application that is used to store quantitative data and to perform accurate and rapid calculations.
Diff: 1
Objective: CF1.01 Start an Office Application
68) Microsoft's cloud storage is called ________ .
Diff: 2
Objective: CF1.01 Start an Office Application
69) A grammatical error is underlined with a(n) ________ wavy line.
Diff: 3
Objective: CF1.02 Work with Files
70) The ________ provides fast access to commonly executed tasks such as saving a file and undoing recent actions.
Diff: 2
Objective: CF1.03 Use Common Interface Components
71) A(n) ________ is a button or area within a group that you click to perform a task.
Diff: 2
Objective: CF1.03 Use Common Interface Components
72) The ________ Preview displays a preview of the results of a selection.
Diff: 1
Objective: CF1.03 Use Common Interface Components
73) A(n) ________ displays more precise or less frequently used commands.
Diff: 2
Objective: CF1.03 Use Common Interface Components
74)
The object shown in the figure above is the Font ________.
Diff: 2
Objective: CF1.03 Use Common Interface Components
75) A(n) ________ is a custom program or additional command that you can install to extend the functionality of a Microsoft Office program.
Diff: 3
Objective: CF1.05 Install Add-Ins
76) A(n) ________ is a collection of design choices that includes colors, fonts, and special effects used to give a consistent look to your work.
Diff: 2
Objective: CF1.06 Use Templates and Apply Themes
77) A(n) ________ is a predesigned file that integrates formatting elements, such as a theme and layouts.
Diff: 2
Objective: CF1.06 Use Templates and Apply Themes
78) The mouse shortcut for selecting a word is to ________ the word.
Diff: 3
Objective: CF1.07 Modify Text
79) A(n) ________ command is a button that acts somewhat like light switch that can be turned on and off.
Diff: 3
Objective: CF1.07 Modify Text
80) Using the ________ gives you access to the most common formatting selections, such as adding bold or italic, or changing font type or color.
Diff: 2
Objective: CF1.07 Modify Text
81) You can use the ________ to quickly and easily copy all formatting from one area to another.
Diff: 2
Objective: CF1.07 Modify Text
82) You would use the ________ to temporarily hold selections that you have cut or copied.
Diff: 2
Objective: CF1.08 Relocate Text
83) The ________ keyboard shortcut duplicates a selection from the original location and places it in the Clipboard.
Diff: 3
Objective: CF1.08 Relocate Text
84) When you ________ a selection, the selection is duplicated and the duplicate is placed in the Clipboard.
Diff: 1
Objective: CF1.08 Relocate Text
85) When you ________ a selection, the selection is removed from the original location and is placed in the Clipboard.
Diff: 1
Objective: CF1.08 Relocate Text
86) When you ________ a selection, the selection in the Clipboard is placed into another location.
Diff: 1
Objective: CF1.08 Relocate Text
87) A word usage error is underlined with a(n) ________ wavy line.
Diff: 3
Objective: CF1.09 Review a Document
88) A(n) ________ is digital photo, defined as a graphic element that can be retrieved from storage media.
Diff: 1
Objective: CF1.10 Work with Pictures
89)
The object pointed to by the red line in the figure above, is the ________.
Diff: 1
Objective: CF1.11 Change Document Views
90) The ________ is used to increase or decrease the size of the document onscreen.
Diff: 1
Objective: CF1.11 Change Document Views
91) A(n) ________ consists of one or more lines at the top of each page.
Diff: 1
Objective: CF1.13 Create a Header and Footer
92) Match each of the following terms to their meanings:
I. Cloud storage
II. OneDrive
III. Quick Access Toolbar
IV. Command
V. Group
A. Enables you to execute common tasks such as saving a file and undoing recent actions
B. Used to access files and to work with programs that are kept in a central location on the Internet
C. Button that you click to perform a task
D. Subset of a tab that organizes similar tasks together
E. App used to store, access, and share files and folders
Diff: 3
Objective: Multiple Objectives
93) Match each of the following terms to their meanings:
I. Shortcut menu
II. Smart Lookup
III. Enhanced ScreenTip
IV. Add-in
V. Backstage view
A. Small message box that displays when you place the pointer over a command button
B. Provides a concise collection of commands related to an open file
C. Provides choices related to the selection or area at which you right-click
D. Custom program or additional command that extends the functionality of an Office program
E. Provides information about Office tasks or commands
Diff: 3
Objective: Multiple Objectives
94) Match each of the following terms to their meanings:
I. Template
II. Theme
III. Toggle command
IV. Format Painter
V. Mini toolbar
A. Acts somewhat like light switch that you can turn on and off
B. Provides access to the most common formatting selections such as adding bold or italic
C. Predesigned file that incorporates formatting elements
D. Enables you to quickly and easily copy formatting from one area to another
E. Collection of design choices used to give a consistent look to your work
Diff: 3
Objective: Multiple Objectives
95) Match each of the following terms to their meanings:
I. Clipboard
II. Status bar
III. Zoom slider
IV. Margin
V. Tell me what you want to do box
A. Used to increase or decrease the size of the document onscreen
B. Used to search for help and information about a command or task
C. Area of memory reserved to temporarily hold selections that have been cut or copied
D. Area of blank space that displays on all sides of a document or worksheet
E. Located at the bottom of the program window and contains information relative to the open file
Diff: 3
Objective: Multiple Objectives
96) Match each of the following terms to their meanings:
I. Header
II. Footer
III. Picture
IV. Tab
V. View
A. One or more lines at the top of each page
B. Various ways a file can appear on the screen
C. Digital photo, defined as a graphic element retrieved from storage media
D. Designed to appear much like a top extension on a file folder
E. One or more lines at the bottom of each page
Diff: 3
Objective: Multiple Objectives
97) Match each of the following terms to their meanings:
I. Cut
II. Copy
III. Paste
IV. Portrait orientation
V. Landscape orientation
A. Duplicates a selection from the original location and places a copy in the Office Clipboard
B. Removes a selection from the original location and places it in the Clipboard
C. Page that is wider than it is tall
D. Page that is taller than it is wide
E. Places a selection in the Clipboard into another location
Diff: 3
Objective: Multiple Objectives
98) Match each of the following Office products to their software types:
I. Access
II. Excel
III. PowerPoint
IV. Word
A. Word processing software
B. Spreadsheet software
C. Relation database software
D. Presentation graphics software
Diff: 2
Objective: CF1.01 Start an Office Application
99) Match each of the following terms to their meanings:
I. Title bar
II. Ribbon
III. Contextual Tab
IV. Dialog box
V. Gallery
A. Contains a group of commands related to the selected object
B. Contains tabs, groups, and commands
C. Identifies the current file name and the application in which you are working
D. Provides access to more precise, but less frequently used, commands
E. Area that provides additional text styles, choices of chart styles, or transitions
Diff: 3
Objective: CF1.03 Use Common Interface Components
100) Match each of the following items to their shortcut selections:
I. One word
II. One line of text
III. One sentence
IV. One paragraph
V. Entire document
A. Press and hold Ctrl and click in the item to select it
B. Press Ctrl+A
C. Double-click the item
D. Triple-click in the item
E. Place the pointer at the left of the item in the margin area and click
Diff: 3
Objective: CF1.07 Modify Text