Multiple Choice
Which of the following statements regarding worksheet data consolidation is NOT TRUE?
A) Consolidated data cannot be created unless the worksheets have identical row and/or column labels.
B) Consolidated data can be used to create a summary worksheet.
C) Links are not required when creating consolidated data.
D) Consolidated data can be generated from multiple worksheets with an identical structure.
Correct Answer:
Verified
Correct Answer:
Verified
Q39: Each of the following statements is TRUE
Q40: While VLOOKUP can reference linked table data
Q41: A data consolidation that contains links to
Q42: A(n)_ references the same cell,or range of
Q43: A template is a special file type
Q45: Each of the following statements is TRUE
Q46: Any workbook can be used as a
Q47: Which of the following features of Excel
Q48: The _ feature of Excel greatly increases
Q49: The Consolidate feature cannot create _ to