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

The video tutorial guides students through an exercise in Excel, where they open a file with two tabs: 'fruits and veggies' and 'books and music'. Students create different views for each category, starting with the original view. They then duplicate the file and arrange the views vertically to see both tabs simultaneously. The tutorial concludes with instructions to proceed to the next module on linking files.

What is the name of the file you need to open for the Excel exercise?

• tables

• views

• data

• charts

Which tabs are present in the 'views' file?

• fruits and veggies, books and music

• animals and plants, books and music

• fruits and veggies, movies and games

• animals and plants, movies and games

What should you do first when creating views in the 'fruits and veggies' tab?

• Create a view for books

• Create the original view

• Create a view for veggies

• Create a view for fruits

How should you arrange the views on your screen after creating a second copy of the file?

• Vertically with books and music on the left

• Horizontally with fruits and veggies on top

• Vertically with fruits and veggies on the left

• Horizontally with books and music on top

What is the next module about after completing the views exercise?

• Linking files

• Formatting cells

• Creating charts

• Using formulas