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

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

Templates can contain ____.

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

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

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.

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

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.

Inserting a check mark in the _____________________ option in the Find and Replace dialog box means that the search will be case sensitive.

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

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

When saving a template,and the Excel Template file type is chosen in the ____________________ box in the Save As dialog box,Excel automatically changes the location to the appropriate folder created when Office 2013 was installed.

Excel's Transpose command requires that the ____________________ of the transposed data be different from the destination.

To locate a specific piece of data in a worksheet and then replace the data,use the ____________________ command.

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.

A(n)____ is a special-purpose workbook you can create and then use as a pattern to create new,similar workbooks or worksheets.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Another term for copying formulas.

Importing data into Excel can create a(n)____________________ link that can be used to update data whenever the original file changes.

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.

The Transpose command is located on the Copy button menu.

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