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

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

Assessment

Interactive Video

Information Technology (IT), Architecture

University

Hard

Created by

Quizizz Content

FREE Resource

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.

Read more

2 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

What should be done after finishing the tasks in the consolidation file?

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

What will be discussed in module 17 after completing the current tasks?

Evaluate responses using AI:

OFF