Question 1

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

Accepted Answer

A)  row 
B)  column 
C)  cell 
D)  table 
A)  row 
B)  column 
C)  cell 
D)  table

Question 2

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

Accepted Answer

A)  sneak peek 
B)  screen shot 
C)  quick glimpse 
D)  cybergrab 
A)  sneak peek 
B)  screen shot 
C)  quick glimpse 
D)  cybergrab

Question 3

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 4

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

Accepted Answer

A) True 
 B)False

Question 5

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 6

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 7

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A popular format for data exchange.

Accepted Answer

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

Question 8

When you import a table from Access into Excel, the table is formatted with the default table style for the database's theme.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following can be sources of imported data for an Excel workbook?

Accepted Answer

A)  database table 
B)  data stored in Word documents 
C)  text file 
D)  XML file 
E)  None of the above 
A)  database table 
B)  data stored in Word documents 
C)  text file 
D)  XML file 
E)  None of the above

Question 10

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 11

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Save as type to create a template workbook.

Accepted Answer

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

Question 12

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

Accepted Answer

Question 13

The Transpose command is located on the Copy button menu.

Accepted Answer

A) True 
 B)False

Question 14

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A special-purpose workbook used as a pattern to create similar workbooks.

Accepted Answer

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

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

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

Accepted Answer

Question 17

In business situations, it is a good idea to save a template in the default ____________________ folder location so your template would appear with other templates when users need to find them.

Accepted Answer

The answer of In business situations, it is a good...

Question 18

In some situations, you may find that a column of data imported from Word should be split into two columns.

Accepted Answer

A) True 
 B)False

Question 19

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.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following is the path to the Get Data From Web button?

Accepted Answer

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

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

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

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

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

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.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A popular format for data exchange.

When you import a table from Access into Excel, the table is formatted with the default table style for the database's theme.

Which of the following can be sources of imported data for an Excel workbook?

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Save as type to create a template workbook.

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

The Transpose command is located on the Copy button menu.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A special-purpose workbook used as a pattern to create similar workbooks.

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

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

In business situations, it is a good idea to save a template in the default ____________________ folder location so your template would appear with other templates when users need to find them.

In some situations, you may find that a column of data imported from Word should be split into two columns.

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.

Which of the following is the path to the Get Data From Web button?

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Working With Multiple Worksheets and Workbooks

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Filters

Exam 8: Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

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

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

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

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

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

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.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A popular format for data exchange.

When you import a table from Access into Excel, the table is formatted with the default table style for the database's theme.

Which of the following can be sources of imported data for an Excel workbook?

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Save as type to create a template workbook.

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

The Transpose command is located on the Copy button menu.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A special-purpose workbook used as a pattern to create similar workbooks.

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

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

In business situations, it is a good idea to save a template in the default ____________________ folder location so your template would appear with other templates when users need to find them.

In some situations, you may find that a column of data imported from Word should be split into two columns.

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.

Which of the following is the path to the Get Data From Web button?

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Working With Multiple Worksheets and Workbooks

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Filters