Jeanette wants to combine data from four workbooks into a new workbook that will consolidate her data. She can write a function that will combine the data, or she can use the Consolidate Data dialog box. What is an advantage of using the Consolidate Data dialog box?
A. Consolidated data can be combined from any location on different workbooks.
B. The data can be consolidated in one step by clicking on the Consolidate Data box.
C. The data from each workbook can be seen in the workbook by clicking on the Collapse button.
D. The consolidated workbook always updates when changes are made in the individual workbooks.