Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Excel > Chapter Five > Flashcards

Chapter Five Flashcards

1
Q

Which of the following is the process of referring to data in another workbook?

A

Linking

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

What is the keyboard shortcut for inserting a hyperlink?

A

Ctrl+K

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

What command sets a read-only file property?

A

Mark as Final

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

When linking workbooks using a formula, what type of link is created?

A

a link to the source workbook

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

What is true about SmartArt graphics?

A

the name box displays Diagram followed by a number, as you type in a SmartArt graphic the text and its shape are sized to fit the contents, it rests on an invisible transparent layer in the worksheet

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

What key must you hold when performing the click command to select and group adjacent sheets?

A

Shift

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

What is a character such as an exclamation point that marks or signifies a component of an external reference?

A

Identifier

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

What is an example of an external reference with all of its identifiers?

A

=’[WorkbookName]WorksheetName’!CellRange

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

Excel (11 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions