Deck 6: Managing Multiple Worksheets and Workbooks

Question 1

A template can use most Excel features except macros.

Answer 1

False

Question 2

If you delete a value from one cell,the content is also deleted from the same cell in all the worksheets in the group.

Answer 2

True

Question 3

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

Answer 3

False

Question 4

To delete the data values,you can also click the Clear button in the Editing group on the Home tab,and then click Clear Contents.

Question 5

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

Question 6

All template files have the .xlts file extension.

Question 7

You can view,but cannot edit,workbooks in the Excel Web App.

Question 8

After you have a Windows Live ID,you can access your SkyDrive and the Office Web Apps.

Question 9

When the source and destination workbooks are stored in the same folder,you still need to include the location information in the workbook reference that links the two files.

Question 10

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

Question 11

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

Question 12

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

Question 13

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.

Question 14

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

Question 15

In Backstage view,the New from existing button opens a copy of the selected file,not the selected file.

Question 16

Using multiple worksheets with identical layouts enables you to use 3-D references to quickly summarize the data in another worksheet.

Question 17

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

Question 18

When you create a new workbook from a template,an unnamed copy of the template opens.

Question 19

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

Question 20

You can save your files directly from Microsoft Office 2010 onto SkyDrive from Worksheet view.

Question 21

A(n)spreadsheet is a workbook with labels,formats,and formulas already built into it with data removed._________________________

Question 22

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

Question 23

Web apps allow you to create,view,and edit Office files directly from a Web browser as well as share files and collaborate with other users online._________________________

Question 24

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.3-D
g.M
b.template
h.workspace
c.A
i.hyperlink
d.source
j.ScreenTip
e.destination
k.worksheet group
f.link
l.ungroup
Collection of two or more selected worksheets

Question 25

SkyDrive and Office Web Apps are static Web pages,and might change over time,._________________________

Question 26

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 27

Hyperlinks are usually represented by colored words with underlines or images._________________________

Question 28

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.3-D
g.M
b.template
h.workspace
c.A
i.hyperlink
d.source
j.ScreenTip
e.destination
k.worksheet group
f.link
l.ungroup
Indicates a link that is updated automatically

Question 29

Excel,by default,looks for template files in the Templates folder,which is where custom template files are often stored._________________________

Question 30

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.3-D
g.M
b.template
h.workspace
c.A
i.hyperlink
d.source
j.ScreenTip
e.destination
k.worksheet group
f.link
l.ungroup
Each worksheet functions independently again

Question 31

Some of the task-specific tasks available from the Office.com site include: Monthly Family Budget,Inventory List,and Time sheets._________________________

Question 32

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 33

In the figure above,cell A8 contains a hyperlink._________________________

Question 34

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 35

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.3-D
g.M
b.template
h.workspace
c.A
i.hyperlink
d.source
j.ScreenTip
e.destination
k.worksheet group
f.link
l.ungroup
Usually represented by colored words with underlines or images

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

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 38

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.3-D
g.M
b.template
h.workspace
c.A
i.hyperlink
d.source
j.ScreenTip
e.destination
k.worksheet group
f.link
l.ungroup
Appears when you place the pointer over a hyperlink

Question 39

The Security Warning shown in the accompanying figure appears in the Security Bar._________________________

Question 40

To delete a hyperlink,right-click the hyperlink cell and then click Clear Value._________________________

Question 41

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.3-D
g.M
b.template
h.workspace
c.A
i.hyperlink
d.source
j.ScreenTip
e.destination
k.worksheet group
f.link
l.ungroup
Type of cell reference that refers to the same cell or range of cells on multiple worksheets in the same workbook

Question 42

To select adjacent worksheets,you use the ____ key.

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

Question 43

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

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

Question 44

To select nonadjacent worksheets,you use the ____ key.

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

Question 45

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.3-D
g.M
b.template
h.workspace
c.A
i.hyperlink
d.source
j.ScreenTip
e.destination
k.worksheet group
f.link
l.ungroup
Contains the information when two files are linked

Question 46

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 47

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.3-D
g.M
b.template
h.workspace
c.A
i.hyperlink
d.source
j.ScreenTip
e.destination
k.worksheet group
f.link
l.ungroup
Contains text,formats,and formulas already built into it for your use

Question 48

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.3-D
g.M
b.template
h.workspace
c.A
i.hyperlink
d.source
j.ScreenTip
e.destination
k.worksheet group
f.link
l.ungroup
Receives the information when two files are linked

Question 49

Rather than 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 50

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 51

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.3-D
g.M
b.template
h.workspace
c.A
i.hyperlink
d.source
j.ScreenTip
e.destination
k.worksheet group
f.link
l.ungroup
Saves information about currently opened workbooks

Question 52

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

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

Question 53

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 54

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 55

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.3-D
g.M
b.template
h.workspace
c.A
i.hyperlink
d.source
j.ScreenTip
e.destination
k.worksheet group
f.link
l.ungroup
Indicates that a link has to be updated manually by the user

Question 56

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

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

Question 57

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.3-D
g.M
b.template
h.workspace
c.A
i.hyperlink
d.source
j.ScreenTip
e.destination
k.worksheet group
f.link
l.ungroup
A connection between two files allowing information to be transferred from one file to the other

Question 58

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 59

The ____ caption indicates a worksheet group.

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

Question 60

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

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

Question 61

When you save a workbook that contains external reference formulas Excel stores the most recent results of those formulas in the ____ file.

A) source
B) destination
C) both a.and b.
D) neither a.nor b.

Question 62

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 63

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

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

Question 64

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

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 67

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

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

Question 68

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

A) '[Sales.xlsx]Summary Info'/B6
B) '(Sales.xlsx)Summary Info'!B6
C) '[Sales.xlsx:Summary Info]'!B6
D) '[Sales.xlsx]Summary Info'!B6

Question 69

If you receive a destination workbook but the source files are not included,click the ____ Link button in the Edit Links dialog box to replace the external references with the existing values.

A) Fix
B) Break
C) Update
D) Check

Question 70

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 71

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 72

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 73

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

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

Question 74

A formula can include a reference to another workbook (called an ____ reference),which creates a set of linked workbooks.

A) internal
B) external
C) import
D) export

Question 75

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

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

Question 76

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 77

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

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

Question 78

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 79

As part of the Excel security system that attempts to protect against ____,links to other workbooks are not updated without your permission.

A) user errors
B) malicious software
C) contaminated hardware
D) import glitches

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