Multiple Choice
All of the following statements are TRUE regarding linked workbooks EXCEPT:
A) Changes to data referenced in its source workbook can be reflected in the data of the destination workbook.
B) Links to workbooks are difficult to break.
C) When opening a linked workbook, users are given the choice whether or not to update links.
D) It is wise to store all workbooks in a linked relationship together in the same folder.
Correct Answer:
Verified
Correct Answer:
Verified
Q22: Conditional formatting cannot be directly applied to
Q23: A 3-D reference has the following structure:
Q24: Fill Across Worksheets _ should be used
Q25: Ungrouping worksheets is accomplished by either right-clicking
Q26: The Fill Across Worksheets feature of Excel
Q28: A 3-D range can be defined by
Q29: A worksheet can store only _ consolidation(s).
Q30: If you want to summarize data from
Q31: Multiple worksheets can be selected at the
Q32: Consolidating by category is more _ than