Chapter 7 Flashcards
A Word document often contains data stored in a(n) ____ that can then be copied and pasted into an Excel worksheet.
table
A ____ file contains data fields separated by a selected character.
delimited
A ____ is a way to qualify the data to import by specifying a matching condition or asking a question of a database.
query
A screen ____ is a portion, usually of one object or section of a window, of the screen.
clipping
A(n) ____ contains little or no formatting.
text file
A(n) ____ is a special-purpose workbook you can create and then use as a pattern to create new, similar workbooks or worksheets.
template
All of the following are formats accepted for picture files EXCEPT ____.
.mp3
Because ____ help speed and simplify work, many Excel users create one for each project on which they work.
templates
Elements in a SmartArt graphic are grouped in ____.
levels
Excel allows you to take a ____ of any open window and add it to a workbook.
screen shot
For a file that does not yet have a file name, you can open the Save As dialog box to save a template by pressing the ____ keys.
CTRL+S
In some cases, when you import data, the data will need to be ____, meaning that the rows and columns need to be switched.
transposed
Only images that are ____ are free for anyone to use without permission.
in the public domain
Tapping or clicking the ____ button changes a SmartArt graphic to individual shapes that can be resized, moved, or deleted independently of the others.
Convert to Shapes
The ____ provides step-by-step instructions for importing data from a text file into an Excel worksheet.
Text Import Wizard
To create an exact copy of a formula without replication, hold down the ____ key while dragging the fill handle.
CTRL
To rotate pictures in Excel, select the image to be rotated, then tap or click the ____ button (PICTURE TOOLS FORMAT tab | Arrange group).
Rotate Objects
Webpages use a file format called ____.
HTML
When Excel imports a database table, the data is placed in an Excel ____.
table
Which of the following is NOT a SmartArt graphic category?
Microsoft.com
Which of the following is a SmartArt graphic category?
Process
Which of the following is the path to the ‘Get Data From Text’ button?
(Data tab | Get External Data Group)
Which of the following is the path to the ‘Insert a SmartArt Graphic’ button?
(INSERT tab | Illustrations group)
Which of the following is the path to the ‘Take a Screenshot’ button?
(INSERT tab | Illustrations group)
Which of the following is the path to the Find & Select button?
(HOME tab | Editing group)
Which of the following is the path to the Format Painter button?
(HOME tab | Clipboard group)
Which of the following is the path to the Get Data From Web button?
(DATA tab | Get External Data group)
Which of the following is the path to the Insert WordArt button?
(INSERT tab | Text group)
Which of the following is the path to the Refresh All button?
(DATA tab | Connections group)
Which of the following is the path to the Text to Columns button?
(DATA tab | Data Tools group)
You can access the Find and Replace feature by pressing the ____ key(s).
CTRL+H
You can add text to a SmartArt graphic by using the ____.
Text Pane
You can select any range of cells with entries surrounded by blank cells by tapping or clicking a cell in the range and then pressing ____.
CTRL+SHIFT+ASTERISK
____ a shape within a SmartArt graphic means moving it to a higher level.
Promoting
____ a shape within a SmartArt graphic means moving it to a lower level.
Demoting
___ can describe any type of data.
XML
