Multiple Choice
What is the proper format of an external reference to a workbook or worksheet thats name contains spaces;source and destination files are in the same folder?
A) ''[WorkbookName]Worksheet''!Cell
B) Worksheet'!Cell
C) [WorkbookName]Worksheet!Cell
D) '[WorkbookName]Worksheet'!Cell
Correct Answer:

Verified
Correct Answer:
Verified
Q29: What happens if you rename the source
Q30: To group all worksheets:<br>A)right-click a cell and
Q31: To group nonadjacent worksheet tabs:<br>A)right-click a worksheet
Q32: To ungroup worksheets:<br>A)click a worksheet tab for
Q33: When a stop is chosen as the
Q35: Match the following terms with the corresponding
Q36: This should be used when referencing cells
Q37: Conditional formatting can be applied to a
Q38: The VLOOKUP function can be used to
Q39: What happens when data that is externally