The Complete Excel Guide: Beginners to Advanced - Module 16 - Practice Exercise

The video tutorial guides students through opening and linking four files: Jane, Hanover, Monder, and Summary. The Summary file is a dependent file that consolidates data from the source files. Students will calculate total sales and commissions, save and close the files, and then move to a Consolidation file to aggregate quantities from the source files. The tutorial concludes with instructions to proceed to Module 17 for advanced formula creation.

Which files are considered source files in the task?

• Jane, Hanover, and Monder

• Summary, Jane, and Hanover

• Monder, Summary, and Hanover

• Jane, Summary, and Monder

What is the role of the Summary file in this task?

• It contains all the sales data

• It is a source file

• It is a dependent file that links to source files

• It is used for data consolidation

What should you do after linking the source files to the Summary file?

• Open a new file

• Save and close the Summary file

• Delete the source files

• Close all files

In the consolidation task, which range should be selected?

• A1 through B10

• B5 through B14

• C5 through C14

• D1 through D10

What is the final step after consolidating the data?

• Reopen the source files

• Create new links

• Save and close the file

• Move to module 18