Chapter 7

Question 1

A Word document often contains data stored in a(n) ____ that can then be copied and pasted into an Excel worksheet.

Answer 1

table

Question 2

A ____ file contains data fields separated by a selected character.

Answer 2

delimited

Question 3

A ____ is a way to qualify the data to import by specifying a matching condition or asking a question of a database.

Answer 3

query

Question 4

A screen ____ is a portion, usually of one object or section of a window, of the screen.

Answer 4

clipping

Question 5

A(n) ____ contains little or no formatting.

Answer 5

text file

Question 6

A(n) ____ is a special-purpose workbook you can create and then use as a pattern to create new, similar workbooks or worksheets.

Answer 6

template

Question 7

All of the following are formats accepted for picture files EXCEPT ____.

Answer 7

.mp3

Question 8

Because ____ help speed and simplify work, many Excel users create one for each project on which they work.

Answer 8

templates

Question 9

Elements in a SmartArt graphic are grouped in ____.

Answer 9

levels

Question 10

Excel allows you to take a ____ of any open window and add it to a workbook.

Answer 10

screen shot

Question 11

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.

Answer 11

CTRL+S

Question 12

In some cases, when you import data, the data will need to be ____, meaning that the rows and columns need to be switched.

Answer 12

transposed

Question 13

Only images that are ____ are free for anyone to use without permission.

Answer 13

in the public domain

Question 14

Tapping or clicking the ____ button changes a SmartArt graphic to individual shapes that can be resized, moved, or deleted independently of the others.

Answer 14

Convert to Shapes

Question 15

The ____ provides step-by-step instructions for importing data from a text file into an Excel worksheet.

Answer 15

Text Import Wizard

Question 16

To create an exact copy of a formula without replication, hold down the ____ key while dragging the fill handle.

Answer 16

CTRL

Question 17

To rotate pictures in Excel, select the image to be rotated, then tap or click the ____ button (PICTURE TOOLS FORMAT tab | Arrange group).

Answer 17

Rotate Objects

Question 18

Webpages use a file format called ____.

Answer 18

HTML

Question 19

When Excel imports a database table, the data is placed in an Excel ____.

Answer 19

table

Question 20

Which of the following is NOT a SmartArt graphic category?

Answer 20

Microsoft.com

Question 21

Which of the following is a SmartArt graphic category?

Answer 21

Process

Question 22

Which of the following is the path to the ‘Get Data From Text’ button?

Answer 22

(Data tab | Get External Data Group)

Question 23

Which of the following is the path to the ‘Insert a SmartArt Graphic’ button?

Answer 23

(INSERT tab | Illustrations group)

Question 24

Which of the following is the path to the ‘Take a Screenshot’ button?

Answer 24

(INSERT tab | Illustrations group)

Question 25

Which of the following is the path to the Find & Select button?

Answer 25

(HOME tab | Editing group)

Question 26

Which of the following is the path to the Format Painter button?

Answer 26

(HOME tab | Clipboard group)

Question 27

Which of the following is the path to the Get Data From Web button?

Answer 27

(DATA tab | Get External Data group)

Question 28

Which of the following is the path to the Insert WordArt button?

Answer 28

(INSERT tab | Text group)

Question 29

Which of the following is the path to the Refresh All button?

Answer 29

(DATA tab | Connections group)

Question 30

Which of the following is the path to the Text to Columns button?

Answer 30

(DATA tab | Data Tools group)

Question 31

You can access the Find and Replace feature by pressing the ____ key(s).

Answer 31

CTRL+H

Question 32

You can add text to a SmartArt graphic by using the ____.

Answer 32

Text Pane

Question 33

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 ____.

Answer 33

CTRL+SHIFT+ASTERISK

Question 34

____ a shape within a SmartArt graphic means moving it to a higher level.

Answer 34

Promoting

Question 35

____ a shape within a SmartArt graphic means moving it to a lower level.

Answer 35

Demoting

Question 36

___ can describe any type of data.

Answer 36

XML