When data is consolidated and links to the source data are included,the consolidation will not be automatically updated when changes are made to the source data.
Correct Answer:
Verified
Q36: Excel addresses linked workbooks by using _
Q37: Each of the following statements is TRUE
Q38: References that address data across multiple worksheets
Q39: The _ error will appear if VLOOKUP
Q40: Ungrouping worksheets is accomplished by either right-clicking
Q42: While VLOOKUP can reference linked table data
Q43: A 3-D reference allows formulas and functions
Q44: A primary advantage of the ability to
Q45: To arrange the data in all the
Q46: Worksheets can store multiple consolidations.
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