Question 1

Using a(n)________ is best suited to monitor the changes in a cell as input value update.

Accepted Answer

Watch Window

Question 2

To edit or remove a hyperlink:

Accepted Answer

A) left-click it,and then select Edit Hyperlink to open the Edit Hyperlink dialog box. 
B) right-click it,and then click Delete. 
C) right-click it and then select Edit Hyperlink to open the Edit Hyperlink dialog box. 
D) double-click it and then click Delete. 
A) left-click it,and then select Edit Hyperlink to open the Edit Hyperlink dialog box. 
B) right-click it,and then click Delete. 
C) right-click it and then select Edit Hyperlink to open the Edit Hyperlink dialog box. 
D) double-click it and then click Delete. C

Question 3

By default automatic updates of links are ________.

Accepted Answer

disabled

Question 4

In the formula =B2*B3 is located in cell C3,which cell is the dependent cell?

Accepted Answer

A) B2 
B) B3 
C) C3 
D) C1 
A) B2 
B) B3 
C) C3 
D) C1

Question 5

3-D formulas automatically update when data is added.

Accepted Answer

A) True 
 B)False

Question 6

When information is chosen as the error style using data validation,the user will be able to input the incorrect data.

Accepted Answer

A) True 
 B)False

Question 7

Match between columns
                        Premises: Destination file
Logic error
Syntax error
Source file
Hyperlink

Accepted Answer

The Answer of The result of a syntactically correct formula is...

Question 8

Which of the following is not a way to remove panes from a window that has been split?

Accepted Answer

A) Double-click the split bar 
B) Drag a vertical split bar to the left or right edge of the worksheet window 
C) Click Split in the Window group 
D) Click Remove Split in the View tab 
A) Double-click the split bar 
B) Drag a vertical split bar to the left or right edge of the worksheet window 
C) Click Split in the Window group 
D) Click Remove Split in the View tab

Question 9

The #DIV/0! error indicates a misspelled word in Excel.

Accepted Answer

A) True 
 B)False

Question 10

When using the tracer arrows cell with errors have ________ arrows.

Accepted Answer

The answer of When using the tracer arrows cell with...

Question 11

Visited hyperlinks in Excel appear as:

Accepted Answer

A) blue text. 
B) black text. 
C) yellow text. 
D) purple text. 
A) blue text. 
B) black text. 
C) yellow text. 
D) purple text.

Question 12

When is the input message displayed in a cell that contains a validation rule?

Accepted Answer

A) When the user violates a rule 
B) When the cell is clicked 
C) When the workbook is opened 
D) When the cell is double-clicked 
A) When the user violates a rule 
B) When the cell is clicked 
C) When the workbook is opened 
D) When the cell is double-clicked

Question 13

By default,Excel creates absolute cell references in external references.

Accepted Answer

A) True 
 B)False

Question 14

When worksheets are grouped which of the following actions will not occur across all worksheets?

Accepted Answer

A) Data entry 
B) Structural changes 
C) Formatting 
D) Conditional formatting 
A) Data entry 
B) Structural changes 
C) Formatting 
D) Conditional formatting

Question 15

The error ________ will display when a formula attempts to divide a value by zero or an empty cell.

Accepted Answer

The answer of The error ________ will display when a...

Question 16

If the destination file is closed when you change data in the source file,the destination file does automatically update to match the source file.

Accepted Answer

A) True 
 B)False

Question 17

If a workbook that is referenced is lost or moved the error ________ will be displayed.

Accepted Answer

Error: Sou

Question 18

What auditing tool is best used to monitor the changes in a cell over time?

Accepted Answer

A) Trace precedents 
B) Watch Window 
C) Trace dependents 
D) Formula bar 
A) Trace precedents 
B) Watch Window 
C) Trace dependents 
D) Formula bar

Question 19

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

Accepted Answer

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

Question 20

What formula auditing tool can be used to control the data input from the user?

Accepted Answer

A) IFERROR 
B) Data validation 
C) Watch Window 
D) Trace dependents 
A) IFERROR 
B) Data validation 
C) Watch Window 
D) Trace dependents

Exam 34: Multiple Sheet Workbook Management

Using a(n)________ is best suited to monitor the changes in a cell as input value update.

To edit or remove a hyperlink:

By default automatic updates of links are ________.

In the formula =B2*B3 is located in cell C3,which cell is the dependent cell?

3-D formulas automatically update when data is added.

When information is chosen as the error style using data validation,the user will be able to input the incorrect data.

Which of the following is not a way to remove panes from a window that has been split?

The #DIV/0! error indicates a misspelled word in Excel.

When using the tracer arrows cell with errors have ________ arrows.

Visited hyperlinks in Excel appear as:

When is the input message displayed in a cell that contains a validation rule?

By default,Excel creates absolute cell references in external references.

When worksheets are grouped which of the following actions will not occur across all worksheets?

The error ________ will display when a formula attempts to divide a value by zero or an empty cell.

If the destination file is closed when you change data in the source file,the destination file does automatically update to match the source file.

If a workbook that is referenced is lost or moved the error ________ will be displayed.

What auditing tool is best used to monitor the changes in a cell over time?

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

What formula auditing tool can be used to control the data input from the user?

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