Question 1

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 2

Unvisited hyperlinks appear blue with a blue underline.

Accepted Answer

A) True 
 B)False

Question 3

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 4

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

Accepted Answer

A) True 
 B)False

Question 5

The Watch Window will update as user defined cells change.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Match between columns
                        Premises: Stop style
Circle text
Warning style
Information style
Data Validation

Accepted Answer

The Answer of Accepts invalid data but warns user that is...

Question 8

What error will cause #NUM! to appear?

Accepted Answer

A) Invalid arguments in a function 
B) Misspelled name 
C) Deleted cell reference 
D) Invalid range name 
A) Invalid arguments in a function 
B) Misspelled name 
C) Deleted cell reference 
D) Invalid range name

Question 9

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

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 12

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 13

Which of the following is not a formula auditing tool?

Accepted Answer

A) Trace Precedents 
B) Watch Window 
C) Calculation Options 
D) Trace Dependents 
A) Trace Precedents 
B) Watch Window 
C) Calculation Options 
D) Trace Dependents

Question 14

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 15

Which of the following cannot be accessed via a hyperlink in Excel?

Accepted Answer

A) External workbook 
B) Different worksheet 
C) Web page 
D) Another program 
A) External workbook 
B) Different worksheet 
C) Web page 
D) Another program

Question 16

________ is a logical function that checks a cell to determine if that cell contains an error or if a
formula will result in an error.

Accepted Answer

The answer of ________ is a logical function that checks...

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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.

Question 19

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

Question 20

Dependent cells contain formulas independent of other cells.

Accepted Answer

A) True 
 B)False

Exam 26: Excel : Multiple-Sheet Workbook Management

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

Unvisited hyperlinks appear blue with a blue underline.

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

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

The Watch Window will update as user defined cells change.

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

What error will cause #NUM! to appear?

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

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

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.

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 formula auditing tool?

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

Which of the following cannot be accessed via a hyperlink in Excel?

________ is a logical function that checks a cell to determine if that cell contains an error or if a formula will result in an error.

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

To edit or remove a hyperlink:

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

Dependent cells contain formulas independent of other cells.

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