Question 1

When arranging windows,tiled is not an option.

Accepted Answer

A) True 
 B)False

Question 2

________ is a file containing a pointer to receive data from the source files.

Accepted Answer

The answer of ________ is a file containing a pointer...

Question 3

Match between columns
                        Premises: B3
'[Bloomington.xlsx]Qtr 3 Sales'!A1
'c :\Data[Indianapolis.xlsx]Sheet1'!A1
[Indianapolis.xlsx]Qtr3!A1
'[South Bend.xlsx]Qtr3'!A1

Accepted Answer

The Answer of External reference in which Workbook and worksheet is...

Question 4

A ________ is an electronic marker that connects to another location.

Accepted Answer

The answer of A ________ is an electronic marker that...

Question 5

________ is/are not supported when worksheets are grouped.

Accepted Answer

Conditiona

Question 6

What are the benefits of using 3-D formulas?

Accepted Answer

3-D formulas give the user the ability t

Question 7

What is the proper format for creating an external reference with no spaces in the file name located in the same folder as the destination file?

Accepted Answer

A) [WorkbookName]"WorksheetName"!RangeOfCells 
B) [WorkbookName]'WorksheetName'!RangeOfCells 
C) WorksheetName!RangeOfCells 
D) [WorkbookName]WorksheetName!RangeOfCells 
A) [WorkbookName]"WorksheetName"!RangeOfCells 
B) [WorkbookName]'WorksheetName'!RangeOfCells 
C) WorksheetName!RangeOfCells 
D) [WorkbookName]WorksheetName!RangeOfCells

Question 8

When a worksheet is split,any changes made to one pane updates the entire worksheet.

Accepted Answer

A) True 
 B)False

Question 9

What happens if you rename the source file of a worksheet that is used in an external reference?

Accepted Answer

A) The link will automatically update 
B) A prompt to manually update the link appears 
C) The linked data will appear in red text 
D) The workbook will not open 
A) The link will automatically update 
B) A prompt to manually update the link appears 
C) The linked data will appear in red text 
D) The workbook will not open

Question 10

To group all worksheets:

Accepted Answer

A) right-click a cell and select All. 
B) click Group on the Data tab. 
C) right-click a worksheet tab and click Select All Sheets. 
D) click Group on the View tab. 
A) right-click a cell and select All. 
B) click Group on the Data tab. 
C) right-click a worksheet tab and click Select All Sheets. 
D) click Group on the View tab.

Question 11

To group nonadjacent worksheet tabs:

Accepted Answer

A) right-click a worksheet tab and click Select All Sheets. 
B) click Group on the View tab. 
C) click the first worksheet tab,press and hold Shift,and then click the last worksheet tab. 
D) click the first worksheet tab,press and hold Ctrl,and then click each additional worksheet tab. 
A) right-click a worksheet tab and click Select All Sheets. 
B) click Group on the View tab. 
C) click the first worksheet tab,press and hold Shift,and then click the last worksheet tab. 
D) click the first worksheet tab,press and hold Ctrl,and then click each additional worksheet tab.

Question 12

To ungroup worksheets:

Accepted Answer

A) click a worksheet tab for a sheet that is not grouped. 
B) press Esc. 
C) click Ungroup on the Formulas tab. 
D) click Ungroup on the Data tab. 
A) click a worksheet tab for a sheet that is not grouped. 
B) press Esc. 
C) click Ungroup on the Formulas tab. 
D) click Ungroup on the Data tab.

Question 13

When a stop is chosen as the error style using data validation,the user will not be able to continue.

Accepted Answer

A) True 
 B)False

Question 14

What is the proper format of an external reference to a workbook or worksheet thats name contains spaces;source and destination files are in the same folder?

Accepted Answer

A) ''[WorkbookName]Worksheet''!Cell 
B) Worksheet'!Cell 
C) [WorkbookName]Worksheet!Cell 
D) '[WorkbookName]Worksheet'!Cell 
A) ''[WorkbookName]Worksheet''!Cell 
B) Worksheet'!Cell 
C) [WorkbookName]Worksheet!Cell 
D) '[WorkbookName]Worksheet'!Cell

Question 15

Match between columns
                        Premises: Validation criteria
Data validation
Input message
Error alert
Error style

Accepted Answer

The Answer of Descriptive text or instructions for data entry is...

Question 16

This should be used when referencing cells on another worksheet.

Accepted Answer

A) Function 
B) Reference 
C) Formula 
D) 3-D reference 
A) Function 
B) Reference 
C) Formula 
D) 3-D reference

Question 17

Conditional formatting can be applied to a set of grouped worksheets.

Accepted Answer

A) True 
 B)False

Question 18

The VLOOKUP function can be used to create a 3-D formula.

Accepted Answer

A) True 
 B)False

Question 19

What happens when data that is externally linked is edited and both the source and destination file are open?

Accepted Answer

A) The links will automatically update 
B) The links will not update 
C) A security prompt appears 
D) There will be no change 
A) The links will automatically update 
B) The links will not update 
C) A security prompt appears 
D) There will be no change

Question 20

Match between columns
                        Premises: External reference
3-d reference
Split bar
Ungrouping
Grouping

Accepted Answer

The Answer of A link between source and destination files is...

Exam 34: Multiple Sheet Workbook Management

When arranging windows,tiled is not an option.

________ is a file containing a pointer to receive data from the source files.

A ________ is an electronic marker that connects to another location.

________ is/are not supported when worksheets are grouped.

What are the benefits of using 3-D formulas?

What is the proper format for creating an external reference with no spaces in the file name located in the same folder as the destination file?

When a worksheet is split,any changes made to one pane updates the entire worksheet.

What happens if you rename the source file of a worksheet that is used in an external reference?

To group all worksheets:

To group nonadjacent worksheet tabs:

To ungroup worksheets:

When a stop is chosen as the error style using data validation,the user will not be able to continue.

What is the proper format of an external reference to a workbook or worksheet thats name contains spaces;source and destination files are in the same folder?

This should be used when referencing cells on another worksheet.

Conditional formatting can be applied to a set of grouped worksheets.

The VLOOKUP function can be used to create a 3-D formula.

What happens when data that is externally linked is edited and both the source and destination file are open?

Subtotals, Pivot-tables, and Pivot-charts: Hands-On-Exercise Videos

Desktop Publishing and Graphic Design: Hands On Exercise Videos

Desktop Publishing and Graphic Design: Creating a Newsletter working With Graphics and Linking Objects

Infographics: Creating Text Charts, tables, and Graphs

Subtotals Pivot-tables and Pivot-charts

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Infographics: Hands On Exercise Videos

Data Validation and Data Analysis: Hands On Exercise Videos

What If Analysis: Hands On Exercise Videos

Time Saving Tools: Hands On Exercise Videos

Time Saving Tools: Using Templates multiple Documents and Themes

Interactivity and Advanced Animation: Engaging the Audience

What If Analysis

Action and Specialized Queries: Moving Beyond the Select Query

Interactivity and Advanced Animation: Hands On Exercise Videos

Action and Specialized Queries: Hands On Exercise Videos

Specialized Functions: Hands On Exercise Videos

Document Automation: Hands On Exercise Videos

Document Automation: Forms, macros, and Security

Customization: Customizing Powerpoint and the Slide Show

Specialized Functions

Advanced Forms and Reports: Moving Beyond the Basics

Customization: Hands On Exercise Videos

Advanced Forms and Reports: Hands On Exercise Videos

Statistical Functions: Hands On Exercise Videos

Word and the Internet: Hands On Exercise Videos

Word and the Internet: Web Page Creation and Enhancement and Blogs

Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation

Statistical Functions

Get Connected: Exchanging Data Between Access and Other Applications

Collaboration and Distribution: Hands On Exercise Videos

Get Connected: Hands On Exercise Videos

Multiple Sheet Workbook Management: Hands On Exercise Videos

Fine Tuning the Database: Analyzing and Improving Database Performance

Fine Tuning the Database: Hands On Exercise Videos

Imports, web Queries, and XML: Hands-On-Exercise Videos

Imports, web Queries, and XML

Using Macros and SQL in Access: Advanced Techniques

Using Macros and SQL in Access: Hands On Exercise Videos

Collaboration and Workbook Distribution: Hands On Exercise Videos

Collaboration and Workbook Distribution

Templates styles and Macros

Templates, styles, and Macros: Hands-On-Exercise Videos

Filters