Deck 6: Excel: Managing Multiple Worksheets and Workbooks

Question 1

A worksheet cluster is a collection of several worksheets.

Answer 1

False

Question 2

If the destination file is closed when you make a change in the source file you choose whether to update the link to display the current values when you open the destination file or continue to display the older values from the destination file.

Answer 2

True

Question 3

Excel will prompt you to update the source file link when you initially open the destination file.

Answer 3

True

Question 4

When using 3-D formulas to summarize data across worksheets if you change the value in one worksheet the result of the formulas that reference that cell will automatically show the result of the change.

Question 5

If two workbooks are located in the same folder you still need to include the location information in the workbook reference that links the two files.

Question 6

The name of the sheet range is a required component in 3-D cell references.

Question 7

If you delete a value from one cell values in that cell will be deleted in all sheets in the group.

Question 8

You can enter 3-D references by using your mouse to select the appropriate worksheet cells in the workbook.

Question 9

When you use a template you can make any changes you want to the workbook without affecting the template file.

Question 10

The workspace file contains the location and name of the file as well as the actual workbooks and worksheets.

Question 11

You cannot move worksheets without making 3-D references inaccurate.

Question 12

If you use the mouse to enter a 3-D reference you must first select the cell range followed by the sheet range.

Question 13

In Excel 2007 if you want to publish interactive versions of your workbook or items from the worksheet as a Web page with spreadsheet functionality you need to use a component of Microsoft Office Share-Point Server called MHTML Services.

Question 14

If both the destination and source files are open Excel will prompt you to update the link with the source file.

Question 15

Excel has some templates that are automatically installed on your hard disk.

Question 16

Once you group a collection of worksheets any changes you make to one worksheet are applied to all sheets in the group.

Question 17

If a worksheet group includes all the worksheets in a workbook you can edit only the active worksheet.

Question 18

A workbook based on a specific template always displays the name of the template followed by a sequential number.

Question 19

If you use a template once when you next open a blank workbook based on the template its original settings will still be present.

Question 20

Using multiple worksheets makes it more difficult for you to group your data.

Question 21

Consolidated workbooks help you standardize the appearance and content of workbooks.

Question 22

To select nonadjacent worksheets you use the ____ key.

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

Question 23

Plans reports schedules and budgets are all categories of tasks available on Microsoft Office Online

Question 24

A worksheet ____ is a collection of two or more selected worksheets.

A)index
B)roster
C)group
D)cluster

Question 25

To select nonadjacent worksheets you click a sheet tab of one of the worksheets and then press and hold down the Shift key as you click the sheet tabs of other worksheets you want included in the group.

Question 26

To select adjacent worksheets you use the ____ key.

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

Question 27

You copy formulas with 3-D references the same way you copy other formulas-using copy and paste or AutoFill.

Question 28

When you use the point-and-click method to build formulas with external references Excel enters all of the required punctuation except quotation marks.

Question 29

A(n)dialog is a connection between two files allowing information to be transferred from one file to the other.

Question 30

Rather than laboriously retyping the same formulas across a series of worksheets you can enter them all at once by creating a worksheet ____.

A)index
B)roster
C)group
D)cluster

Question 31

Like cell ____ a worksheet group can contain adjacent or nonadjacent sheets.

A)controls
B)groups
C)tabs
D)ranges

Question 32

The item indicated in the accompanying figure is the Security Bar .

Question 33

When the destination file is closed and the source files are closed the complete file path is included as part of the external reference formula that appears in the formula bar.

Question 34

When you apply the Comma Style number format to a cell range the values in the range will appear with a(n)decimal point and no comma .

Question 35

The default template contains the default formatting you start out with in every new workbook including labels aligned to the left side of a cell.

Question 36

In order to reference data located in one workbook in another workbook you have to create a(n)dialog between the two workbooks.

Question 37

In the dialog box shown in the accompanying figure the source file type of the files is Excel worksheet .

Question 38

A blank workbook you can open with the text formats and formulas already built into it is called a(n)spreadsheet .

Question 39

If Excel has not attempted to update the links in a given session the Edit Links dialog box will show the status of the links as not checked .

Question 40

As with inserting formulas and text any formatting changes you make to a single sheet in a(n)group are applied to all sheets.

Question 41

A link is a connection between two ____ allowing information to be transferred from one to the other.

A)cells
B)ranges
C)columns
D)files

Question 42

If you cannot see the sheet tab of a worksheet you want to include in a group use the sheet ____ controls to display it.

A)index
B)roster
C)navigation
D)cluster

Question 43

To ungroup worksheets you can click a sheet ____ of a sheet not in the group.

A)index
B)panel
C)tab
D)pane

Question 44

The worksheet range ____ references the worksheets "Sheet1 " "Sheet2 " "Sheet3 " and "Sheet4."

A)Sheet1_Sheet4
B)Sheet1-Sheet4
C)Sheet1:Sheet4
D)Sheet1\Sheet4

Question 45

The active worksheet in a group is indicated by ____ text.

A)bold
B)italicized
C)underlined
D)red

Question 46

To move a worksheet or worksheet group to another location in the same workbook select the worksheets and then drag and drop them by the selected sheet ____.

A)tabs
B)indices
C)keys
D)icons

Question 47

If a sheet range includes more than one sheet you specify the first and last sheet in the range separated by a ____.

A)colon
B)semicolon
C)comma
D)plus sign

Question 48

Which caption indicates a worksheet group?

A)[Worksheets]
B)[Selected Sheets]
C)[Group]
D)[Workgroup]

Question 49

If you need to use data located in one workbook in the other workbook you have to create a(n)____ between the two workbooks.

A)anchor
B)source
C)link
D)index

Question 50

A(n)____ cell reference specifies not only the rows and columns of a cell range but also the names of the worksheets on which the cells appear.

A)indexed
B)relational
C)absolute
D)3-D

Question 51

To add total sales from two worksheets-cell B10 of the Domestic worksheet and cell B8 of the International worksheet-you would enter the formula ____.

A)=Domestic;B10 + International;B8
B)=Domestic"B10 + International"B8
C)=Domestic!B10 + International!B8
D)=Domestic?B10 + International?B8

Question 52

When you reference a cell or range in a different worksheet the ____ separates the sheet reference from the cell reference.

A)?
B)!
C)"
D);

Question 53

To remove a worksheet group you can right-click the sheet tab of a sheet in the group and then click ____ on the shortcut menu.

A)Remove Group
B)No Group
C)Exit Group
D)Ungroup Sheets

Question 54

When you reference cells and ranges in other worksheets if the worksheet name contains spaces you must enclose the sheet name in ____.

A)braces
B)brackets
C)parentheses
D)single quotation marks

Question 55

When a worksheet group is selected the ____ includes text to indicate this.

A)title bar
B)worksheet bar
C)status bar
D)formula bar

Question 56

Which of the following Custom Header buttons adds the worksheet name to the top of each page?

A)Customize Worksheet
B)Add Filename
C)Insert Sheet Name
D)Customize Header

Question 57

Which of the following formulas is correct given a sheet named Sales Data?

A)(Sales Data)!D10
B)[Sales Data]!D10
C)'Sales Data'!D10
D){Sales Data}!D10

Question 58

Which of the following adds the values in cell B21 on the worksheets between Sheet1 and Sheet4?

A)=SUM(Sheet1-Sheet4!B21)
B)=SUM(Sheet1:Sheet4!B21)
C)=SUM(Sheet1 Sheet2 Sheet3 Sheet4!B21)
D)=SUM(Sheet1_Sheet4!B21)

Question 59

You can set up the page layout and print area for all the worksheets in a workbook by selecting a worksheet group and then accessing the ____ dialog box.

A)Print
B)Print Layout
C)Page Setup
D)Page Layout

Question 60

The general format of a 3-D cell reference is ____.

A)CellRange!WorksheetRange
B)WorksheetRange!CellRange
C)WorkbookRange!CellRange
D)CellRange!WorkbookRange

Question 61

If you break a link how do you undo the action?

A)Press Ctrl+Z
B)Use the Undo command on the Edit menu
C)Retype the external reference formulas
D)Either A or B

Question 62

Click the button marked ____ in the accompanying figure to replace the link to a source file with the current values for the linked cells.

A)1
B)2
C)3
D)None of the above

Question 63

The ____ arrangement option layers the open workbooks on the screen.

A)Cascade
B)Horizontal
C)Tiled
D)Lateral

Question 64

A workspace saves all of the following information about the currently opened workbooks EXCEPT ____.

A)locations
B)window sizes
C)zoom magnifications
D)formats used

Question 65

If you trust the provider of source files you can choose to ____ the content which allows the external reference formulas to function and updates the links in the destination workbook.

A)enable
B)embed
C)concatenate
D)consolidate

Question 66

The Edit Links list in the accompanying figure indicates the type of each ____ file.

A)destination
B)origin
C)subject
D)source

Question 67

Once you update values in Excel the dialog box in the accompanying figure displays the text ____ for links that are acting correctly and that have been updated in this session.

A)UPD
B)DONE
C)OK
D)NEW

Question 68

Formulas created using the point-and-click method contains ____ references.

A)absolute
B)mixed
C)relative
D)relational

Question 69

Click the button marked ____ in the accompanying figure if you want to locate the source file and repair broken links.

A)1
B)2
C)3
D)4

Question 70

Click the button marked ____ in the accompanying figure to find out whether Excel has attempted to update the links in this session.

A)1
B)2
C)3
D)4

Question 71

If the destination file is closed when you make a change in the ____ file you can choose whether to update the link to display the current values when you open the destination file.

A)target
B)origin
C)source
D)key

Question 72

The ____ dialog box lists all of the links in the current workbook.

A)Show Links
B)Edit Links
C)Link and Embed
D)Paste Special

Question 73

In the Edit Links dialog box in the accompanying figure ____ indicates that links are updated automatically.

A)Update Values
B)Automatic
C)A
D)UPD

Question 74

To update all of the M links in a workbook select the links in the Edit Links dialog box and click the button marked ____ in the accompanying figure.

A)1
B)2
C)3
D)4

Question 75

If you want to create a cell reference to the range B5:E5 on the Summary Info worksheet of the Sales.xls workbook you would use the following external reference: ____.

A)'[Sales.xlsx]Summary Info'\B5:E5
B)'(Sales.xlsx)Summary Info'!B5:E5
C)'[Sales.xlsx]Summary Info'!B5:E5
D)'[Sales.xlsx]Summary Info'!B5:E5

Question 76

When two workbooks are ____ it is important that the data in the destination file accurately reflects the contents of the source file.

A)linked
B)embedded
C)concatenated
D)consolidated

Question 77

Which of the following is NOT an option for arranging your workbooks?

A)tiled
B)cascade
C)horizontal
D)lateral

Question 78

In the Edit Links dialog box in the accompanying figure ____ indicates that a link has to be updated manually by the user.

A)M
B)A
C)U
D)UPD

Question 79

You can create a(n)____ reference by deleting the $ from the row reference in the cell reference $B$6.

A)mixed
B)absolute
C)relative
D)indexed

Question 80

The general form of an external reference is ____ where Path is the path of the workbook file on the computer or network Workbook Name is the filename of the workbook and Sheet Range and Cell Range are worksheets and cells in the workbook respectively.

A)(WorkbookName)WorksheetName!CellRange
B)[WorkbookName]WorksheetName!CellRange
C)[WorkbookName]WorksheetName!CellRange
D)\WorkbookName\WorksheetName\CellRange