Question 1

A(n)____________________ is a connection between two files allowing information to be transferred from one file to the other.

Accepted Answer

The answer of A(n)____________________ is a connection between two files...

Question 2

Click the button marked ____ in the accompanying figure to find out whether Excel has attempted to update the links in this session.

Accepted Answer

A)  1
B)  2
C)  3
D)  4E) All of the above
F) None of the above

Question 3

You can enter 3-D references by using your mouse to select the appropriate worksheet cells in the workbook.

Accepted Answer

A) True 
 B)False

Question 4

Once you group a collection of worksheets any changes you make to one worksheet are applied to all sheets in the group.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is NOT an option for arranging your workbooks?

Accepted Answer

A)  tiled
B)  cascade
C)  horizontal
D)  lateralE) B) and C)
F) A) and C)

Question 6

A(n)____________________ is a link in a file such as a workbook to information within that file or another file.

Accepted Answer

The answer of A(n)____________________ is a link in a file...

Question 7

When you click a(n) ____ the computer switches to the file or portion of the file that it references.

Accepted Answer

A)  index
B)  hyperlink
C)  template
D)  iconE) A) and C)
F) B) and C)

Question 8

Match between columns
                        Premises: Saves information about currently opened workbooks

Accepted Answer

The Answer of workspace and source and template and link is...

Question 9

The default template has ____ worksheets inserted in the workbook.

Accepted Answer

A)  three
B)  four
C)  five
D)  sixE) B) and D)
F) A) and C)

Question 10

Which of the following Custom Header buttons adds the worksheet name to the top of each page?

Accepted Answer

A)  Customize Worksheet
B)  Add Filename
C)  Insert Sheet Name
D)  Customize HeaderE) C) and D)
F) B) and C)

Question 11

To select nonadjacent worksheets you use the ____ key.

Accepted Answer

A)  Alt
B)  Ctrl
C)  Esc
D)  ShiftE) A) and B)
F) All of the above

Question 12

To create a template you simply save an Excel workbook in template format using the ____ dialog command.

Accepted Answer

A)  Template
B)  Save
C)  Save As
D)  ConvertE) A) and B)
F) A) and C)

Question 13

Like cell ____ a worksheet group can contain adjacent or nonadjacent sheets.

Accepted Answer

A)  controls
B)  groups
C)  tabs
D)  rangesE) B) and C)
F) B) and D)

Question 14

By default hyperlinks like those created by the dialog box in the accompanying figure are in ____ font.

Accepted Answer

A)  italicized red
B)  underlined blue
C)  boldfaced green
D)  italicized blueE) A) and D)
F) C) and D)

Question 15

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 16

When you reference cells and ranges in other worksheets if the worksheet name contains spaces you must enclose the sheet name in ____.

Accepted Answer

A)  braces
B)  brackets
C)  parentheses
D)  single quotation marksE) C) and D)
F) None of the above

Question 17

When you reference a cell or range in a different worksheet the ____ separates the sheet reference from the cell reference.

Accepted Answer

A)  (?) 
B)  !
C)  "
D)  ;E) All of the above
F) A) and B)

Question 18

Match between columns
                        Premises: Type of cell reference that refers to the same cell or range of cells on multiple worksheets in the same workbook

Accepted Answer

The Answer of link and A and source and template is...

Question 19

Using multiple worksheets makes it more difficult for you to group your data.

Accepted Answer

A) True 
 B)False

Question 20

Click the item marked ____ to set the text that will appear whenever you place the pointer over a hyperlink.

Accepted Answer

A)  1
B)  2
C)  3
D)  4E) B) and D)
F) B) and C)

Exam 6: Excel: Managing Multiple Worksheets and Workbooks

You can enter 3-D references by using your mouse to select the appropriate worksheet cells in the workbook.

Correct Answer
verified

Once you group a collection of worksheets any changes you make to one worksheet are applied to all sheets in the group.

Correct Answer
verified

Like cell ____ a worksheet group can contain adjacent or nonadjacent sheets.

Correct Answer
verified

Identify the letter of the choice that best matches the phrase or definition.

Which of the following Custom Header buttons adds the worksheet name to the top of each page?

Correct Answer
verified

When you reference cells and ranges in other worksheets if the worksheet name contains spaces you must enclose the sheet name in ____.

Correct Answer
verified

To select nonadjacent worksheets you use the ____ key.

Correct Answer
verified

When you reference a cell or range in a different worksheet the ____ separates the sheet reference from the cell reference.

Correct Answer
verified

A(n)____________________ is a connection between two files allowing information to be transferred from one file to the other.

Correct Answer
verified

The default template has ____ worksheets inserted in the workbook.

Correct Answer
verified

By default hyperlinks like those created by the dialog box in the accompanying figure are in ____ font.

Correct Answer
verified

Click the button marked ____ in the accompanying figure to find out whether Excel has attempted to update the links in this session.

Correct Answer
verified

When you click a(n) ____ the computer switches to the file or portion of the file that it references.

Correct Answer
verified

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.

Correct Answer
verified

Which of the following is NOT an option for arranging your workbooks?

Correct Answer
verified

To create a template you simply save an Excel workbook in template format using the ____ dialog command.

Correct Answer
verified

A(n)____________________ is a link in a file such as a workbook to information within that file or another file.

Correct Answer
verified

Identify the letter of the choice that best matches the phrase or definition.

Click the item marked ____ to set the text that will appear whenever you place the pointer over a hyperlink.

Correct Answer
verified

Using multiple worksheets makes it more difficult for you to group your data.

Correct Answer
verified

Exam 6: Excel: Managing Multiple Worksheets and Workbooks

You can enter 3-D references by using your mouse to select the appropriate worksheet cells in the workbook.

Correct AnswerverifiedShow Answer

Once you group a collection of worksheets any changes you make to one worksheet are applied to all sheets in the group.

Correct AnswerverifiedShow Answer

Like cell ____ a worksheet group can contain adjacent or nonadjacent sheets.

Correct AnswerverifiedShow Answer

Identify the letter of the choice that best matches the phrase or definition.

Which of the following Custom Header buttons adds the worksheet name to the top of each page?

Correct AnswerverifiedShow Answer

When you reference cells and ranges in other worksheets if the worksheet name contains spaces you must enclose the sheet name in ____.

Correct AnswerverifiedShow Answer

To select nonadjacent worksheets you use the ____ key.

Correct AnswerverifiedShow Answer

When you reference a cell or range in a different worksheet the ____ separates the sheet reference from the cell reference.

Correct AnswerverifiedShow Answer

A(n)____________________ is a connection between two files allowing information to be transferred from one file to the other.

Correct AnswerverifiedShow Answer

The default template has ____ worksheets inserted in the workbook.

Correct AnswerverifiedShow Answer

By default hyperlinks like those created by the dialog box in the accompanying figure are in ____ font.

Correct AnswerverifiedShow Answer

Click the button marked ____ in the accompanying figure to find out whether Excel has attempted to update the links in this session.

Correct AnswerverifiedShow Answer

When you click a(n) ____ the computer switches to the file or portion of the file that it references.

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

Which of the following is NOT an option for arranging your workbooks?

Correct AnswerverifiedShow Answer

To create a template you simply save an Excel workbook in template format using the ____ dialog command.

Correct AnswerverifiedShow Answer

A(n)____________________ is a link in a file such as a workbook to information within that file or another file.

Correct AnswerverifiedShow Answer

Identify the letter of the choice that best matches the phrase or definition.

Click the item marked ____ to set the text that will appear whenever you place the pointer over a hyperlink.

Correct AnswerverifiedShow Answer

Using multiple worksheets makes it more difficult for you to group your data.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified