Question 1

When worksheets are grouped,what you do to one worksheet happens to the other worksheets in the group.

Accepted Answer

A) True 
 B)False

Question 2

Each of the following statements is TRUE about referencing data between worksheets EXCEPT:

Accepted Answer

A) One of Excel's more powerful features is the ability to reference data between worksheets. 
B) Multiple worksheets represent a second dimension. 
C) If you think of a worksheet as a two-dimensional array, then multiple worksheets in a workbook can be thought of as a three-dimensional array. 
D) By using a 3-D formula with 3-D references, you can easily create a summary worksheet from multiple worksheets that are updated automatically as the source data is updated. 
A) One of Excel's more powerful features is the ability to reference data between worksheets. 
B) Multiple worksheets represent a second dimension. 
C) If you think of a worksheet as a two-dimensional array, then multiple worksheets in a workbook can be thought of as a three-dimensional array. 
D) By using a 3-D formula with 3-D references, you can easily create a summary worksheet from multiple worksheets that are updated automatically as the source data is updated.

Question 3

To organize the data differently than how it is presented in the separate worksheets,but using the same row and column labels so the consolidated worksheet matches the data,use the consolidate by category option.

Accepted Answer

A) True 
 B)False

Question 4

Any Ribbon tools that are not available when worksheets are grouped will be blacked out.

Accepted Answer

A) True 
 B)False

Question 5

A 3-D named range can be defined in the Name box.

Accepted Answer

A) True 
 B)False

Question 6

Worksheets can store multiple consolidations.

Accepted Answer

A) True 
 B)False

Question 7

All of the following statements are TRUE regarding 3-D references EXCEPT:

Accepted Answer

A) A range of cells is permitted in a 3-D reference. 
B) Multiple worksheets are permitted in a 3-D reference. 
C) 3-D ranges can reference different cells across multiple worksheets. 
D) 3-D ranges cannot be defined in the Name box. 
A) A range of cells is permitted in a 3-D reference. 
B) Multiple worksheets are permitted in a 3-D reference. 
C) 3-D ranges can reference different cells across multiple worksheets. 
D) 3-D ranges cannot be defined in the Name box.

Question 8

Ungrouping worksheets is accomplished by right-clicking a grouped worksheet tab and selecting Ungroup Sheets from the ________.

Accepted Answer

A) shortcut menu 
B) command menu 
C) task menu 
D) options menu 
A) shortcut menu 
B) command menu 
C) task menu 
D) options menu

Question 9

When you have data on multiple worksheets and want to consolidate that data into a summary worksheet,you can use a 2-D formula.

Accepted Answer

A) True 
 B)False

Question 10

Links to workbooks are easily broken,especially if files are moved or deleted.

Accepted Answer

A) True 
 B)False

Question 11

When Excel displays ________ in a cell,this generally means that the reference to a value could not be found,such as a matching result in a VLOOKUP function.

Accepted Answer

The answer of When Excel displays ________ in a cell,this...

Question 12

Excel 2013 addresses linked workbooks using ________ addresses.

Accepted Answer

The answer of Excel 2013 addresses linked workbooks using ________...

Question 13

If a workbook contains multiple worksheets that contain either an identical structure or data with identical row and column labels,a user can create a summary worksheet using the ________ feature.

Accepted Answer

The answer of If a workbook contains multiple worksheets that...

Question 14

The two ways worksheet data can be consolidated include ________.

Accepted Answer

A) consolidate by category or consolidate by type 
B) consolidate by type or consolidate by position 
C) consolidate by position or consolidate by group 
D) consolidate by category or consolidate by position 
A) consolidate by category or consolidate by type 
B) consolidate by type or consolidate by position 
C) consolidate by position or consolidate by group 
D) consolidate by category or consolidate by position

Question 15

The Name Manager dialog box can be opened by clicking the Name Manager button in the Defined Names group on the ________ tab.

Accepted Answer

The answer of The Name Manager dialog box can be...

Question 16

Entering information into grouped worksheets is a very efficient way to simultaneously create page titles and column and row headings in multiple worksheets.

Accepted Answer

A) True 
 B)False

Question 17

All of the following statements are TRUE regarding the Compare and Merge Workbooks command EXCEPT:

Accepted Answer

A) You can merge workbooks that are not shared. 
B) You can only merge a shared workbook with copies of that workbook that were made from the same shared workbook. 
C) The shared workbooks must have unique file names different from the original workbook. 
D) All copies of the shared workbooks should be saved in the same folder as the shared workbook. 
A) You can merge workbooks that are not shared. 
B) You can only merge a shared workbook with copies of that workbook that were made from the same shared workbook. 
C) The shared workbooks must have unique file names different from the original workbook. 
D) All copies of the shared workbooks should be saved in the same folder as the shared workbook.

Question 18

When multiple worksheets are grouped,the pasted range cannot ________ the copied range in any dimension.

Accepted Answer

The answer of When multiple worksheets are grouped,the pasted range...

Question 19

Changes to data referenced in their source workbook can be reflected in your data when you open your workbook.

Accepted Answer

A) True 
 B)False

Question 20

A 3-D reference allows formulas and functions to use data from cells and cell ranges across worksheets.

Accepted Answer

A) True 
 B)False

When worksheets are grouped,what you do to one worksheet happens to the other worksheets in the group.

Each of the following statements is TRUE about referencing data between worksheets EXCEPT:

To organize the data differently than how it is presented in the separate worksheets,but using the same row and column labels so the consolidated worksheet matches the data,use the consolidate by category option.

Any Ribbon tools that are not available when worksheets are grouped will be blacked out.

A 3-D named range can be defined in the Name box.

Worksheets can store multiple consolidations.

All of the following statements are TRUE regarding 3-D references EXCEPT:

Ungrouping worksheets is accomplished by right-clicking a grouped worksheet tab and selecting Ungroup Sheets from the ________.

When you have data on multiple worksheets and want to consolidate that data into a summary worksheet,you can use a 2-D formula.

Links to workbooks are easily broken,especially if files are moved or deleted.

When Excel displays ________ in a cell,this generally means that the reference to a value could not be found,such as a matching result in a VLOOKUP function.

Excel 2013 addresses linked workbooks using ________ addresses.

If a workbook contains multiple worksheets that contain either an identical structure or data with identical row and column labels,a user can create a summary worksheet using the ________ feature.

The two ways worksheet data can be consolidated include ________.

The Name Manager dialog box can be opened by clicking the Name Manager button in the Defined Names group on the ________ tab.

Entering information into grouped worksheets is a very efficient way to simultaneously create page titles and column and row headings in multiple worksheets.

All of the following statements are TRUE regarding the Compare and Merge Workbooks command EXCEPT:

When multiple worksheets are grouped,the pasted range cannot ________ the copied range in any dimension.

Changes to data referenced in their source workbook can be reflected in your data when you open your workbook.

A 3-D reference allows formulas and functions to use data from cells and cell ranges across worksheets.

Navigate, manipulate, and Print Worksheets

Formatting, functions, and Formulas

Cell References, named Ranges, and Functions

Effective Charts

Complex Conditional and Retrieval Functions

Analyze Data Using Tables

Refine an Excel Application

Organize, import, export, and Cleanse Data Sets

Data Tables, scenario Manager, and Solver

Loan Amortization, investment Analysis, and Asset Depreciation

Business Statistics and Regression Analysis

Excels Data Model, Power-pivot, and Power View

Visual Basic for Applications

Appendix:efficient Interaction With a Touch Screen

The Common Features of Microsoft Office

Filters

Exam 7: Multiple Worksheets workbooks and Templates

When worksheets are grouped,what you do to one worksheet happens to the other worksheets in the group.

Each of the following statements is TRUE about referencing data between worksheets EXCEPT:

To organize the data differently than how it is presented in the separate worksheets,but using the same row and column labels so the consolidated worksheet matches the data,use the consolidate by category option.

Any Ribbon tools that are not available when worksheets are grouped will be blacked out.

A 3-D named range can be defined in the Name box.

Worksheets can store multiple consolidations.

All of the following statements are TRUE regarding 3-D references EXCEPT:

Ungrouping worksheets is accomplished by right-clicking a grouped worksheet tab and selecting Ungroup Sheets from the ________.

When you have data on multiple worksheets and want to consolidate that data into a summary worksheet,you can use a 2-D formula.

Links to workbooks are easily broken,especially if files are moved or deleted.

When Excel displays ________ in a cell,this generally means that the reference to a value could not be found,such as a matching result in a VLOOKUP function.

Excel 2013 addresses linked workbooks using ________ addresses.

If a workbook contains multiple worksheets that contain either an identical structure or data with identical row and column labels,a user can create a summary worksheet using the ________ feature.

The two ways worksheet data can be consolidated include ________.

The Name Manager dialog box can be opened by clicking the Name Manager button in the Defined Names group on the ________ tab.

Entering information into grouped worksheets is a very efficient way to simultaneously create page titles and column and row headings in multiple worksheets.

All of the following statements are TRUE regarding the Compare and Merge Workbooks command EXCEPT:

When multiple worksheets are grouped,the pasted range cannot ________ the copied range in any dimension.

Changes to data referenced in their source workbook can be reflected in your data when you open your workbook.

A 3-D reference allows formulas and functions to use data from cells and cell ranges across worksheets.

Navigate, manipulate, and Print Worksheets

Formatting, functions, and Formulas

Cell References, named Ranges, and Functions

Effective Charts

Complex Conditional and Retrieval Functions

Analyze Data Using Tables

Refine an Excel Application

Organize, import, export, and Cleanse Data Sets

Data Tables, scenario Manager, and Solver

Loan Amortization, investment Analysis, and Asset Depreciation

Business Statistics and Regression Analysis

Excels Data Model, Power-pivot, and Power View

Visual Basic for Applications

Appendix:efficient Interaction With a Touch Screen

The Common Features of Microsoft Office

Filters