Question 1

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 2

________ is/are not supported when worksheets are grouped.

Accepted Answer

Conditiona

Question 3

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 4

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

Accepted Answer

The Answer of Cells that are referenced in a formula is...

Question 5

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 6

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 7

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

Accepted Answer

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

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

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

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 12

Images can be used as hyperlinks

Accepted Answer

A) True 
 B)False

Question 13

________ is the process of selecting two or more worksheets.

Accepted Answer

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

Question 14

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 15

________ errors are the result of a syntactically correct formula but logically incorrect construction,which produces inaccurate results.

Accepted Answer

The answer of ________ errors are the result of a...

Question 16

What are the benefits of grouping worksheets?

Accepted Answer

Grouping worksheets gives the ability to

Question 17

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 18

________ is the process of dividing a worksheet window into two or four resizable windows.

Accepted Answer

The answer of ________ is the process of dividing a...

Question 19

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 20

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)

Exam 26: Excel : Multiple-Sheet Workbook Management

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

________ is/are not supported when worksheets are grouped.

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 is the best method to consolidate three workbooks into another workbook?

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

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

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

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

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

To group all worksheets:

Images can be used as hyperlinks

________ is the process of selecting two or more worksheets.

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

________ errors are the result of a syntactically correct formula but logically incorrect construction,which produces inaccurate results.

What are the benefits of grouping worksheets?

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

________ is the process of dividing a worksheet window into two or four resizable windows.

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

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

Office Fundamentals and File Management

Word: Document Presentation: Editing and Formatting

Word: Document Productivity: Working With Tables and Mail Merge

Word: Collaboration and Research: Communicating and Producing Professional Papers

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

Word: Time Saving Tools: Using Templates, multiple Documents, and Themes

Word: Document Automation: Forms,macros,and Security

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

Power: Introduction to Powerpoint: Creating a Basic Presentation

Power: Presentation Development: Planning and Preparing a Presentation

Power: Presentation Design: Illustrations and Infographics

Power: Powerpoint Rich Media Tools: Enhancing With Multimedia

Power: Infographics: Creating Text Charts, tables, and Graphs

Power: Interactivity and Advanced Animation: Engaging the Audience

Power: Customization: Customizing Powerpoint and the Slide Show

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

Excel: Introduction to Excel: What Is a Spreadsheet

Excel: Formulas and Functions: Performing Quantitative Analysis

Excel : Charts: Depicting Data Visually

Excel: Datasets and Tables: Managing Large Volumes of Data

Excel: Subtotals, Pivot-tables, and Pivot-charts

Excel : What-If Analysis

Excel: Specialized Functions

Excel: Statistical Functions

Excel: Imports, web Queries, and Xml

Excel : Collaboration and Workbook Distribution

Excel: Templates, styles, and Macros

Access : Introduction to Access: Finding Your Way Through an Access Database

Access: Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Access: Customize,analyze,and Summarize Query Data: Creating and Using Queries to Make Decisions

Access: Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

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

Access : Action and Specialized Queries: Moving Beyond the Select Query

Access: Advanced Forms and Reports: Moving Beyond the Basics

Access: Get Connected: Exchanging Data Between Access and Other Applications

Access: Fine-Tuning the Database: Analyzing and Improving Database Performance

Filters