Deck 7: Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

Question 1

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

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

Answer 1

A

Question 2

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

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

Answer 2

D

Question 3

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)

Answer 3

B

Question 4

A(n)____ contains little or no formatting.

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

Question 5

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

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

Question 6

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

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

Question 7

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 8

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

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

Question 9

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

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

Question 10

Importing ____ provides greater flexibility to manipulate text in Excel.

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

Question 11

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 12

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

Question 13

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

Question 14

____ can describe any type of data.

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

Question 15

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) Content Wizard

Question 16

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 17

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 18

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 19

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

A) (IMPORT tab | Tools group)
B) (DATA tab | Data Tools group)
C) (INSERT tab | Columns group)
D) (DATA tab | Convert group)

Question 20

Webpages use a file format called ____.

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

Question 21

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 22

Which of the following are reasons to use a Web query instead of copying and pasting data from a webpage?

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

Question 23

Which of the following is a SmartArt graphic category?

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

Question 24

Excel includes ____ types of SmartArt graphics.

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

Question 25

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 26

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 27

You can select any range of cells with entries surrounded by blank cells by clicking a cell in the range and then pressing ____.

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

Question 28

Elements in a SmartArt graphic are grouped in ____.

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

Question 29

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

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

Question 30

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 31

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 32

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) Components
C) Convert to Shapes
D) Decompose

Question 33

A template usually consists of ____ that are common to all the worksheets.

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

Question 34

Which of the following is NOT a SmartArt graphic category?

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

Question 35

Excel allows you to import data from webpages.

Question 36

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 37

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 38

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 39

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

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

Question 40

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

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

Question 41

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 42

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

Question 43

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

Question 44

You can transpose directly from copied Word tables.

Question 45

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

Question 46

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

Question 47

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

Question 48

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

Question 49

SmartArt graphics may include at most one shape.

Question 50

The Convert Text to Columns Wizard can be used only when a range that includes two or more columns is selected.

Question 51

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

Question 52

The Transpose command is located on the Copy button menu.

Question 53

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

Question 54

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

Question 55

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

Question 56

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 57

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

Question 58

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

Question 59

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

Question 60

The most common use for the Convert Text to Columns Wizard is to manipulate imported data.

Question 61

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

Question 62

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

Question 63

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

Question 64

When importing data into a workbook,it is common to receive text files with fields of data separated by commas._________________________

Question 65

​HTML stands for Hypertext Markup Language.

Question 66

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

Question 67

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

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