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

Which of the following is the path to the Find & Select button?

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

A(n)____ contains little or no formatting.

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

A screen ____ is a portion,usually of one object or section of a window,of the screen.

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

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

Clicking the ____ button changes a SmartArt graphic to individual shapes that can be resized,moved,or deleted independently of the others.

When a template is created,dummy ____ is / are used to verify the formulas in the template.

Elements in a SmartArt graphic are grouped in ____.

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

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

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

Which of the following is NOT a SmartArt graphic category?

You can select any range of cells with entries surrounded by blank cells by clicking a cell in the range and then pressing ____.

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

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

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

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.

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