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

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

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

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

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.

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

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

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

____ can describe any type of data.

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

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

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.

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

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

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

The Transpose command is located on the Copy button menu.

Importing ____ provides greater flexibility to manipulate text in Excel.

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

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.

You can transpose directly from copied Word tables.

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