Chapter Five

Question 1

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

Answer 1

Linking

Question 2

What is the keyboard shortcut for inserting a hyperlink?

Answer 2

Ctrl+K

Question 3

What command sets a read-only file property?

Answer 3

Mark as Final

Question 4

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

Answer 4

a link to the source workbook

Question 5

What is true about SmartArt graphics?

Answer 5

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

Question 6

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

Answer 6

Shift

Question 7

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

Answer 7

Identifier

Question 8

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

Answer 8

=’[WorkbookName]WorksheetName’!CellRange