Question 1

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Switched rows and columns for imported data.
A)template
B)dummy data
C)XML
D)Excel Template
E)external data
F)fixed width file
G)drag and drop
H)Web query
I)transposed
J)replication

Accepted Answer

Transposed means switching rows and columns, as stated in the phrase. The other choices are not relevant to this definition.

Question 2

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 3

HTML stands for ____________________ .

Accepted Answer

The answer of HTML stands for ____________________ ....

Question 4

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

Question 5

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Imported data that maintains a refreshable link to its external source.
A)template
B)dummy data
C)XML
D)Excel Template
E)external data
F)fixed width file
G)drag and drop
H)Web query
I)transposed
J)replication

Accepted Answer

External data is data that is imported from an external source, such as a database or web query, and maintains a refreshable link to that source.

Question 6

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 7

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 8

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

Accepted Answer

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

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 ____________________ 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 11

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

Question 12

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 13

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.
A)template
B)dummy data
C)XML
D)Excel Template
E)external data
F)fixed width file
G)drag and drop
H)Web query
I)transposed
J)replication

Accepted Answer

Dummy data is used as a substitute for actual data to test the functionality of a template.

Answer: F
 A fixed width file is a type of file format where data is organized into columns of fixed width.

Answer: A
 A template is a pre-designed document or spreadsheet that serves as a starting point for a new file.

Answer: D
 An Excel template is a pre-designed spreadsheet that includes formulas, formatting, and other features.

Answer: H
 A web query is a feature in Excel that allows users to import data from a webpage directly into a spreadsheet.

Answer: I
 Transposing data in Excel means reorganizing it so that its rows become columns and its columns become rows.

Answer: J
 Replication in Excel refers to the process of copying a formula or formatting to multiple cells at once.

Note: XML and external data are not relevant to the given phrase/definition. Drag and drop is a general term that may apply to Excel but is not specific to the given scenario.

Question 14

Some spreadsheet specialists refer to copying formulas as ____________________.

Accepted Answer

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

Question 15

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 16

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 17

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

Question 18

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A text file with data fields of equal length and spaces between the fields.
A)template
B)dummy data
C)XML
D)Excel Template
E)external data
F)fixed width file
G)drag and drop
H)Web query
I)transposed
J)replication

Accepted Answer

A fixed width file is a text file with data fields of equal length and spaces between the fields.

(Note: None of the other choices match this definition.)

Question 19

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 20

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Save as type to create a template workbook.
A)template
B)dummy data
C)XML
D)Excel Template
E)external data
F)fixed width file
G)drag and drop
H)Web query
I)transposed
J)replication

Accepted Answer

An Excel Template is a file type used to create a template workbook.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Switched rows and columns for imported data.