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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Imported data that maintains a refreshable link to its external source.

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.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Sample data used in place of actual data to verify formulas in a template.

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

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Method to import an Access table into an Excel worksheet when both applications are open.

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

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

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

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

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

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

You can click the ____________________ button (DATA tab | Get External Data group) to display the Select Data Source dialog box and then import a table from an Access database.

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

Briefly describe planning considerations before you begin importing data.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Selects data from the Internet to add to an Excel worksheet.

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

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