Excel - Ch 9

Question 1

Process of selecting 2+ worksheets to be able to perform same action across multiple worksheets at the same time; green bar displays under all

Answer 1

Grouping

Question 2

Process of deselecting grouped worksheets as result of clicking a non-grouped tab or right-clicking and selecting

Answer 2

Ungrouping

Question 3

Group sheets, select range, copy to other sheets in group

Answer 3

Fill Across Worksheets

Question 4

Electronic link that goes to another location in same or different worksheet; opens another file; opens a webpage; or opens an email client

Answer 4

Hyperlink

Question 5

Shortcut to create Hyperlink

Answer 5

Ctrl+K

Question 6

Process of diving a worksheet window into 2-4 resizable panes (to view separate parts of worksheet at same time)

Answer 6

Splitting (View Menu)

Question 7

Vertical/Horizontal lines that frame the panes (above & to left of active cell)

Answer 7

Split Bar

Question 8

Reference within a formula or function on one worksheet that includes the name of another worksheet, column letter, row #

Answer 8

3-D Reference

Question 9

=’WorksheetName’!RangeofCells

Answer 9

3-D Reference Function

Question 10

TextWithFirstLetterOfEachWordCapitalized

Answer 10

PascalCase

Question 11

Firstletterofcombinedwordiscapitalized

Answer 11

Camelcase

Question 12

=SUM(‘FirstWorksheet:LastWorksheet’!RangeofCells)

Answer 12

3-D Reference with General Functions

Question 13

Process of creating external cell references from other worksheets in other workbooks

Answer 13

Linking

Question 14

Contains original data that you need in another file

Answer 14

Source File

Question 15

File containing link to receive data from source file (external reference)

Answer 15

Destination File

Question 16

=[WorkbookName]WorksheetName!RangeofCells

Answer 16

Linking Reference

Question 17

Linking Rules : [October.xlsx]Qtr3!A3

Answer 17

Workbook/Worksheet names don’t contain spaces; source/destination is in the same folder

Question 18

Linking Rules : [October Sales.xlsx]Qtr3!A3

Answer 18

Workbook name contain spaces; source/destination is in the same folder

Question 19

Linking Rules : ‘[October.xlsx]Qtr 3 Sales’!A3

Answer 19

Worksheet name contains spaces; source/destination is in same folder

Question 20

Linking Rules : ‘C:/[October.xlxs]Sheet3’!A3

Answer 20

Source/destination are located in different files