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

The video tutorial covers the creation and formatting of pivot tables and charts in Excel. It guides students through an exercise involving opening a file, creating a pivot table on a new sheet, and formatting it to display numbers as dollars. Students are encouraged to refer back to the video if they have questions. The tutorial concludes with a transition to the next module, which will cover additional Excel features.

What is the primary purpose of a pivot table?

• To create a database

• To summarize and analyze data

• To design a website

• To write a report

What should you do after opening the file for the exercise?

• Delete all the data

• Send the file to a friend

• Create a pivot table on a new sheet

• Print the document

Where can you find examples of how your pivot table should look?

• In the video tutorial

• In a textbook

• On a separate website

• In the Word document with instructions

What formatting should be applied to the numbers in your pivot table?

• Scientific notation

• Currency (dollars)

• Date format

• Percentage

What should you do if you have questions while completing the exercise?

• Search online

• Skip the exercise

• Refer back to the video tutorials

• Ask a friend