Question 1

Each of the following statements is TRUE regarding multiple worksheets EXCEPT:

Accepted Answer

A) Data can be accessed between worksheets using 2-D references. 
B) Multiple worksheets can be formatted at the same time. 
C) Data from multiple worksheets can be referenced to generate new data via formulas or functions. 
D) Data can be copied and pasted from one worksheet to another. 
A) Data can be accessed between worksheets using 2-D references. 
B) Multiple worksheets can be formatted at the same time. 
C) Data from multiple worksheets can be referenced to generate new data via formulas or functions. 
D) Data can be copied and pasted from one worksheet to another.

Question 2

A 3-D reference has the following structure: ________.

Accepted Answer

A) =worksheet name?cell reference 
B) ="worksheet name!cell reference" 
C) =worksheet name!cell reference 
D) ='worksheet name!'cell reference 
A) =worksheet name?cell reference 
B) ="worksheet name!cell reference" 
C) =worksheet name!cell reference 
D) ='worksheet name!'cell reference

Question 3

If workbook A is linked to workbook B,workbook A must be closed when shared copies of workbook B are created in order to prevent the references in workbook A from being automatically changed to reference the new files.

Accepted Answer

A) True 
 B)False

Question 4

Conditional formatting is an Excel feature that can be used when worksheets are grouped.

Accepted Answer

A) True 
 B)False

Question 5

You can select multiple files to compare and merge by using the ________ key when selecting file names.

Accepted Answer

The answer of You can select multiple files to compare...

Question 6

Match between columns
                        Premises: Name Box arrow
Worksheet
Fill Across Worksheets
3-D named range
Multiple worksheets in a workbook

Accepted Answer

The Answer of References the same cell,or range of cells,across is...

Question 7

All of the following statements are TRUE regarding collaboration EXCEPT:

Accepted Answer

A) Collaboration allows workbooks to be shared among different users and then merged together for a final product. 
B) All features, such as merged cells and conditional formats, are available and can be changed even once the workbook is shared. 
C) When a workbook is shared, you can save additional copies of your workbook for distribution to other users. 
D) Each user has their own settings, or custom view, saved of the workbook that allows you to save print settings and any filters you may have created. 
A) Collaboration allows workbooks to be shared among different users and then merged together for a final product. 
B) All features, such as merged cells and conditional formats, are available and can be changed even once the workbook is shared. 
C) When a workbook is shared, you can save additional copies of your workbook for distribution to other users. 
D) Each user has their own settings, or custom view, saved of the workbook that allows you to save print settings and any filters you may have created.

Question 8

The ________ extension is used for an Excel 2013 template.

Accepted Answer

A) .xlst 
B) .xltx 
C) .xlt 
D) .xltp 
A) .xlst 
B) .xltx 
C) .xlt 
D) .xltp

Question 9

Match between columns
                        Premises: 3-D references
Conditional formatting
Grouping
Data
Shift

Accepted Answer

The Answer of Multiple worksheets selected at the same time is...

Question 10

A 2-D named range references the same cell or range of cells across multiple worksheets in a workbook.

Accepted Answer

A) True 
 B)False

Question 11

The correct 3-D reference used to specify cell range B2 through B15 in the Sheet1 worksheet is ________.

Accepted Answer

The answer of The correct 3-D reference used to specify...

Question 12

It is considered good practice to store all workbooks in a linked relationship together in the same ________.

Accepted Answer

The answer of It is considered good practice to store...

Question 13

________ templates are stored in the Program Files\Microsoft Office\Templates\1033 folder.

Accepted Answer

The answer of ________ templates are stored in the Program...

Question 14

References that address data across multiple worksheets are called ________ references.

Accepted Answer

A) 3-D 
B) multi-content 
C) composite 
D) compound 
A) 3-D 
B) multi-content 
C) composite 
D) compound

Question 15

Input Across Worksheets can be used to copy cell contents,formats,or contents and formats (All)to worksheets in a group.

Accepted Answer

A) True 
 B)False

Question 16

Microsoft users,through its template site at Office.com,can rate templates on a scale of 1 to 5 ________.

Accepted Answer

The answer of Microsoft users,through its template site at Office.com,can...

Question 17

To group contiguous worksheet tabs,the user clicks the worksheet tab at one end of the contiguous tabs,holds down ________,and clicks the worksheet tab on the other end of the contiguous tabs.

Accepted Answer

A) End 
B) Alt 
C) Ctrl 
D) Shift 
A) End 
B) Alt 
C) Ctrl 
D) Shift

Question 18

Each of the following statements is TRUE about working with multiple workbooks EXCEPT:

Accepted Answer

A) Working with multiple workbooks is very similar to working with multiple worksheets. 
B) Excel 2013 opens each workbook in the same window. 
C) Data can be referenced between workbooks using 3-D ranges and formulas, so when the source workbook is updated, the changes flow through to the summary workbook. 
D) Users can choose whether or not to link workbooks to make the updating automatic or not. 
A) Working with multiple workbooks is very similar to working with multiple worksheets. 
B) Excel 2013 opens each workbook in the same window. 
C) Data can be referenced between workbooks using 3-D ranges and formulas, so when the source workbook is updated, the changes flow through to the summary workbook. 
D) Users can choose whether or not to link workbooks to make the updating automatic or not.

Question 19

Each of the following statements is TRUE regarding copying and pasting data across worksheets EXCEPT:

Accepted Answer

A) Data can be copied from a single worksheet into grouped worksheets. 
B) Data can be copied from one set of grouped worksheets and then pasted into the same or a different set of grouped sheets. 
C) The new location must have room available such that the pasted range has exactly the same shape as the copied range. 
D) When multiple worksheets are grouped, the pasted range can overlap the copied range in any dimension. 
A) Data can be copied from a single worksheet into grouped worksheets. 
B) Data can be copied from one set of grouped worksheets and then pasted into the same or a different set of grouped sheets. 
C) The new location must have room available such that the pasted range has exactly the same shape as the copied range. 
D) When multiple worksheets are grouped, the pasted range can overlap the copied range in any dimension.

Question 20

All of the following statements are TRUE regarding templates EXCEPT:

Accepted Answer

A) A template is the framework of a worksheet. 
B) A template automatically applies formatting depending upon the workbook's contents. 
C) A template provides structural data such as column headings and data labels. 
D) A template provides necessary formulas. 
A) A template is the framework of a worksheet. 
B) A template automatically applies formatting depending upon the workbook's contents. 
C) A template provides structural data such as column headings and data labels. 
D) A template provides necessary formulas.

Each of the following statements is TRUE regarding multiple worksheets EXCEPT:

A 3-D reference has the following structure: ________.

If workbook A is linked to workbook B,workbook A must be closed when shared copies of workbook B are created in order to prevent the references in workbook A from being automatically changed to reference the new files.

Conditional formatting is an Excel feature that can be used when worksheets are grouped.

You can select multiple files to compare and merge by using the ________ key when selecting file names.

All of the following statements are TRUE regarding collaboration EXCEPT:

The ________ extension is used for an Excel 2013 template.

A 2-D named range references the same cell or range of cells across multiple worksheets in a workbook.

The correct 3-D reference used to specify cell range B2 through B15 in the Sheet1 worksheet is ________.

It is considered good practice to store all workbooks in a linked relationship together in the same ________.

________ templates are stored in the Program Files\Microsoft Office\Templates\1033 folder.

References that address data across multiple worksheets are called ________ references.

Input Across Worksheets can be used to copy cell contents,formats,or contents and formats (All)to worksheets in a group.

Microsoft users,through its template site at Office.com,can rate templates on a scale of 1 to 5 ________.

To group contiguous worksheet tabs,the user clicks the worksheet tab at one end of the contiguous tabs,holds down ________,and clicks the worksheet tab on the other end of the contiguous tabs.

Each of the following statements is TRUE about working with multiple workbooks EXCEPT:

Each of the following statements is TRUE regarding copying and pasting data across worksheets EXCEPT:

All of the following statements are TRUE regarding templates EXCEPT:

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

Each of the following statements is TRUE regarding multiple worksheets EXCEPT:

A 3-D reference has the following structure: ________.

If workbook A is linked to workbook B,workbook A must be closed when shared copies of workbook B are created in order to prevent the references in workbook A from being automatically changed to reference the new files.

Conditional formatting is an Excel feature that can be used when worksheets are grouped.

You can select multiple files to compare and merge by using the ________ key when selecting file names.

All of the following statements are TRUE regarding collaboration EXCEPT:

The ________ extension is used for an Excel 2013 template.

A 2-D named range references the same cell or range of cells across multiple worksheets in a workbook.

The correct 3-D reference used to specify cell range B2 through B15 in the Sheet1 worksheet is ________.

It is considered good practice to store all workbooks in a linked relationship together in the same ________.

________ templates are stored in the Program Files\Microsoft Office\Templates\1033 folder.

References that address data across multiple worksheets are called ________ references.

Input Across Worksheets can be used to copy cell contents,formats,or contents and formats (All)to worksheets in a group.

Microsoft users,through its template site at Office.com,can rate templates on a scale of 1 to 5 ________.

To group contiguous worksheet tabs,the user clicks the worksheet tab at one end of the contiguous tabs,holds down ________,and clicks the worksheet tab on the other end of the contiguous tabs.

Each of the following statements is TRUE about working with multiple workbooks EXCEPT:

Each of the following statements is TRUE regarding copying and pasting data across worksheets EXCEPT:

All of the following statements are TRUE regarding templates EXCEPT:

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