Question 1

Which of the following is true when synchronize scrolling is enabled?

Accepted Answer

A) Side by side worksheets will scroll at the same rate 
B) Side by side worksheets will scroll at a different rate 
C) Side by side worksheets will not scroll 
D) Side by side worksheets are locked 
A) Side by side worksheets will scroll at the same rate 
B) Side by side worksheets will scroll at a different rate 
C) Side by side worksheets will not scroll 
D) Side by side worksheets are locked

Question 2

When a(n)________ style error alert is used,the user will be able to enter data even if it violates the data validation rule.

Accepted Answer

The answer of When a(n)________ style error alert is used,the...

Question 3

The #NUM! error indicates an invalid argument used in a function.

Accepted Answer

A) True 
 B)False

Question 4

Match between columns
                        Premises: Dependents
IFERROR
Precedents
Formula auditing
Watch Window

Accepted Answer

The Answer of Enables you to create a small window is...

Question 5

Which of the following functions does not contain a syntax error?

Accepted Answer

A) =avg(B1:B9) 
B) =AVERAG(B1:B9) 
C) =AVERAGE(B1;B9) 
D) =AVERAGE(B1:B9) 
A) =avg(B1:B9) 
B) =AVERAG(B1:B9) 
C) =AVERAGE(B1;B9) 
D) =AVERAGE(B1:B9)

Question 6

________ enables you to control the data that can be entered into a cell.

Accepted Answer

The answer of ________ enables you to control the data...

Question 7

What is indicated by blue arrows when tracing precedents?

Accepted Answer

A) Cells with errors 
B) Cells with validation rules 
C) Cells with no errors 
D) Cells with comments 
A) Cells with errors 
B) Cells with validation rules 
C) Cells with no errors 
D) Cells with comments

Question 8

What is indicated by red arrows when tracing precedents?

Accepted Answer

A) Cells that cause errors 
B) Cells with validation rules 
C) Cells with no errors 
D) Cells with comments 
A) Cells that cause errors 
B) Cells with validation rules 
C) Cells with no errors 
D) Cells with comments

Question 9

What is the best method to consolidate three workbooks into another workbook?

Accepted Answer

A) Copy and paste 
B) External cell references 
C) 3-D formulas 
D) Web query 
A) Copy and paste 
B) External cell references 
C) 3-D formulas 
D) Web query

Question 10

Which function is best used to return a value if an error exists in a cell?

Accepted Answer

A) IF 
B) GETERROR 
C) IFERROR 
D) VALIDATE 
A) IF 
B) GETERROR 
C) IFERROR 
D) VALIDATE

Question 11

Match between columns
                        Premises: Unhide
Grouping
Hide
Ungrouping
Fill across worksheet

Accepted Answer

The Answer of Copy new data or formatting across several is...

Question 12

Worksheets can be hidden to help manage available screen space when dealing with large files.

Accepted Answer

A) True 
 B)False

Question 13

Match between columns
                        Premises: #NUM
#NAME?
#NULL!
#N/A
#DIV/0!

Accepted Answer

The Answer of Incorrect range separator Formula requires cell ranges is...

Question 14

To group adjacent worksheets:

Accepted Answer

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

Question 15

Which of the following functions does not contain a logic error?

Accepted Answer

A) =IF(0>0,"yes"."no") 
B) =IF(B5>B5,"yes","no") 
C) =IF(B6/0>C6/0,"yes","no") 
D) =IF(B6>C6,"Yes","No") 
A) =IF(0>0,"yes"."no") 
B) =IF(B5>B5,"yes","no") 
C) =IF(B6/0>C6/0,"yes","no") 
D) =IF(B6>C6,"Yes","No")

Question 16

Which of the following would cause the error #DIV/0! to appear?

Accepted Answer

A) Misspelled word 
B) Formula attempts to divide a value by zero or an empty cell 
C) Invalid range name 
D) Invalid arguments in the function 
A) Misspelled word 
B) Formula attempts to divide a value by zero or an empty cell 
C) Invalid range name 
D) Invalid arguments in the function

Question 17

A 3-D reference is a pointer to a cell in another worksheet.

Accepted Answer

A) True 
 B)False

Question 18

What are the benefits of grouping worksheets?

Accepted Answer

Grouping worksheets gives the ability to

Question 19

Match between columns
                        Premises: IFERROR
#N/A
#VALUE!
#REF!
#NUM!

Accepted Answer

The Answer of A logical function that checks a cell is...

Question 20

Which of the following is not a data validation stop style?

Accepted Answer

A) Lookup 
B) Stop 
C) Warning 
D) Information 
A) Lookup 
B) Stop 
C) Warning 
D) Information

Exam 34: Multiple Sheet Workbook Management

Which of the following is true when synchronize scrolling is enabled?

When a(n)________ style error alert is used,the user will be able to enter data even if it violates the data validation rule.

The #NUM! error indicates an invalid argument used in a function.

Which of the following functions does not contain a syntax error?

________ enables you to control the data that can be entered into a cell.

What is indicated by blue arrows when tracing precedents?

What is indicated by red arrows when tracing precedents?

What is the best method to consolidate three workbooks into another workbook?

Which function is best used to return a value if an error exists in a cell?

Worksheets can be hidden to help manage available screen space when dealing with large files.

To group adjacent worksheets:

Which of the following functions does not contain a logic error?

Which of the following would cause the error #DIV/0! to appear?

A 3-D reference is a pointer to a cell in another worksheet.

What are the benefits of grouping worksheets?

Which of the following is not a data validation stop style?

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