Deck 8: Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

Question 1

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

Answer 1

C

Question 2

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

Answer 2

B

Question 3

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)

Answer 3

A

Question 4

Webpages use a file format called ____.

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

Question 5

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 6

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 7

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 8

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

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

Question 9

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 10

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

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

Question 11

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 12

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

Question 13

____ can describe any type of data.

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

Question 14

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

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

Question 15

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 16

A(n) ____ contains little or no formatting.

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

Question 17

Importing ____ provides greater flexibility to manipulate text in Excel.

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

Question 18

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 19

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 20

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 21

Elements in a SmartArt graphic are grouped in ____.

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

Question 22

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

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

Question 23

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 24

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 25

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 26

Which of the following is NOT a SmartArt graphic category?

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

Question 27

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

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

Question 28

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

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

Question 29

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 30

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 31

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 32

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 33

Which of the following is a SmartArt graphic category?

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

Question 34

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

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

Question 35

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 36

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

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

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 39

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

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

Question 40

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

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

Question 41

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

Question 42

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 43

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 44

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

Question 45

You can transpose directly from copied Word tables.

Question 46

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 47

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 48

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

Question 49

Excel allows you to import data from webpages.

Question 50

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

Question 51

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

Question 52

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

Question 53

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

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

Question 54

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

Question 55

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 56

Templates can contain ____.

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

Question 57

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

A) copying data from webpages to the Office Clipboard and then pasting it into Excel does not maintain all of the webpage formatting
B) copying only the desired data from webpages to the Office Clipboard and then pasting it into Excel can be tedious
C) copying data from webpages to the Office Clipboard and then pasting it into Excel creates duplicate entries that must be deleted
D) copying data from webpages to the Office Clipboard and then pasting it into Excel does not create a link to the webpage for future updating

Question 58

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 59

The Transpose command is located on the Copy button menu.

Question 60

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

Question 61

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

Question 62

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

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

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

Question 66

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

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

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

Question 69

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 70

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

Question 71

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 72

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

Question 73

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

Question 74

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

Question 75

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

Question 76

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

Question 77

SmartArt graphics may include at most one shape.

Question 78

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

Question 79

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

Question 80

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