Exam 8: Excell: Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots

SmartArt graphics may include at most one shape.

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

Importing ____ provides greater flexibility to manipulate text in Excel.

The ____________________ Wizard is a powerful tool for manipulating text data in columns.

Which of the following is a SmartArt graphic category?

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

A(n) ____________________ graphic is a customizable diagram that you use to pictorially present lists, processes, and relationships.

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

Creating a(n) ____________________, such as that shown in the accompanying figure, involves the same basic steps used to create a workbook.

When you import a table from Access into Excel, the table is formatted with the default table style for the database's theme.

Briefly explain the considerations for choosing a SmartArt graphic.

Imported data that maintains a refreshable link to its external source is called ____ data.

You can transpose directly from copied Word tables.

The Transpose command is located on the Copy button menu.

To create an exact copy of a formula without replication, hold down the ____ key while dragging the fill handle.

If you have both Excel and Access open on your desktop, you can drag and drop an entire table or query from Access to Excel.

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

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

Critical Thinking Questions Case 7-2 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 ____.