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

To locate a specific piece of data in a worksheet and then replace the data, use the ____________________ command.

Which of the following is NOT a SmartArt graphic category?

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.

The Find and Replace dialog box has two variations, one displaying minimal options and the other displaying all of the available options.

When Excel imports a database table, the data is placed in an Excel ____.

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.

Which of the following is the path to the 'Take a Screenshot' button?

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.

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

Tapping or clicking the ____ button changes a SmartArt graphic to individual shapes that can be resized, moved, or deleted independently of the others.

Excel allows you to import data from webpages.

Critical Thinking Questions 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. 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.

In some cases, when you import data, the data will need to be ____, meaning that the rows and columns need to be switched.

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

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

Webpages use a file format called ____.