Question 1

When you use a template,you can make any changes you want to the workbook without affecting the template file.

Accepted Answer

A) True 
 B)False

Question 2

-Hyperlinks like the ones created with the dialog box in the accompanying figure can be used to jump to ____.

Accepted Answer

A)  sites on the Web 
B)  a Word document 
C)  a PowerPoint presentation 
D)  any of the above 
A)  sites on the Web 
B)  a Word document 
C)  a PowerPoint presentation 
D)  any of the above

Question 3

To delete the data values,you can click the Clear button in the Editing group on the ____ tab,and then click Clear Contents.

Accepted Answer

A)  File 
B)  Home 
C)  Review 
D)  View 
A)  File 
B)  Home 
C)  Review 
D)  View

Question 4

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Contains text,formats,and formulas already built into it for your use

Accepted Answer

A) 3-D 
B) template 
C) A 
D) source 
E) destination
F)link
G)M
H)workspace
I)hyperlink
J)ScreenTip
K)worksheet group
L)ungroup 
A) 3-D 
B) template 
C) A 
D) source 
E) destination
F)link
G)M
H)workspace
I)hyperlink
J)ScreenTip
K)worksheet group
L)ungroup

Question 5

A 3-D cell ____________________ specifies not only the rows and columns of a cell range,but also the range of worksheet names that the cells appear on.

Accepted Answer

The answer of A 3-D cell ____________________ specifies not only...

Question 6

When two workbooks are ____,it is important that the data in the destination file accurately reflects the contents of the source file.

Accepted Answer

A)  linked 
B)  embedded 
C)  concatenated 
D)  consolidated 
A)  linked 
B)  embedded 
C)  concatenated 
D)  consolidated

Question 7

Case-Based Critical Thinking Questions
Case 6-1
Perry is having trouble using linked workbooks,so he consults his colleague Malia for help.
-Finally,Perry asks Malia what steps (if any)need to be taken to keep a destination file up-to-date if he updates a value in one of the source files.Which of the following statements by Malia would NOT be correct?

Accepted Answer

A)  If a destination file is open when a source file is changed,the destination file will be updated automatically. 
B)  Source files cannot be updated unless the corresponding destination file is open. 
C)  In some circumstances,it is possible to choose whether a destination file should reflect changes made to the source files. 
D)  All of the above statements are correct. 
A)  If a destination file is open when a source file is changed,the destination file will be updated automatically. 
B)  Source files cannot be updated unless the corresponding destination file is open. 
C)  In some circumstances,it is possible to choose whether a destination file should reflect changes made to the source files. 
D)  All of the above statements are correct.

Question 8

In regard to open workbooks,a workspace saves all of the following EXCEPT ____.

Accepted Answer

A)  the workbooks themselves 
B)  window sizes 
C)  zoom magnifications 
D)  formats used 
A)  the workbooks themselves 
B)  window sizes 
C)  zoom magnifications 
D)  formats used

Question 9

To ungroup worksheets,you can click a sheet ____ of a sheet not in the group.

Accepted Answer

A)  index 
B)  panel 
C)  tab 
D)  pane 
A)  index 
B)  panel 
C)  tab 
D)  pane

Question 10

Which of the following is NOT a task-specific template available from the Microsoft Office Online Web site?

Accepted Answer

A)  Family Budget 
B)  Inventory List 
C)  Team Roster 
D)  Fax Cover Sheet 
A)  Family Budget 
B)  Inventory List 
C)  Team Roster 
D)  Fax Cover Sheet

When you use a template,you can make any changes you want to the workbook without affecting the template file.

-Hyperlinks like the ones created with the dialog box in the accompanying figure can be used to jump to ____.

To delete the data values,you can click the Clear button in the Editing group on the ____ tab,and then click Clear Contents.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Contains text,formats,and formulas already built into it for your use

A 3-D cell ____________________ specifies not only the rows and columns of a cell range,but also the range of worksheet names that the cells appear on.

When two workbooks are ____,it is important that the data in the destination file accurately reflects the contents of the source file.

In regard to open workbooks,a workspace saves all of the following EXCEPT ____.

To ungroup worksheets,you can click a sheet ____ of a sheet not in the group.

Which of the following is NOT a task-specific template available from the Microsoft Office Online Web site?

Getting Started With Excel

Formatting a Workbook

Working With Formulas and Functions

Enhancing a Workbook With Charts and Graphs

Working With Excel Tables, Pivot-tables, and Pivot-charts

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Performing What-If Analyses

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters

Exam 6: Managing Multiple Worksheets and Workbooks

When you use a template,you can make any changes you want to the workbook without affecting the template file.

-Hyperlinks like the ones created with the dialog box in the accompanying figure can be used to jump to ____.

To delete the data values,you can click the Clear button in the Editing group on the ____ tab,and then click Clear Contents.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Contains text,formats,and formulas already built into it for your use

A 3-D cell ____________________ specifies not only the rows and columns of a cell range,but also the range of worksheet names that the cells appear on.

When two workbooks are ____,it is important that the data in the destination file accurately reflects the contents of the source file.

In regard to open workbooks,a workspace saves all of the following EXCEPT ____.

To ungroup worksheets,you can click a sheet ____ of a sheet not in the group.

Which of the following is NOT a task-specific template available from the Microsoft Office Online Web site?

Getting Started With Excel

Formatting a Workbook

Working With Formulas and Functions

Enhancing a Workbook With Charts and Graphs

Working With Excel Tables, Pivot-tables, and Pivot-charts

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Performing What-If Analyses

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters