Deck 7: Creating Templates,importing Data,and Working With Smartart,Images,and Screen Shots

Question 1

Importing ____ provides greater flexibility to manipulate text in Excel.

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

Answer 1

C

Question 2

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)

Answer 2

B

Question 3

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 3

A

Question 4

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 5

Webpages use a file format called ____.

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

Question 6

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 7

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 8

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 9

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 10

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

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

Question 11

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

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

Question 12

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 13

____ can describe any type of data.

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

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

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 16

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 17

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

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

Question 18

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 19

A(n)____ contains little or no formatting.

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

Question 20

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 21

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 22

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 23

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 24

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

Elements in a SmartArt graphic are grouped in ____.

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

Question 27

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 28

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 29

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

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

Question 30

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

A) .bmp
B) ·png
C) .tif
D) .mp3

Question 31

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

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

Question 32

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

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

Question 33

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 34

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 35

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 36

Which of the following is a SmartArt graphic category?

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

Question 37

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

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

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

Which of the following is NOT a SmartArt graphic category?

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

Question 40

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 41

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

Question 42

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 43

Templates can contain ____.
a.
text
b.
graphics
c.
page layouts
d.
macros

Question 44

The Transpose command is located on the Copy button menu.

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

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 47

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 48

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

Question 49

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 50

A template usually consists of ____ that are common to all the worksheets.
a.
a format
b.
images
c.
formulas
d.
charts

Question 51

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 52

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

Question 53

You can transpose directly from copied Word tables.

Question 54

Excel allows you to import data from webpages.

Question 55

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

Question 56

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 57

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 58

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

Question 59

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

Question 60

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

Question 61

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 62

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

Question 63

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

Question 64

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

Question 65

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

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

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

Question 68

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

Question 69

SmartArt graphics may include at most one shape.

Question 70

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

Question 71

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

Question 72

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

Question 73

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

Question 74

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

Question 75

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

Question 76

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

Question 77

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

Question 78

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

Question 79

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 80

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