Deck 13: Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Question 1

When using Microsoft Office, the default location for saving files is ________.

A)DropBox
B)OneDrive
C)Google Drive
D)iCloud

Answer 1

B

Question 2

The object shown in the figure above is a ________.

A)gallery
B)contextual tab
C)shortcut menu
D)Quick Access Toolbar

Answer 2

C

Question 3

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

Answer 3

A

Question 4

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

Question 5

Which of the following applications is not included with Microsoft Office?

A)Photoshop
B)Word
C)Excel
D)Access

Question 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

Question 7

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

Question 8

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

Question 9

The figure shown above shows examples of ________.

A)themes
B)templates
C)styles
D)tabs

Question 10

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

Question 11

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)OneDrive

Question 12

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

Question 13

The figure shown above shows the ________ gallery.

A)Themes
B)Templates
C)Styles
D)Views

Question 14

A ________ is a subset of a tab and is used to organize similar tasks together.

A)group
B)header
C)template
D)gallery

Question 15

Clicking a Dialog Box ________ button on the Ribbon opens a corresponding dialog box.

A)Group
B)Header
C)Tab
D)Launcher

Question 16

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

Question 17

You would apply a ________, which is a collection of design choices that includes colors, fonts, and special effects used to give a consistent look to your work.

A)template
B)theme
C)view
D)gallery

Question 18

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

Question 19

The ________ is the command center of Office application containing tabs, groups, and commands.

A)title bar
B)mini toolbar
C)Ribbon
D)status bar

Question 20

A ________ contains groups of commands related to the selected object.

A)Ribbon
B)contextual tab
C)status bar
D)title bar

Question 21

Clicking the icon shown in the figure above, activates the________ feature.

A)Live Preview
B)Clipboard
C)OneDrive
D)Format Painter

Question 22

A grammatical error is underlined with a ________ wavy line.

A)green
B)yellow
C)orange
D)red

Question 23

Microsoft Office ________ is an application that is used to store quantitative data and to perform accurate and rapid calculations.

Question 24

A ________ consists of one or more lines at the bottom of each page.

A)header
B)endnote
C)footnote
D)footer

Question 25

The object depicted in the figure above, is the ________.

A)Quick Access Toolbar
B)Ribbon
C)status bar
D)title bar

Question 26

A grammatical error is underlined with a(n)________ wavy line.

Question 27

Microsoft's cloud storage is called ________ .

Question 28

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

Question 29

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

Question 30

________ 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

Question 31

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

Question 32

In the figure shown above, the circle pointed to by the red line is a ________ handle.

A)coloring
B)cropping
C)sizing
D)rotating

Question 33

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

Question 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

Question 35

The figure shown above shows the ________.

A)Quick Access Toolbar
B)Mini toolbar
C)Ribbon
D)Clipboard

Question 36

A potential misspelled word is underlined with a ________ wavy line.

A)yellow
B)green
C)blue
D)red

Question 37

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

Question 38

________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

Question 39

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

Question 40

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

Question 41

When you ________ a selection, the selection is duplicated and the duplicate is placed in the Clipboard.

Question 42

A word usage error is underlined with a(n)________ wavy line.

Question 43

Using the ________ gives you access to the most common formatting selections, such as adding bold or italic, or changing font type or color.

Question 44

A(n)________ is a custom program or additional command that you can install to extend the functionality of a Microsoft Office program.

Question 45

A(n)________ displays choices related to the selection or area at which you right-click.

Question 46

When you ________ a selection, the selection is removed from the original location and is placed in the Clipboard.

Question 47

A(n)________ is a predesigned file that integrates formatting elements, such as a theme and layouts.

Question 48

The ________ keyboard shortcut duplicates a selection from the original location and places it in the Clipboard.

Question 49

A(n)________ is a button or area within a group that you click to perform a task.

Question 50

A(n)________ command is a button that acts somewhat like light switch that can be turned on and off.

Question 51

The ________ provides fast access to commonly executed tasks such as saving a file and undoing recent actions.

Question 52

A(n)________ is digital photo, defined as a graphic element that can be retrieved from storage media.

Question 53

You would use the ________ to temporarily hold selections that you have cut or copied.

Question 54

A(n)________ is a collection of design choices that includes colors, fonts, and special effects used to give a consistent look to a your work.

Question 55

The mouse shortcut for selecting a word is to ________ the word.

Question 56

You can use the ________ to quickly and easily copy all formatting from one area to another.

Question 57

The object pointed to by the red line in the figure above, is the ________.

Question 58

The object shown in the figure above is the font ________.

Question 59

When you ________ a selection, the selection in the Clipboard is placed into another location.

Question 60

The ________ Preview displays a preview of the results of a selection.

Question 61

You can customize the Ribbon.

Question 62

A template is a collection of design choices that includes colors, fonts, and special effects used to give a consistent look to your work.

Question 63

Word checks your spelling and grammar as you type.

Question 64

Microsoft Office's Ask me anything box enables you to search for help and information about a command or task

Question 65

You can customize the Quick Access Tool bar.

Question 66

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.

Question 67

The ________ is used to increase or decrease the size of the document onscreen.

Question 68

When you paste a selection, it is removed from its original location and placed it in the Clipboard.

Question 69

The status bar identifies the current file name and the application in which you are working.

Question 70

A theme is a predesigned file that incorporates formatting elements, such as layouts and may include content that can be modified.

Question 71

You can use Excel to organize records, financial transactions, and business information in the form of worksheets.

Question 72

The Mini toolbar provides access to the most common formatting selections.

Question 73

The object shown in the figure above is a gallery.

Question 74

A(n)________ consists of one or more lines at the top of each page.

Question 75

The Quick Access Tool bar gives you one-click access to commonly executed tasks such as saving a file or undoing recent actions.

Question 76

A tab is a button or area within a group that you click to perform a task.

Question 77

An add-in is a custom program or additional command that you can use to extend the functionality of a Microsoft Office program.

Question 78

Bold and Italic are examples of toggle command buttons.

Question 79

To select the entire document, you press Ctrl+E.

Question 80

The Mini toolbar is not customizable.