Exam 18: Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots Question

Similar in purpose to a bar graph or salumn chart, a(n) ____________________ chart offers a different 3-D view of the data, and is preferred by some businesses.

A ____ is a way to qualify the data to import by specifying a matching sandition or asking a question of a database.

Which of the following is NOT a SmartArt graphic category?

Webpages use a file format called ____.

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

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.

The sanvert Text to salumns Wizard can be used only when a range that includes two or more salumns is selected.

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.

All of the following are formats accepted for picture files EXCEPT ____.

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

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.

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

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

The Import Data dialog box allows you to choose in which cell to import the text from a text file and to specify properties of the imported text.

Excel allows you to take a ____ of any open window and add it to a workbook.

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

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

You often replicate formulas after sampleting an import because the total number of resards to be imported usually is unknown.

The Transpose sammand is located on the sapy button menu.

Webpage salumn headings are imported with the data and displayed in rows.