Module 5 Excel Flashcards

1
Q

3-D reference

A

a reference to the same cell or range in multiple worksheets in the same workbook

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

broken link

A

a reference to a file that has been moved since the link was created

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

custom template

A

a workbook template you create that is ready to run with the formulas for all calculations included as well as all formatting and labels

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

destination file

A

the workbook that receives data form another workbook when two workbooks are linked; sometimes referred to as the dependent file

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

external reference

A

a reference to cells or ranges in a worksheet from another workbook

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

hyperlink

A

a link in a file, such as a workbook, to information within that file or another file

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

link

A

a connection between files that allows data to be used in the destination file when two or more workbooks are linked

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

source file

A

a workbook that contains data to be used in the destination file when two or more workbooks are linked

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

worksheet group

A

a collection of two or more selected worksheets

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

range name (defined named)

A

a word or string of characters assigned to a cell or range

How well did you know this?
1
Not at all
2
3
4
5
Perfectly