Exam 8: Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

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

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

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

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.

Elements in a SmartArt graphic are grouped in ____.

Webpages use a file format called ____.

____ can describe any type of data.

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

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 ____.

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

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

Templates can contain ____.