A primary advantage of the ability to reference data in multiple workbooks is that you can access data at its source in its original location.
Correct Answer:
Verified
Q39: The _ error will appear if VLOOKUP
Q40: Ungrouping worksheets is accomplished by either right-clicking
Q41: When data is consolidated and links to
Q42: While VLOOKUP can reference linked table data
Q43: A 3-D reference allows formulas and functions
Q45: To arrange the data in all the
Q46: Worksheets can store multiple consolidations.
Q47: To organize the data differently than how
Q48: A 2-D named range references the same
Q49: A data consolidation that contains links to
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