Question 1

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 2

What is the difference between a precedent and dependent cell?

Accepted Answer

Every formula is a relationship comprise

Question 3

3-D formulas automatically update when data is added.

Accepted Answer

A) True 
 B)False

Question 4

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

Question 5

________ 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 6

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

Accepted Answer

Error: Sou

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

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

Accepted Answer

A) True 
 B)False

Question 9

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

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 12

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

Accepted Answer

A) True 
 B)False

Question 13

________ 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 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

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 16

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

Accepted Answer

The Answer of An error that occurs because a formula is...

Question 17

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 18

If the formula =B2*B3 is located in cell C3,which cell is not a precedent?

Accepted Answer

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

Question 19

By default automatic updates of links are disabled.

Accepted Answer

A) True 
 B)False

Question 20

By default automatic updates of links are ________.

Accepted Answer

The answer of By default automatic updates of links are...

Exam 26: Excel : Multiple-Sheet Workbook Management

To group nonadjacent worksheet tabs:

What is the difference between a precedent and dependent cell?

3-D formulas automatically update when data is added.

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

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

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

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?

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

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

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

This should be used when referencing cells on another worksheet.

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

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

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?

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

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

If the formula =B2*B3 is located in cell C3,which cell is not a precedent?

By default automatic updates of links are disabled.

By default automatic updates of links are ________.

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