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

The video tutorial guides students through an exercise called the Eastern Regions report. It covers adding and deleting rows and columns, inserting cells, and inputting data for a new salesperson named Newberry. Students will also learn to create a formula to calculate totals and save their work. The tutorial concludes with a prompt to proceed to the next module on data movement.

What is the first task you need to perform in the Eastern Regions report exercise?

• Delete existing columns

• Open the exercise and add rows

• Create a formula for totals

• Add a new salesperson

What should you do after adding rows and columns in the exercise?

• Insert a range of cells

• Delete the added rows and columns

• Save and close the file

• Move to the next module

Where should the new salesperson be added in the report?

• Southwest region

• Southeast region

• Northeast region

• Northwest region

What is the name of the new salesperson whose figures you need to plug in?

• Mr. Smith

• Mr. Johnson

• Mr. Brown

• Mr. Newberry

What is the final step after calculating Mr. Newberry's totals?

• Save and close the file

• Delete the file

• Move to module 8

• Add more rows