Question 1

Match between columns
                        Premises: Data validation
Error style
Error alert
Input message
Validation criteria

Accepted Answer

The Answer of Rules that dictate the type of data is...

Question 2

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

Accepted Answer

The Answer of Restrict the view of a worksheet making is...

Question 3

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 4

In the formula =B2*B3 is located in cell C3,which cell is the dependent cell?

Accepted Answer

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

Question 5

________ is a file containing a pointer to receive data from the source files.

Accepted Answer

The answer of ________ is a file containing a pointer...

Question 6

When worksheets are grouped which of the following actions will not occur across all worksheets?

Accepted Answer

A) Data entry 
B) Structural changes 
C) Formatting 
D) Conditional formatting 
A) Data entry 
B) Structural changes 
C) Formatting 
D) Conditional formatting

Question 7

What auditing tool is best used to monitor the changes in a cell over time?

Accepted Answer

A) Trace precedents 
B) Watch Window 
C) Trace dependents 
D) Formula bar 
A) Trace precedents 
B) Watch Window 
C) Trace dependents 
D) Formula bar

Question 8

Using a(n)________ is best suited to monitor the changes in a cell as input value update.

Accepted Answer

The answer of Using a(n)________ is best suited to monitor...

Question 9

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 10

NovemberFile.xlsx is an example of ________.

Accepted Answer

The answer of NovemberFile.xlsx is an example of ________....

Question 11

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

Accepted Answer

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

Question 12

When arranging windows,tiled is not an option.

Accepted Answer

A) True 
 B)False

Question 13

When a worksheet is split,any changes made to one pane updates the entire worksheet.

Accepted Answer

A) True 
 B)False

Question 14

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 15

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

Accepted Answer

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

Question 16

What happens if you rename the source file of a worksheet that is used in an external reference?

Accepted Answer

A) The link will automatically update 
B) A prompt to manually update the link appears 
C) The linked data will appear in red text 
D) The workbook will not open 
A) The link will automatically update 
B) A prompt to manually update the link appears 
C) The linked data will appear in red text 
D) The workbook will not open

Question 17

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 18

To remove a hyperlink,right-click it,and then select Link Options.

Accepted Answer

A) True 
 B)False

Question 19

What are the benefits of using 3-D formulas?

Accepted Answer

3-D formulas give the user the ability t

Question 20

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

Accepted Answer

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

Exam 26: Excel : Multiple-Sheet Workbook Management

To group adjacent worksheets:

In the formula =B2*B3 is located in cell C3,which cell is the dependent cell?

________ is a file containing a pointer to receive data from the source files.

When worksheets are grouped which of the following actions will not occur across all worksheets?

What auditing tool is best used to monitor the changes in a cell over time?

Using a(n)________ is best suited to monitor the changes in a cell as input value update.

What is indicated by blue arrows when tracing precedents?

NovemberFile.xlsx is an example of ________.

When arranging windows,tiled is not an option.

When a worksheet is split,any changes made to one pane updates the entire worksheet.

What is indicated by red arrows when tracing precedents?

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

What happens if you rename the source file of a worksheet that is used in an external reference?

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

To remove a hyperlink,right-click it,and then select Link Options.

What are the benefits of using 3-D formulas?

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

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