Question 1

To remove a hyperlink,right-click it,and then select Link Options.

Accepted Answer

A) True 
 B)False

Question 2

When worksheets are grouped all structural changes will be copied across worksheets.

Accepted Answer

A) True 
 B)False

Question 3

When opening a second window of the current workbook :
2 will appear after the title.

Accepted Answer

A) True 
 B)False

Question 4

If defined by the user,an optional ________ appears when the mouse pointer hovers over a hyperlink.

Accepted Answer

The answer of If defined by the user,an optional ________...

Question 5

The split bar gives the user the ability to view two different workbooks simultaneously.

Accepted Answer

A) True 
 B)False

Question 6

A________ is a pointer to a cell in another worksheet.

Accepted Answer

The answer of A________ is a pointer to a cell...

Question 7

All of the following could produce a #NAME?
Error with the exception of which one?

Accepted Answer

A) Misspelled word 
B) Invalid range name 
C) Invalid arguments in a function 
D) Invalid function name 
A) Misspelled word 
B) Invalid range name 
C) Invalid arguments in a function 
D) Invalid function name

Question 8

A hyperlink cannot be used to access an e-mail address.

Accepted Answer

A) True 
 B)False

Question 9

By default automatic updates of links are disabled.

Accepted Answer

A) True 
 B)False

Question 10

''[South Bend.xlsx]Qtr3''!A1 is an example of a (n)________.

Accepted Answer

The answer of ''[South Bend.xlsx]Qtr3''!A1 is an example of a...

Question 11

Which of the following would cause the error #VALUE! to appear?

Accepted Answer

A) Misspelled word 
B) Deleted cell reference 
C) Incorrect data used in an argument 
D) Invalid range name 
A) Misspelled word 
B) Deleted cell reference 
C) Incorrect data used in an argument 
D) Invalid range name

Question 12

When worksheets are grouped,which of the following is true?

Accepted Answer

A) [Group] appears in the title bar 
B) The worksheets are locked 
C) A lock appears in the title bar 
D) The worksheets cannot be edited 
A) [Group] appears in the title bar 
B) The worksheets are locked 
C) A lock appears in the title bar 
D) The worksheets cannot be edited

Question 13

________ is the process of selecting two or more worksheets.

Accepted Answer

The answer of ________ is the process of selecting two...

Question 14

Which of the following functions cannot be used as a 3-D formula?

Accepted Answer

A) SUM 
B) PMT 
C) AVERAGE 
D) MAX 
A) SUM 
B) PMT 
C) AVERAGE 
D) MAX

Question 15

________ errors occur because a formula or function violates correct construction,such as a misspelled function name or illegal use of an operator.

Accepted Answer

The answer of ________ errors occur because a formula or...

Question 16

Which of the following actions will open another window of the current workbook?

Accepted Answer

A) Click the Formulas tab,and then click New Window in the Manage group 
B) Click the View tab,and then click New Window in the Window group 
C) Click the Data tab,and then click New Window in the Manage group 
D) Click the View tab,and then click New Window in the Manage group 
A) Click the Formulas tab,and then click New Window in the Manage group 
B) Click the View tab,and then click New Window in the Window group 
C) Click the Data tab,and then click New Window in the Manage group 
D) Click the View tab,and then click New Window in the Manage group

Question 17

What happens if a user violates a validation rule and a stop style is applied?

Accepted Answer

A) The user will not be able to continue 
B) The user will be able to continue 
C) The user can choose to ignore the error 
D) The user will be able to edit the rule 
A) The user will not be able to continue 
B) The user will be able to continue 
C) The user can choose to ignore the error 
D) The user will be able to edit the rule

Question 18

Match between columns
                        Premises: =IFERROR(D2/E2,"Error in data")
=SUM(''Qtr1:Qtr4''!E3)
Watch Window
[Indianapolis.xlsx]Qtr3!A1
Precedent

Accepted Answer

The Answer of IFERROR function and Enables you to create is...

Question 19

The error ________ will display when an invalid argument is used in a function.

Accepted Answer

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

Question 20

NovemberFile.xlsx is an example of ________.

Accepted Answer

The answer of NovemberFile.xlsx is an example of ________....

Exam 34: Multiple Sheet Workbook Management

To remove a hyperlink,right-click it,and then select Link Options.

When worksheets are grouped all structural changes will be copied across worksheets.

When opening a second window of the current workbook : 2 will appear after the title.

If defined by the user,an optional ________ appears when the mouse pointer hovers over a hyperlink.

The split bar gives the user the ability to view two different workbooks simultaneously.

A________ is a pointer to a cell in another worksheet.

All of the following could produce a #NAME? Error with the exception of which one?

A hyperlink cannot be used to access an e-mail address.

By default automatic updates of links are disabled.

''[South Bend.xlsx]Qtr3''!A1 is an example of a (n)________.

Which of the following would cause the error #VALUE! to appear?

When worksheets are grouped,which of the following is true?

________ is the process of selecting two or more worksheets.

Which of the following functions cannot be used as a 3-D formula?

________ errors occur because a formula or function violates correct construction,such as a misspelled function name or illegal use of an operator.

Which of the following actions will open another window of the current workbook?

What happens if a user violates a validation rule and a stop style is applied?

The error ________ will display when an invalid argument is used in a function.

NovemberFile.xlsx is an example of ________.

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