Solved

What Is the Proper Format for Creating an External Reference

Question 27

Multiple Choice

What is the proper format for creating an external reference with no spaces in the file name located in the same folder as the destination file?


A) [WorkbookName]"WorksheetName"!RangeOfCells
B) [WorkbookName]'WorksheetName'!RangeOfCells
C) WorksheetName!RangeOfCells
D) [WorkbookName]WorksheetName!RangeOfCells

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q22: _ is a file containing a pointer

Q23: Match the following terms with the corresponding

Q24: A _ is an electronic marker that

Q25: _ is/are not supported when worksheets are

Q26: What are the benefits of using 3-D

Q28: When a worksheet is split,any changes made

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