Question 1

Using multiple worksheets with identical layouts enables you to use 3-D references to quickly summarize the data in another worksheet.

Accepted Answer

A) True 
 B)False

Question 2

The default template contains the default formatting you start out with in every new workbook,including the ____ number format.

Accepted Answer

A)  Number 
B)  Currency 
C)  Integer 
D)  General 
A)  Number 
B)  Currency 
C)  Integer 
D)  General

Question 3

After you have a Windows Live ID,you can access your SkyDrive and the Office Web Apps.

Accepted Answer

A) True 
 B)False

Question 4

Formulas created using the point-and-click method contain ____ references.

Accepted Answer

A)  absolute 
B)  mixed 
C)  relative 
D)  relational 
A)  absolute 
B)  mixed 
C)  relative 
D)  relational

Question 5

The default template contains the default formatting you start out with in every new workbook,including ____ 11-point font.

Accepted Answer

A)  Calibri 
B)  Helvetica 
C)  Geneva 
D)  Times New Roman 
A)  Calibri 
B)  Helvetica 
C)  Geneva 
D)  Times New Roman

Question 6

The default template has column widths is set to ____ characters.

Accepted Answer

A)  15.23 
B)  12.44 
C)  10.85 
D)  8.43 
A)  15.23 
B)  12.44 
C)  10.85 
D)  8.43

Question 7

The ____ dialog box lists all of the links in the current workbook.

Accepted Answer

A)  Show Links 
B)  Edit Links 
C)  Link and Embed 
D)  Paste Special 
A)  Show Links 
B)  Edit Links 
C)  Link and Embed 
D)  Paste Special

Question 8

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Usually represented by colored words with underlines or images

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 9

To select nonadjacent worksheets,you click a sheet tab of one of the worksheets,and then press and hold down the Shift key as you click the sheet tabs of other worksheets you want included in the group._________________________

Accepted Answer

A) True 
 B)False

Question 10

To save files to SkyDrive or use the Office Web Apps,you need a Windows ________________.

Accepted Answer

The answer of To save files to SkyDrive or use...

Question 11

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A connection between two files allowing information to be transferred from one file to the other

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 12

A worksheet cluster is a collection of two or more selected worksheets.

Accepted Answer

A) True 
 B)False

Question 13

To delete a hyperlink,right-click the hyperlink cell and then click Clear Value._________________________

Accepted Answer

A) True 
 B)False

Question 14

Excel has some templates that are automatically installed on your hard disk.

Accepted Answer

A) True 
 B)False

Question 15

If you need to use data located in one workbook in the other workbook,you have to create a(n)____ between the two workbooks.

Accepted Answer

A)  anchor 
B)  source 
C)  link 
D)  index 
A)  anchor 
B)  source 
C)  link 
D)  index

Question 16

The ____ template in Excel creates an online time card to track employees' work hours.

Accepted Answer

A)  Payroll 
B)  Personnel Statement 
C)  Time Sheet 
D)  Employment Calculator 
A)  Payroll 
B)  Personnel Statement 
C)  Time Sheet 
D)  Employment Calculator

Question 17

________________ refers to data,applications,and even resources that are stored on servers that you access over the Internet rather than on your own computer.

Accepted Answer

The answer of ________________ refers to data,applications,and even resources that...

Question 18

In the Edit Links dialog box,Type identifies the type of each ____ file.

Accepted Answer

A)  destination 
B)  source 
C)  import 
D)  all of the above 
A)  destination 
B)  source 
C)  import 
D)  all of the above

Question 19

You can use the ____________________ dialog box to break links between workbooks.

Accepted Answer

The answer of You can use the ____________________ dialog box...

Question 20

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Appears when you place the pointer over a hyperlink

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

Using multiple worksheets with identical layouts enables you to use 3-D references to quickly summarize the data in another worksheet.

The default template contains the default formatting you start out with in every new workbook,including the ____ number format.

After you have a Windows Live ID,you can access your SkyDrive and the Office Web Apps.

Formulas created using the point-and-click method contain ____ references.

The default template contains the default formatting you start out with in every new workbook,including ____ 11-point font.

The default template has column widths is set to ____ characters.

The ____ dialog box lists all of the links in the current workbook.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Usually represented by colored words with underlines or images

To select nonadjacent worksheets,you click a sheet tab of one of the worksheets,and then press and hold down the Shift key as you click the sheet tabs of other worksheets you want included in the group._________________________

To save files to SkyDrive or use the Office Web Apps,you need a Windows ________________.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A connection between two files allowing information to be transferred from one file to the other

A worksheet cluster is a collection of two or more selected worksheets.

To delete a hyperlink,right-click the hyperlink cell and then click Clear Value._________________________

Excel has some templates that are automatically installed on your hard disk.

If you need to use data located in one workbook in the other workbook,you have to create a(n)____ between the two workbooks.

The ____ template in Excel creates an online time card to track employees' work hours.

________________ refers to data,applications,and even resources that are stored on servers that you access over the Internet rather than on your own computer.

In the Edit Links dialog box,Type identifies the type of each ____ file.

You can use the ____________________ dialog box to break links between workbooks.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Appears when you place the pointer over a hyperlink

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

Using multiple worksheets with identical layouts enables you to use 3-D references to quickly summarize the data in another worksheet.

The default template contains the default formatting you start out with in every new workbook,including the ____ number format.

After you have a Windows Live ID,you can access your SkyDrive and the Office Web Apps.

Formulas created using the point-and-click method contain ____ references.

The default template contains the default formatting you start out with in every new workbook,including ____ 11-point font.

The default template has column widths is set to ____ characters.

The ____ dialog box lists all of the links in the current workbook.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Usually represented by colored words with underlines or images

To select nonadjacent worksheets,you click a sheet tab of one of the worksheets,and then press and hold down the Shift key as you click the sheet tabs of other worksheets you want included in the group._________________________

To save files to SkyDrive or use the Office Web Apps,you need a Windows ________________.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A connection between two files allowing information to be transferred from one file to the other

A worksheet cluster is a collection of two or more selected worksheets.

To delete a hyperlink,right-click the hyperlink cell and then click Clear Value._________________________

Excel has some templates that are automatically installed on your hard disk.

If you need to use data located in one workbook in the other workbook,you have to create a(n)____ between the two workbooks.

The ____ template in Excel creates an online time card to track employees' work hours.

________________ refers to data,applications,and even resources that are stored on servers that you access over the Internet rather than on your own computer.

In the Edit Links dialog box,Type identifies the type of each ____ file.

You can use the ____________________ dialog box to break links between workbooks.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Appears when you place the pointer over a hyperlink

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