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

Deployments are most helpful when you need to create several similar or identical workbooks.

Some spreadsheet specialists refer to copying formulas as ____________________.

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

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

You can access the Find and Replace feature by pressing the ____ key(s).

Which of the following is the path to the Refresh All 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.

For a file that does not yet have a file name, you can open the Save As dialog box to save a template by pressing the ____ keys.

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. Mark wants to illustrate trends in the average sales price for several products. You suggest that he ____.

The most common use for the Convert Text to Columns Wizard is to manipulate imported data.

A(n) ____ contains little or no formatting.

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

When you add a new shape to a SmartArt graphic, Excel rearranges the shapes in the graphic to fit in the same area.

What are the steps to insert an individual image into a workbook?

In some situations, you may find that a column of data imported from Word should be split into two columns.

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

You should not credit the source of an image unless you can specifically name the image creator.

Modified Multiple Choice The Import Data dialog box allows you to choose whether to import the data into a ____.

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.