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

The video tutorial guides students through writing basic formulas in spreadsheets. It starts with opening a file named 'Eastern Regions report' and adding formulas to calculate sums, averages, and highs. The tutorial then covers calculating totals and commissions, emphasizing the importance of using absolute values to avoid errors. Students are instructed to copy their work to the Mideast region and are provided with additional instructions in a Word document. The tutorial concludes with advice to ensure understanding before proceeding to the next module.

What is the first step you need to take when starting the task in the Eastern Regions report?

How do you calculate the commissions based on the total?

What happens if you do not create an absolute value when copying the formula down?

What should you do after you have all the answers in the Eastern Regions report?

Why is it important to understand how to use formulas before moving on to module 9?