Question 1

Using multiple worksheets makes it easier to group and summarize data. Describe features that can be applied by forming a worksheet group.

Accepted Answer

By forming a worksheet group, you can: 
• Enter or edit data and formulas. Changes made to content in the active worksheet are also made in the same cells in all the worksheets in the group. You can also use the Find and Replace commands with a worksheet group. 
• Apply formatting. Changes made to formatting in the active worksheet are also made to all the worksheets in the group, including changing row heights or column widths and applying conditional formatting. 
• Insert or delete rows and columns. Changes made to the worksheet structure in the active worksheet are also made to all the worksheets in the group. 
• Set the page layout options. Changes made to the page layout settings in one worksheet also apply to all the worksheets in the group, such as changing the orientation, scaling to fit, and inserting headers and footers. 
• Apply view options. Changes made to the worksheet view such as zooming, showing and hiding worksheets, and so forth are also made to all the worksheets in the group. 
• Print all the worksheets. You can print all of the worksheets in the worksheet group at the same time. ,

Question 2

When two files are linked together, the workbook that contains the information is the ____________________ file.

Accepted Answer

source

Question 3

The default template places the formula results aligned to the ____ of a cell.

Accepted Answer

A)  right side 
B)  left side 
C)  top 
D)  bottom 
A)  right side 
B)  left side 
C)  top 
D)  bottom A

Question 4

Case-Based Critical Thinking Questions
Case 6-3
Your friend Jared asks you to help him learn more about using hyperlinks in an Excel workbook file.
Which of the following statements about hyperlinks in Excel workbooks is correct?

Accepted Answer

A)  They are usually represented by bold faced words with underlines or images. 
B)  They can be used to jump to a specific cell or range within the active worksheet, another worksheet, or another workbook. 
C)  They cannot be used to jump to other types of files or sites on the Web. 
D)  To use a hyperlink, you can click anywhere in the cell that contains the link, including white space in the cell or any text that flows into an adjacent cell. 
A)  They are usually represented by bold faced words with underlines or images. 
B)  They can be used to jump to a specific cell or range within the active worksheet, another worksheet, or another workbook. 
C)  They cannot be used to jump to other types of files or sites on the Web. 
D)  To use a hyperlink, you can click anywhere in the cell that contains the link, including white space in the cell or any text that flows into an adjacent cell.

Question 5

Case-Based Critical Thinking Questions
Case 6-3
Your friend Jared asks you to help him learn more about using hyperlinks in an Excel workbook file.
Jared has heard that ScreenTips can be used in conjunction with hyperlinks. Which of the following statements about ScreenTips is correct?

Accepted Answer

A)  They appear whenever you place the pointer over a cell. 
B)  You can specify the contents of a ScreenTip when you create a hyperlink. 
C)  The default ScreenTip for a hyperlink is the message "Active Hyperlink." 
D)  You can change the contents of an existing ScreenTip by changing the value in the cell. 
A)  They appear whenever you place the pointer over a cell. 
B)  You can specify the contents of a ScreenTip when you create a hyperlink. 
C)  The default ScreenTip for a hyperlink is the message "Active Hyperlink." 
D)  You can change the contents of an existing ScreenTip by changing the value in the cell.

Question 6

Excel, by default, looks for template files in the Templates folder, which is where custom template files are often stored.

Accepted Answer

A) True 
 B)False

Question 7

A formula can include a reference to another workbook (called an ____ reference), which creates a set of linked workbooks.

Accepted Answer

A)  internal 
B)  external 
C)  import 
D)  export 
A)  internal 
B)  external 
C)  import 
D)  export

Question 8

Match between columns
                        Premises: A connection between two files allowing information to be transferred from one file to the other

Accepted Answer

The Answer of 3-D and destination and link and source is...

Question 9

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 10

Match between columns
                        Premises: Indicates a link that is updated automatically

Accepted Answer

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

Question 11

Case-Based Critical Thinking Questions
Case 6-2
Ryder has discovered the power of creating and viewing multiple workbooks.
Ryder wants to use a layout in which the workbooks overlap each other with all the title bars visible. Ryder opens all of the workbooks, and then he clicks the VIEW tab on the Ribbon and clicks the Arrange All button. What should he do next to obtain the desired layout?

Accepted Answer

A)  Click the Tile Horizontally option button 
B)  Click the Tile Vertically option button 
C)  Click the Overlap option button 
D)  Click the Cascade option button 
A)  Click the Tile Horizontally option button 
B)  Click the Tile Vertically option button 
C)  Click the Overlap option button 
D)  Click the Cascade option button

Question 12

If you receive a destination workbook but the source files are not included, click the ____ Link button in the Edit Links dialog box to replace the external references with the existing values.

Accepted Answer

A)  Fix 
B)  Break 
C)  Update 
D)  Check 
A)  Fix 
B)  Break 
C)  Update 
D)  Check

Question 13

If Excel successfully accessed the link and updated the values from the source document, the status in the Edit Links dialog box will be ____.

Accepted Answer

A)  Done 
B)  Completed 
C)  OK 
D)  Good 
A)  Done 
B)  Completed 
C)  OK 
D)  Good

Question 14

You can create a(n) ____ reference by deleting the $ from the row reference in the cell reference $B$6.

Accepted Answer

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

Question 15

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)  ; 
A)  (?) 
B)  ! 
C)  " 
D)  ;

Question 16

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

Accepted Answer

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

Question 17

To remove a worksheet group, you can right-click the sheet tab of a sheet in the group and then click ____ on the shortcut menu.

Accepted Answer

A)  Remove Group 
B)  No Group 
C)  Exit Group 
D)  Ungroup Sheets 
A)  Remove Group 
B)  No Group 
C)  Exit Group 
D)  Ungroup Sheets

Question 18

Match between columns
                        Premises: Indicates that a link has to be updated manually by the user

Accepted Answer

The Answer of worksheet group and source and hyperlink and is...

Question 19

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 20

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

Accepted Answer

A) True 
 B)False

Using multiple worksheets makes it easier to group and summarize data. Describe features that can be applied by forming a worksheet group.

When two files are linked together, the workbook that contains the information is the ____________________ file.

The default template places the formula results aligned to the ____ of a cell.

Case-Based Critical Thinking Questions Case 6-3 Your friend Jared asks you to help him learn more about using hyperlinks in an Excel workbook file. Which of the following statements about hyperlinks in Excel workbooks is correct?

Case-Based Critical Thinking Questions Case 6-3 Your friend Jared asks you to help him learn more about using hyperlinks in an Excel workbook file. Jared has heard that ScreenTips can be used in conjunction with hyperlinks. Which of the following statements about ScreenTips is correct?

Excel, by default, looks for template files in the Templates folder, which is where custom template files are often stored.

A formula can include a reference to another workbook (called an ____ reference), which creates a set of linked workbooks.

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

If you receive a destination workbook but the source files are not included, click the ____ Link button in the Edit Links dialog box to replace the external references with the existing values.

If Excel successfully accessed the link and updated the values from the source document, the status in the Edit Links dialog box will be ____.

You can create a(n) ____ reference by deleting the $ from the row reference in the cell reference $B$6.

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

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

To remove a worksheet group, you can right-click the sheet tab of a sheet in the group and then click ____ on the shortcut menu.

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

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

Access: Creating Advanced Queries and Enhancing Table Design

Access: Using Form Tools and Creating Custom Forms

Access: Creating Custom Reports

Access: Sharing, Integrating, and Analyzing Data

Excell: Working With Excel Tables, Pivottables, and Pivotcharts

Excell: Developing an Excel Application

Excell: Working With Advanced Functions

Powerpoint: Applying Advanced Formatting to Objects

Powerpoint: Advanced Animations and Distributing Presentations

Word: Working With Templates, Themes, and Styles

Word: Using Mail Merge

Word: Collaborating With Others and Integrating Data

Filters

Exam 6: Excell: Managing Multiple Worksheets and Workbooks

Using multiple worksheets makes it easier to group and summarize data. Describe features that can be applied by forming a worksheet group.

When two files are linked together, the workbook that contains the information is the ____________________ file.

The default template places the formula results aligned to the ____ of a cell.

Case-Based Critical Thinking Questions Case 6-3 Your friend Jared asks you to help him learn more about using hyperlinks in an Excel workbook file. Which of the following statements about hyperlinks in Excel workbooks is correct?

Case-Based Critical Thinking Questions Case 6-3 Your friend Jared asks you to help him learn more about using hyperlinks in an Excel workbook file. Jared has heard that ScreenTips can be used in conjunction with hyperlinks. Which of the following statements about ScreenTips is correct?

Excel, by default, looks for template files in the Templates folder, which is where custom template files are often stored.

A formula can include a reference to another workbook (called an ____ reference), which creates a set of linked workbooks.

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

If you receive a destination workbook but the source files are not included, click the ____ Link button in the Edit Links dialog box to replace the external references with the existing values.

If Excel successfully accessed the link and updated the values from the source document, the status in the Edit Links dialog box will be ____.

You can create a(n) ____ reference by deleting the $ from the row reference in the cell reference $B$6.

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

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

To remove a worksheet group, you can right-click the sheet tab of a sheet in the group and then click ____ on the shortcut menu.

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

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

Access: Creating Advanced Queries and Enhancing Table Design

Access: Using Form Tools and Creating Custom Forms

Access: Creating Custom Reports

Access: Sharing, Integrating, and Analyzing Data

Excell: Working With Excel Tables, Pivottables, and Pivotcharts

Excell: Developing an Excel Application

Excell: Working With Advanced Functions

Powerpoint: Applying Advanced Formatting to Objects

Powerpoint: Advanced Animations and Distributing Presentations

Word: Working With Templates, Themes, and Styles

Word: Using Mail Merge

Word: Collaborating With Others and Integrating Data

Filters