A data consolidation that contains links to source data includes the cell references for cells from other worksheets that contributed to a consolidated data result.
Correct Answer:
Verified
Q44: A primary advantage of the ability to
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
Q50: Excel 2013 addresses linked workbooks using absolute
Q51: A 3-D named range can be defined
Q52: Conditional formatting cannot be directly applied to
Q53: Input Across Worksheets can be used to
Q54: When you have data on multiple worksheets
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