Question 1

HTML stands for ____________________ .

Accepted Answer

The answer of HTML stands for ____________________ ....

Question 2

Some spreadsheet specialists refer to copying formulas as ____________________.

Accepted Answer

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

Question 3

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 4

Match between columns
                        Premises: Another term for copying formulas.

Accepted Answer

The Answer of dummy data and drag and drop and is...

Question 5

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.

Accepted Answer

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

Question 6

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 7

To copy the contents 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 copy the contents of a cell...

Question 8

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 9

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 10

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

Accepted Answer

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

Question 11

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

Accepted Answer

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

Question 12

Match between columns
                        Premises: A popular format for data exchange.

Accepted Answer

The Answer of dummy data and fixed width file and is...

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

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 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

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

Question 17

Match between columns
                        Premises: Method to import an Access table into an Excel worksheet when both applications are open.

Accepted Answer

The Answer of external data and template and dummy data is...

Question 18

Match between columns
                        Premises: Selects data from the Internet to add to an Excel worksheet.

Accepted Answer

The Answer of drag and drop and dummy data and is...

Question 19

Match between columns
                        Premises: A special-purpose workbook used as a pattern to create similar workbooks.

Accepted Answer

The Answer of template and fixed width file and Web is...

Question 20

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

Accepted Answer

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

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

HTML stands for ____________________ .

Some spreadsheet specialists refer to copying formulas as ____________________.

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

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

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.

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

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

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.

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

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

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

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

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

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.

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

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

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

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

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

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