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

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.

When saving a template, and the Excel Template file type is chosen in the ____________________ box in the Save As dialog box, Excel automatically changes the location to the appropriate folder created when Office 2013 was installed.

Importing data into Excel can create a(n) ____________________ link that can be used to update data whenever the original file changes.

In today's business environment, you often find that you need to create multiple ____________________ that follow the same basic format.

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

The only difference between developing a workbook and a template is the ____________________ used to save the template.

Some spreadsheet specialists refer to copying formulas as ____________________.

-Excel includes ____ types of SmartArt graphics, an example of which appears in the accompanying figure.

To rotate pictures in Excel, select the image to be rotated, then tap or click the ____ button (PICTURE TOOLS FORMAT tab | Arrange group).

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

A(n) ____ contains little or no formatting.

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

Case 7-1 Laura, in Personnel, needs to create a new payroll workbook each month. The formatting and formulas are the same in each new workbook; only the payroll data is different. During a conversation at lunch, she asks if you have any suggestions for ways she can save time with this workbook setup task. -Laura was so impressed with your helpful suggestion for the payroll workbook that she gives you a call about another issue. She has just been told that some of the branch office payroll data will now be available in an Access database table. She is unfamiliar with Access and asks you if there is an easy way to get the Access table data into the payroll workbook. You tell her that she can _____.

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

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

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

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

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

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

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