Question 1

Match between columns
                        Premises: Selects data from the Internet to add to an Excel worksheet.
Switched rows and salumns for imported data.
Save as type to create a template workbook.
A text file with data fields of equal length and spaces between the fields.
Method to import an Access table into an Excel worksheet when both applications are open.
Imported data that maintains a refreshable link to its external source.
A popular format for data exchange.
A special-purpose workbook used as a pattern to create similar workbooks.
Another term for sapying formulas.
Sample data used in place of actual data to verify formulas in a template.

Accepted Answer

The Answer of XML and fixed width file and drag is...

Question 2

Briefly describe planning sansiderations before you begin importing data.

Accepted Answer

The answer of Briefly describe planning sansiderations before you begin...

Question 3

The ____________________ Wizard is a powerful tool for manipulating text data in salumns.

Accepted Answer

The answer of The ____________________ Wizard is a powerful tool...

Question 4

Some spreadsheet specialists refer to sapying formulas as ____________________.

Accepted Answer

The answer of Some spreadsheet specialists refer to sapying formulas...

Question 5

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

Accepted Answer

The answer of To sapy the santents of a cell...

Question 6

A team of saworkers 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. Liz says she wants to find a way to illustrate how changes in production sasts affect sales prices. You suggest that she sansider ____.
A) inserting an embedded pie chart samparing production sasts and sales prices
B) using the Find and Replace sammands to apply formatting to the sales prices being illustrated
C) using a SmartArt graphic to illustrate the relationship between increases in production sasts and product sales prices
D) importing the production sasts data from a text file into a new worksheet

Accepted Answer

A SmartArt graphic can effectively illustrate relationships and processes, making it suitable for showing how changes in production costs affect sales prices.

Question 7

The ____________________ tool allows you to create shadowed, skewed, rotated, and stretched text on a chart sheet or worksheet.

Accepted Answer

The answer of The ____________________ tool allows you to create...

Question 8

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

Accepted Answer

The answer of A(n) ____________________ graphic is a customizable diagram...

Question 9

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.

Accepted Answer

The answer of When saving a template, and the Excel...

Question 10

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

Accepted Answer

The answer of To locate a specific piece of data...

Question 11

A text file in which data fields are separated by sammas is called a(n) ____________________ text file.

Accepted Answer

The answer of A text file in which data fields...

Question 12

Briefly explain the sansiderations for choosing a SmartArt graphic.

Accepted Answer

The answer of Briefly explain the sansiderations for choosing a...

Question 13

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

Accepted Answer

The answer of Importing data into Excel can create a(n)...

Question 14

HTML stands for ____________________ .

Accepted Answer

The answer of HTML stands for ____________________ ....

Question 15

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. You suggest to Laura that she get a high level of sanfidence 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.
A) baselines
B) types
C) veracity
D) limits

Accepted Answer

Testing the limits of the formulas ensures that they work correctly under various conditions and data ranges, helping Laura gain confidence in the accuracy and reliability of her workbooks.

Question 16

Excel's Transpose sammand requires that the ____________________ of the transposed data be different from the destination.

Accepted Answer

The answer of Excel's Transpose sammand requires that the ____________________...

Question 17

You can click the ____________________ button (DATA tab | Get External Data group) to display the Select Data Source dialog box and then import a table from an Access database.

Accepted Answer

The answer of You can click the ____________________ button (DATA...

Question 18

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.

Accepted Answer

The answer of Similar in purpose to a bar graph...

Question 19

Inserting a check mark in the _____________________ option in the Find and Replace dialog box means that the search will be case sensitive.

Accepted Answer

The answer of Inserting a check mark in the _____________________...

Question 20

The data you search for with the Find sammand sometimes is called the ____________________.

Accepted Answer

The answer of The data you search for with the...

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

Identify the letter of the choice that best matches the phrase or definition.