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

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.

You can add text to a SmartArt graphic by using the ____.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Save as type to create a template workbook.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Selects data from the Internet to add to an Excel worksheet.

Excel allows you to import formatting from a number of types of sources.

When a range is transposed,the first row of the selected range becomes the first column in the destination range,and so forth.

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. -You suggest to Laura that she get a high level of confidence in the workbooks that she creates.You tell her that one way to do this is to test the workbook extensively,including selecting dummy data that tests the ____ of the formulas.

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 a SmartArt graphic category?

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

Which of the following is the path to the Find & Select button?

The ____ provides step-by-step instructions for importing data from a text file into an Excel worksheet.

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

When you bring in data from various external sources into an Excel worksheet,this is known as ____________________ that data.

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

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.

A(n)____ contains little or no formatting.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Sample data used in place of actual data to verify formulas in a template.

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