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
Q14: This should be used when referencing cells
Q15: Which of the following is true when
Q16: What is the proper format for creating
Q17: To group nonadjacent worksheet tabs:
A)right-click a worksheet
Q18: Which of the following actions will open
Q20: Which of the following functions cannot be
Q21: What is indicated by red arrows when
Q22: What error will cause #NUM! to appear?
A)Invalid
Q23: What is the proper format of an
Q24: What happens when data that is externally
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents