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:
Verified
Q11: Which of the following cannot be accessed
Q12: In Excel,hyperlinks appear as:
A)blue text with a
Q13: Visited hyperlinks in Excel appear as:
A)blue text.
B)black
Q14: This should be used when referencing cells
Q15: Which of the following is true when
Q17: To group nonadjacent worksheet tabs:
A)right-click a worksheet
Q18: Which of the following actions will open
Q19: What is the proper format of an
Q20: Which of the following functions cannot be
Q21: What is indicated by red arrows when
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