8.1.2 Referencing Data in Other Workbooks

What happens when the source workbook is updated?

• The destination workbook updates automatically.

• The destination workbook deletes the formula.

• The destination workbook remains unchanged.

• The source workbook closes automatically.

Which symbol is used to separate sheet names and cell references in formulas?

• A semicolon (;)

• An exclamation mark (!)

• A period (.)

• A colon (:)

Why are worksheet names enclosed in single quotes in formulas?

• Because they contain numbers.

• Because they contain spaces.

• Because they are external references.

• Because they are case-sensitive.

What is the default type of reference for external workbook formulas?

• Relative references

• Dynamic references

• Absolute references

• Mixed references

What happens to the formula in the destination workbook when the source workbook is closed?

• The formula stops working.

• The formula is deleted.

• The formula becomes a relative reference.

• The full file path of the source workbook is added to the formula.