Question 1

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 2

Images can be used as hyperlinks

Accepted Answer

A) True 
 B)False

Question 3

In Excel,hyperlinks appear as:

Accepted Answer

A) blue text with a blue underline. 
B) red text with a blue underline. 
C) black text. 
D) blue text with a black underline. 
A) blue text with a blue underline. 
B) red text with a blue underline. 
C) black text. 
D) blue text with a black underline.

Question 4

The Watch Window will update as user defined cells change.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is not an option when arranging windows?

Accepted Answer

A) Tiled 
B) Horizontal 
C) Stacked 
D) Cascade 
A) Tiled 
B) Horizontal 
C) Stacked 
D) Cascade

Question 6

Dependent cells contain formulas independent of other cells.

Accepted Answer

A) True 
 B)False

Question 7

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

Which of the following is the proper format for a 3-D reference?

Accepted Answer

A) Worksheet Name!RangeOfCells 
B) 'Worksheet Name'!RangeOfCells 
C) "Worksheet Name"!RangeOfCells 
D) 'Worksheet Name!RangeOfCells' 
A) Worksheet Name!RangeOfCells 
B) 'Worksheet Name'!RangeOfCells 
C) "Worksheet Name"!RangeOfCells 
D) 'Worksheet Name!RangeOfCells'

Question 9

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

Accepted Answer

The Answer of Circles invalid text as defined by data is...

Question 10

In the formula =C3*C5 in which the results are displayed in cell C6,________ is the dependent cell.

Accepted Answer

The answer of In the formula =C3*C5 in which the...

Question 11

When worksheets are grouped ________ appears in the title bar.

Accepted Answer

The answer of When worksheets are grouped ________ appears in...

Question 12

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 13

Unvisited hyperlinks appear blue with a blue underline.

Accepted Answer

A) True 
 B)False

Question 14

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

OctoberSales.xlsx is an example of CamelCase notation.

Accepted Answer

A) True 
 B)False

Question 16

When using the tracer arrows cell with no errors have ________ arrows.

Accepted Answer

The answer of When using the tracer arrows cell with...

Question 17

________ is/are a set of tools that enable you to display or trace relationships for formula cells,show formulas,check for errors,and evaluate formulas.

Accepted Answer

The answer of ________ is/are a set of tools that...

Question 18

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 19

A ________ is a file that that contains original data that you need elsewhere.

Accepted Answer

The answer of A ________ is a file that that...

Question 20

The IFERROR function will perform an action if the current value in a cell produces an error.

Accepted Answer

A) True 
 B)False

Exam 34: Multiple Sheet Workbook Management

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

Images can be used as hyperlinks

In Excel,hyperlinks appear as:

The Watch Window will update as user defined cells change.

Which of the following is not an option when arranging windows?

Dependent cells contain formulas independent of other cells.

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

Which of the following is the proper format for a 3-D reference?

In the formula =C3*C5 in which the results are displayed in cell C6,________ is the dependent cell.

When worksheets are grouped ________ appears in the title bar.

Which of the following is not a formula auditing tool?

Unvisited hyperlinks appear blue with a blue underline.

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

OctoberSales.xlsx is an example of CamelCase notation.

When using the tracer arrows cell with no errors have ________ arrows.

________ is/are a set of tools that enable you to display or trace relationships for formula cells,show formulas,check for errors,and evaluate formulas.

What error will cause #NUM! to appear?

A ________ is a file that that contains original data that you need elsewhere.

The IFERROR function will perform an action if the current value in a cell produces an error.

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