Question 1

A screen ____ is a portion, usually of one object or section of a window, of the screen.

Accepted Answer

A)  clipping 
B)  baseline 
C)  excision 
D)  illustration 
A)  clipping 
B)  baseline 
C)  excision 
D)  illustration A

Question 2

A template usually consists of ____ that are common to all the worksheets.

Accepted Answer

A)  a format 
B)  images 
C)  formulas 
D)  charts 
A)  a format 
B)  images 
C)  formulas 
D)  charts A, C

Question 3

You can transpose directly from copied Word tables.

Accepted Answer

A) True 
 B)False  True

Question 4

To create an exact copy of a formula without replication, hold down the ____ key while dragging the fill handle.

Accepted Answer

A)  SHIFT 
B)  TAB 
C)  CTRL 
D)  ALT 
A)  SHIFT 
B)  TAB 
C)  CTRL 
D)  ALT

Question 5

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 6

Which of the following is NOT a SmartArt graphic category?

Accepted Answer

A)  Matrix 
B)  Pyramid 
C)  Picture 
D)  Microsoft.com 
A)  Matrix 
B)  Pyramid 
C)  Picture 
D)  Microsoft.com

Question 7

The Import Data dialog box includes options to specify which parts of a webpage to import and how much of the HTML formatting to keep.

Accepted Answer

A) True 
 B)False

Question 8

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 9

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

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 10

SmartArt graphics may include at most one shape.

Accepted Answer

A) True 
 B)False

Question 11

Case 7-2
A team of coworkers 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 costs affect sales prices. You suggest that she consider ____.

Accepted Answer

A)  inserting an embedded pie chart comparing production costs and sales prices 
B)  using the Find and Replace commands to apply formatting to the sales prices being illustrated 
C)  using a SmartArt graphic to illustrate the relationship between increases in production costs and product sales prices 
D)  importing the production costs data from a text file into a new worksheet 
A)  inserting an embedded pie chart comparing production costs and sales prices 
B)  using the Find and Replace commands to apply formatting to the sales prices being illustrated 
C)  using a SmartArt graphic to illustrate the relationship between increases in production costs and product sales prices 
D)  importing the production costs data from a text file into a new worksheet

Question 12

If you have both Excel and Access open on your desktop, you can drag and drop an entire table or query from Access to Excel.

Accepted Answer

A) True 
 B)False

Question 13

Excel allows you to import data from webpages.

Accepted Answer

A) True 
 B)False

Question 14

HTML stands for ____________________ .

Accepted Answer

Hypertext

Question 15

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 16

Imported data that maintains a refreshable link to its external source is called ____ data.

Accepted Answer

A)  formatted 
B)  external 
C)  exported 
D)  internal 
A)  formatted 
B)  external 
C)  exported 
D)  internal

Question 17

The most common use for the Convert Text to Columns Wizard is to manipulate imported data.

Accepted Answer

A) True 
 B)False

Question 18

A ____ is a way to qualify the data to import by specifying a matching condition or asking a question of a database.

Accepted Answer

A)  question 
B)  query 
C)  quiz 
D)  quota 
A)  question 
B)  query 
C)  quiz 
D)  quota

Question 19

Briefly explain the considerations for choosing a SmartArt graphic.

Accepted Answer

Consider what you want to illustrate in

Question 20

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

Accepted Answer

A) True 
 B)False

A screen ____ is a portion, usually of one object or section of a window, of the screen.

A template usually consists of ____ that are common to all the worksheets.

You can transpose directly from copied Word tables.

To create an exact copy of a formula without replication, hold down the ____ key while dragging the fill handle.

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

Which of the following is NOT a SmartArt graphic category?

The Import Data dialog box includes options to specify which parts of a webpage to import and how much of the HTML formatting to keep.

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

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

SmartArt graphics may include at most one shape.

If you have both Excel and Access open on your desktop, you can drag and drop an entire table or query from Access to Excel.

Excel allows you to import data from webpages.

HTML stands for ____________________ .

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

Imported data that maintains a refreshable link to its external source is called ____ data.

The most common use for the Convert Text to Columns Wizard is to manipulate imported data.

A ____ is a way to qualify the data to import by specifying a matching condition or asking a question of a database.

Briefly explain the considerations for choosing a SmartArt graphic.

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

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

A screen ____ is a portion, usually of one object or section of a window, of the screen.

A template usually consists of ____ that are common to all the worksheets.

You can transpose directly from copied Word tables.

To create an exact copy of a formula without replication, hold down the ____ key while dragging the fill handle.

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

Which of the following is NOT a SmartArt graphic category?

The Import Data dialog box includes options to specify which parts of a webpage to import and how much of the HTML formatting to keep.

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

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

SmartArt graphics may include at most one shape.

If you have both Excel and Access open on your desktop, you can drag and drop an entire table or query from Access to Excel.

Excel allows you to import data from webpages.

HTML stands for ____________________ .

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

Imported data that maintains a refreshable link to its external source is called ____ data.

The most common use for the Convert Text to Columns Wizard is to manipulate imported data.

A ____ is a way to qualify the data to import by specifying a matching condition or asking a question of a database.

Briefly explain the considerations for choosing a SmartArt graphic.

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

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