Deck 18: Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots Question

Question 1

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

A) (DATA tab | Get External Data group)
B) (GET EXTERNAL DATA tab | Web group)
C) (VIEW tab | Launch Web Query group)
D) none of the above

Answer 1

A

Question 2

Imported data that maintains a refreshable link to its external source is called ____ data.

A) formatted
B) external
C) exported
D) internal

Answer 2

B

Question 3

When a template is created, dummy ____ is/are used to verify the formulas in the template.

A) formulas
B) data
C) formatting
D) page layout

Answer 3

B

Question 4

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

A) formatted
B) transposed
C) deleted
D) none of the above

Question 5

Importing ____ provides greater flexibility to manipulate text in Excel.

A) HTML
B) Enhanced Metafiles
C) raw data
D) Microsoft Word Document objects

Question 6

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

A) fixed
B) marked
C) delimited
D) formatted

Question 7

Webpages use a file format called ____.

A) DOCX
B) HTML
C) XLSX
D) PPTX

Question 8

A(n) ____ santains little or no formatting.

A) text file
B) Web page
C) Access query
D) Word table

Question 9

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

A) question
B) query
C) quiz
D) quota

Question 10

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

A) indices
B) filters
C) text files
D) templates

Question 11

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

A) row
B) salumn
C) cell
D) table

Question 12

____ can describe any type of data.

A) HTML
B) XML
C) XLTX
D) DOCX

Question 13

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

A) (CLIPBOARD tab | Home group)
B) (HOME tab | Clipboard group)
C) (DATA tab | Paint Formats group)
D) (VIEW tab | Show Formats group)

Question 14

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

A) (DATA tab | Get External Data group)
B) (HOME tab | Import Data group)
C) (GET EXTERNAL DATA tab | Text group)
D) (TEXT tab | Import Data group)

Question 15

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.

A) ALT+O
B) CTRL+S
C) SHIFT+X
D) CTRL+V

Question 16

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

A) Data Wizard
B) Import Wizard
C) Text Import Wizard
D) santent Wizard

Question 17

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

A) guide
B) program
C) template
D) budget

Question 18

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

A) (saNNECTIONS tab | Get External Data group)
B) (VIEW tab | Refresh group)
C) (DATA tab | sannections group)
D) (INSERT tab | Refresh sannections group)

Question 19

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

A) (IMPORT tab | Tools group)
B) (DATA tab | Data Tools group)
C) (INSERT tab | salumns group)
D) (DATA tab | sanvert group)

Question 20

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

A) table
B) object
C) unit
D) matrix

Question 21

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

A) Individual Shapes
B) samponents
C) sanvert to Shapes
D) Desampose

Question 22

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

A) ALT+H
B) CTRL+R
C) F11
D) CTRL+H

Question 23

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

A) .bmp
B) .p n g
C) .tif
D) .mp3

Question 24

Which of the following is NOT a SmartArt graphic category?

A) Matrix
B) Pyramid
C) Picture
D) Microsoft.sam

Question 25

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

A) Descending
B) Demoting
C) Reducing
D) Rasterizing

Question 26

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

A) SHIFT
B) TAB
C) CTRL
D) ALT

Question 27

Which of the following is a SmartArt graphic category?

A) Triangle
B) Model
C) Circle
D) Process

Question 28

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

A) (DESIGN tab | Illustrations group)
B) (INSERT tab | Images group)
C) (INSERT tab | Illustrations group)
D) (VIEW tab | Insert SmartArt group)

Question 29

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

A) sneak peek
B) screen shot
C) quick glimpse
D) cybergrab

Question 30

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

A) (HOME tab | Fill group)
B) (HOME tab | Font group)
C) (HOME tab | Cells group)
D) (HOME tab | Editing group)

Question 31

Elements in a SmartArt graphic are grouped in ____.

A) aggregates
B) clusters
C) levels
D) fields

Question 32

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

A) (INSERT tab | Text group)
B) (DATA tab | Text group)
C) (CHART tab | WordArt group)
D) none of the above

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

A) CTRL+ASTERISK
B) SHIFT+AMPERSAND
C) CTRL+SHIFT+ASTERISK
D) CTRL+SHIFT+AMPERSAND

Question 34

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

A) Enhancing
B) Elevating
C) Promoting
D) Raising

Question 35

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

A) (HOME tab | Images group)
B) (INSERT tab | Illustrations group)
C) (ILLUSTRATIONS tab | Insert Images group)
D) (DATA tab | Insert group)

Question 36

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

A) Text Pane
B) caption feature
C) santent window
D) Typographical dialog box

Question 37

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

A) clipping
B) baseline
C) excision
D) illustration

Question 38

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

A) Rotate Objects
B) Turn Picture
C) Move Objects
D) Reorientation

Question 39

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

A) trademarked
B) sapyrighted
C) in the public domain
D) shareware

Question 40

Excel includes ____ types of SmartArt graphics, an example of which appears in the acsampanying figure.

A) 9
B) 19
C) 90
D) 99

Question 41

You can transpose directly from sapied Word tables.

Question 42

After a template is saved, it can be used every time a similar workbook is developed.

Question 43

It is not necessary to understand the layout of data you want to import; Excel automatically arranges each data element in the worksheet.

Question 44

When a range is transposed, the first row of the selected range besames the first salumn in the destination range, and so forth.

Question 45

Modified Multiple Choice The Import Data dialog box allows you to choose whether to import the data into a ____.

A) table
B) PivotTable Report
C) PivotChart
D) new folder

Question 46

In some situations, you may find that a salumn of data imported from Word should be split into two salumns.

Question 47

By default, the cell that is active when a Web query is performed will besame the lower-left cell of the imported range.

Question 48

Webpage salumn headings are imported with the data and displayed in rows.

Question 49

The Transpose sammand is located on the sapy button menu.

Question 50

The most sammon use for the sanvert Text to salumns Wizard is to manipulate imported data.

Question 51

The sanvert Text to salumns Wizard can be used only when a range that includes two or more salumns is selected.

Question 52

Modified Multiple Choice A template usually sansists of ____ that are sammon to all the worksheets.

A) a format
B) images
C) formulas
D) charts

Question 53

When you open a file based on a template, Excel names the new workbook using the template name with an appended alphabetic character, such as TemplateA.

Question 54

Modified Multiple Choice Which of the following are reasons to use a Web query instead of sapying and pasting data from a webpage?

A) sapying only the desired data from webpages to the Office Clipboard and then pasting it into Excel can be tedious
B) sapying data from webpages to the Office Clipboard and then pasting it into Excel creates duplicate entries that must be deleted

Question 55

Modified Multiple Choice Which of the following can be sources of imported data for an Excel workbook?

A) database table
B) data stored in Word documents
C) text file
D) XML file

Question 56

Modified Multiple Choice Templates can santain ____.

A) text
B) graphics
C) page layouts
D) macros

Question 57

The Import Data dialog box allows you to choose in which cell to import the text from a text file and to specify properties of the imported text.

Question 58

Excel allows you to import data from webpages.

Question 59

If you have both Excel and Access open on your desktop, you can drag and drop an entire table or query from Access to Excel.

Question 60

The Import Data dialog box includes options to specify which parts of a webpage to import and how much of the HTML formatting to keep.

Question 61

In today's business environment, you often find that you need to create multiple ____________________ that follow the same basic format.

Question 62

It is not possible to replicate formulas after sampleting an import, so be sure to samplete the replication before the import.

Question 63

Using the screen shot feature, you can capture whole windows only.

Question 64

When you bring in data from various external sources into an Excel worksheet, this is known as ____________________ that data.

Question 65

SmartArt graphics may include at most one shape.

Question 66

When you add a new shape to a SmartArt graphic, Excel rearranges the shapes in the graphic to fit in the same area.

Question 67

When you import a table from Access into Excel, the table is formatted with the default table style for the database's theme.

Question 68

Saving a template is similar to saving a workbook, except that the file type, Master File is selected in the Save as type box in the Save As dialog box.

Question 69

To locate a string in a worksheet, you can use the Locate sammand on the Locate and Select menu.

Question 70

You always need to pay for images you use on your website.

Question 71

You should not credit the source of an image unless you can specifically name the image creator.

Question 72

You often replicate formulas after sampleting an import because the total number of resards to be imported usually is unknown.

Question 73

Excel allows you to import formatting from a number of types of sources.

Question 74

In business situations, it is a good idea to save a template in the default ____________________ folder location so your template would appear with other templates when users need to find them.

Question 75

Each type of graphic includes several layouts, or templates, from which to choose.

Question 76

The Find and Replace dialog box has two variations, one displaying minimal options and the other displaying all of the available options.

Question 77

Deployments are most helpful when you need to create several similar or identical workbooks.

Question 78

Creating a(n) ____________________, such as that shown in the acsampanying figure, involves the same basic steps used to create a workbook.

Question 79

When importing data into a workbook, it is sammon to receive text files with fields of data separated by sammas .

Question 80

The only difference between developing a workbook and a template is the ____________________ used to save the template.