Question 1

Match between columns
                        Premises: External reference
Grouping
Ungrouping
3-d reference
Split bar

Accepted Answer

The Answer of A pointer to a cell in another is...

Question 2

Conditional formatting can be applied to a set of grouped worksheets.

Accepted Answer

A) True 
 B)False  False

Question 3

When a stop is chosen as the error style using data validation,the user will not be able to continue.

Accepted Answer

A) True 
 B)False  True

Question 4

Match between columns
                        Premises: [Indianapolis.xlsx]Qtr3!A1
'[South Bend.xlsx]Qtr3'!A1
'[Bloomington.xlsx]Qtr 3 Sales'!A1
'c : \Data[Indianapolis.xlsx]Sheet1'!A1
B3

Accepted Answer

The Answer of External reference in which Worksheet name contains is...

Question 5

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

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

Accepted Answer

A) True 
 B)False

Question 7

When worksheets are grouped ________ appears in the title bar.

Accepted Answer

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

Question 8

OctoberSales.xlsx is an example of CamelCase notation.

Accepted Answer

A) True 
 B)False

Question 9

A________ is a pointer to a cell in another worksheet.

Accepted Answer

The answer of A________ is a pointer to a cell...

Question 10

Which of the following would cause the error #VALUE! to appear?

Accepted Answer

A) Misspelled word 
B) Deleted cell reference 
C) Incorrect data used in an argument 
D) Invalid range name 
A) Misspelled word 
B) Deleted cell reference 
C) Incorrect data used in an argument 
D) Invalid range name

Question 11

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 12

The split bar gives the user the ability to view two different workbooks simultaneously.

Accepted Answer

A) True 
 B)False

Question 13

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 14

When worksheets are grouped,which of the following is true?

Accepted Answer

A) [Group] appears in the title bar 
B) The worksheets are locked 
C) A lock appears in the title bar 
D) The worksheets cannot be edited 
A) [Group] appears in the title bar 
B) The worksheets are locked 
C) A lock appears in the title bar 
D) The worksheets cannot be edited

Question 15

To ungroup worksheets:

Accepted Answer

A) click a worksheet tab for a sheet that is not grouped. 
B) press Esc. 
C) click Ungroup on the Formulas tab. 
D) click Ungroup on the Data tab. 
A) click a worksheet tab for a sheet that is not grouped. 
B) press Esc. 
C) click Ungroup on the Formulas tab. 
D) click Ungroup on the Data tab.

Question 16

When a(n)________ style error alert is used,the user will be able to enter data even if it violates the data validation rule.

Accepted Answer

The answer of When a(n)________ style error alert is used,the...

Question 17

Match between columns
                        Premises: #VALUE!
#NUM!
IFERROR
#REF!
#N/A

Accepted Answer

The Answer of A logical function that checks a cell is...

Question 18

Match between columns
                        Premises: =IFERROR(D2/E2,"Error in data")
Precedent
[Indianapolis.xlsx]Qtr3!A1
=SUM(''Qtr1:Qtr4''!E3)
Watch Window

Accepted Answer

The Answer of 3-D Formula and Cells that are referenced is...

Question 19

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 20

Visited hyperlinks in Excel appear as:

Accepted Answer

A) blue text. 
B) black text. 
C) yellow text. 
D) purple text. 
A) blue text. 
B) black text. 
C) yellow text. 
D) purple text.

Exam 26: Excel : Multiple-Sheet Workbook Management

Conditional formatting can be applied to a set of grouped worksheets.

When a stop is chosen as the error style using data validation,the user will not be able to continue.

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

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

When worksheets are grouped ________ appears in the title bar.

OctoberSales.xlsx is an example of CamelCase notation.

A________ is a pointer to a cell in another worksheet.

Which of the following would cause the error #VALUE! to appear?

In Excel,hyperlinks appear as:

The split bar gives the user the ability to view two different workbooks simultaneously.

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

When worksheets are grouped,which of the following is true?

To ungroup worksheets:

When a(n)________ style error alert is used,the user will be able to enter data even if it violates the data validation rule.

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

Visited hyperlinks in Excel appear as:

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