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

A team of coworkers from the marketing department are holding a brainstorming session on ways to add more visual interest to a sales data workbook and, at the same time, improve user understanding of the data and calculations included in the workbook. They invite you to be part of the discussion. -Mark wants to illustrate trends in the average sales price for several products.You suggest that he ____.

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

A team of coworkers from the marketing department are holding a brainstorming session on ways to add more visual interest to a sales data workbook and, at the same time, improve user understanding of the data and calculations included in the workbook. They invite you to be part of the discussion. -Liz says she wants to find a way to illustrate how changes in production costs affect sales prices.You suggest that she consider ____.

Which of the following is the path to the Format Painter button?

Which of the following is the path to the Insert WordArt button?

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

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

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

To copy the contents of a cell to the cell directly below it,tap or click in the target cell and then press ____________________.

Which of the following is the path to the 'Insert a SmartArt Graphic' button?

Some spreadsheet specialists refer to copying formulas as ____________________.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A special-purpose workbook used as a pattern to create similar workbooks.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Switched rows and columns for imported data.

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

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.

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

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

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

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.

Excel allows you to take a ____ of any open window and add it to a workbook.