Deck 7: Multiple Worksheets workbooks and Templates

Question 1

Which of the following statements regarding worksheet data consolidation is NOT TRUE?

A)Consolidated data cannot be created unless the worksheets have identical row and/or column labels.
B)Consolidated data can be used to create a summary worksheet.
C)Links are not required when creating consolidated data.
D)Consolidated data can be generated from multiple worksheets with an identical structure.

Answer 1

A

Question 2

The ________ feature of Excel greatly increases user efficiency by enabling actions such as data entry to be performed on multiple worksheets at one time.

A)linking
B)grouping
C)bridging
D)merging

Answer 2

B

Question 3

The entire ________ tab is NOT available when worksheets are grouped.

A)Insert
B)Data
C)Review
D)View

Answer 3

B

Question 4

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

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 5

Each of the following statements is TRUE regarding filling contents across worksheets EXCEPT:

A)Fill Across Worksheets will only fill to the same location in different worksheets.
B)Fill Across Worksheets is a command that can be used to copy cell contents, formats, or both contents and formats to worksheets in a group.
C)The source and destination worksheets must all be included in the group.
D)When using Fill Across Worksheets, the decision of whether to fill All, Contents, or Formats is dependent on what exactly you need to copy.

Question 6

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

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

Question 7

The two ways worksheet data can be consolidated include ________.

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 8

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

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 9

If you want to summarize data from multiple places and want to arrange the data in all the worksheets in identical order and location,you would use the ________ option.

A)consolidate by category
B)consolidate by formula
C)PivotTable report
D)consolidate by position

Question 10

If you want to summarize data from multiple places and want to organize the data differently than how it is presented in the separate worksheets,but use the same row and column labels so the consolidated worksheet matches the data,you would use the ________ option.

A)consolidate by position
B)consolidate by formula
C)consolidate by category
D)PivotTable report

Question 11

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

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 12

Which of the following features of Excel is available when worksheets are grouped?

A)Sparklines
B)Charts
C)Functions
D)Shapes

Question 13

The Fill Across Worksheets feature of Excel is located on the HOME tab in the ________ group.

A)Insert
B)Editing
C)Styles
D)Cells

Question 14

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

A)Grouped worksheets make the entry of worksheet structural elements like titles, column headings, and row labels fast and efficient.
B)Errors made, such as misspellings or misplacement of a heading, are compounded across all grouped worksheets.
C)If you forget to ungroup worksheets, you can quickly create more work than you saved by grouping worksheets in the first place.
D)When worksheets are grouped, the Undo command is disabled.

Question 15

Fill Across Worksheets ________ should be used when the target worksheet(s)contain(s)contents the user does not want to overwrite.

A)styles
B)layouts
C)formats
D)setups

Question 16

Any Ribbon tools not available when worksheets are grouped will be ________.

A)grayed out
B)highlighted
C)underlined
D)italicized

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.

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

Question 18

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

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

Question 19

If you want to summarize data from multiple places and want to use formulas with cell references or 3-D references to the other worksheets that you are combining because you do not have a consistent position or category of data to use,you would use the ________ option.

A)consolidate by formula
B)consolidate by position
C)consolidate by category
D)PivotTable report

Question 20

Which of the following CANNOT be performed on grouped worksheets sharing similar structures?

A)Entering column and row headings
B)Entering formulas
C)Applying conditional formatting
D)Entering functions

Question 21

The ________ extension is used for an Excel 2013 template.

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

Question 22

Multiple worksheets can be selected at the same time and actions such as data entry and formatting can affect all the worksheets in the group at once,greatly increasing efficiency.

Question 23

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

Question 24

Templates are readily available through the ________ tab when creating a new workbook.

A)File
B)Home
C)Insert
D)Data

Question 25

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

Question 26

All of the following statements are TRUE regarding templates EXCEPT:

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.

Question 27

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

Question 28

All of the following statements are TRUE regarding collaboration EXCEPT:

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 29

All of the following statements are TRUE regarding linked workbooks EXCEPT:

A)Changes to data referenced in its source workbook can be reflected in the data of the destination workbook.
B)Links to workbooks are difficult to break.
C)When opening a linked workbook, users are given the choice whether or not to update links.
D)It is wise to store all workbooks in a linked relationship together in the same folder.

Question 30

A worksheet can store ________ consolidation(s).

A)one
B)two
C)three
D)unlimited

Question 31

An Excel ________ is a workbook that provides a starting point for building other similar workbooks.

A)template
B)pattern
C)master
D)outline

Question 32

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

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 33

A 3-D range can be defined by clicking Define Name in the Defined Names group of the ________ tab.

A)Home
B)Insert
C)Formulas
D)Data

Question 34

All of the following statements are TRUE about tracking changes EXCEPT:

A)As long as workbooks are shared, you can view the changes made and continue making changes to the shared workbooks.
B)Change history is information that is maintained about all changes made in past editing sessions to the shared workbook.
C)When you save the workbook, the History worksheet will be hidden and you will have to use the Track Changes options to add the History worksheet again.
D)Once you stop sharing the workbook, the change history will remain intact.

Question 35

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

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 36

Excel addresses linked workbooks by using ________ addresses.

A)relative
B)absolute
C)comparative
D)bound

Question 37

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

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 38

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

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

Question 39

The ________ error will appear if VLOOKUP attempts to reference linked table data in another workbook that is NOT open.

A)#N/A!
B)#ERROR!
C)#VALUE!
D)#REF!

Question 40

Ungrouping worksheets is accomplished by either right-clicking a grouped worksheet tab and selecting Ungroup Sheets from the shortcut menu,or by clicking the [Group] tag on the title bar.

Question 41

When data is consolidated and links to the source data are included,the consolidation will not be automatically updated when changes are made to the source data.

Question 42

While VLOOKUP can reference linked table data in another workbook,it cannot do so unless the workbook that contains the table is closed.

Question 43

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

Question 44

A primary advantage of the ability to reference data in multiple workbooks is that you can access data at its source in its original location.

Question 45

To arrange the data in all the worksheets in identical order and location,use the consolidate by position option.

Question 46

Worksheets can store multiple consolidations.

Question 47

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.

Question 48

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

Question 49

A data consolidation that contains links to source data includes the cell references for cells from other worksheets that contributed to a consolidated data result.

Question 50

Excel 2013 addresses linked workbooks using absolute addresses,where prior versions of Excel used relative addresses.

Question 51

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

Question 52

Conditional formatting cannot be directly applied to grouped worksheets.

Question 53

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

Question 54

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

Question 55

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

Question 56

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

Question 57

When using Fill Across Worksheets,the user can fill by one of two options,Contents or Format.

Question 58

To enter unique data,formulas and information in worksheets,the worksheets cannot be grouped.

Question 59

A 3-D reference has the following structure: ='worksheet name!'cell reference.

Question 60

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

Question 61

Built-in templates are accessed from the Home tab by clicking the New tab.

Question 62

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

Question 63

Any workbook can be used as a template for another workbook by simply opening that workbook and saving it with the template extension.

Question 64

________ is a command that can be used to copy cell contents,formats,or both contents and formats to worksheets in a group.

Question 65

3-D references allow formulas and functions to utilize data from cells and cell ranges across ________.

Question 66

The Excel template extension is .xlt.

Question 67

A(n)________ references the same cell,or range of cells,across multiple worksheets in a workbook.

Question 68

Multiple worksheets can be selected at the same time and actions such as data entry and formatting can affect all the worksheets in the group at once,greatly increasing ________.

Question 69

A(n)3-D ________ references the same cell,or range of cells,across multiple worksheets in a workbook.

Question 70

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.

Question 71

A template is a special file type that identifies multiple workbooks and remembers the manner in which the workbooks should be arranged.

Question 72

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

Question 73

Consolidate by ________ can be used to create a summary worksheet when the source worksheets all have an identical structure.

Question 74

Change history is information that is maintained about all changes made in past editing sessions to the shared workbooks.

Question 75

Consolidation by ________ is more flexible than consolidation by position.

Question 76

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

Question 77

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.

Question 78

Filling formats across ________ should be used when the target worksheet(s)contain(s)content that the user does not want to overwrite.

Question 79

A(n)________ named range cannot be defined in the Name box.

Question 80

Any ________ tools that are not available when worksheets are grouped will be grayed out.