What is the best method to consolidate 3 workbooks from 3 branch office into one regional workbook?
A)Copy and paste
B)External cell references
C)3-D Formulas
D)Splitting

Name: What is the best method to consolidate 3 workbooks from 3 branch office into one regional workbook? A)Copy and paste B)External cell references C)3-D Formulas D)Splitting
Brand: Quizplus
Rating: 4.8 (34 reviews)

Question

Quizplus · Accepted Answer

External cell references allow you to reference cells in other workbooks, which makes it easy to consolidate data from multiple workbooks into one.

What Is the Best Method to Consolidate 3 Workbooks from 3