Microsoft Excel 2021365 - Beginner to Advanced - Workbook Views

The video tutorial covers different workbook views in Excel, including Normal View, Page Break Preview, and Page Layout View. It explains how to identify and switch between these views, and how to use Page Break Preview to manage page breaks for printing. The tutorial also demonstrates how to add headers and footers in Page Layout View and create custom views to save specific display and print settings. Additionally, it shows how to toggle the formula bar, grid lines, and headings for a cleaner worksheet presentation.

How can you identify if you are in the Normal view in Excel?

• By checking the highlighted icon in the status bar

• By looking at the top left corner of the screen

• By checking the file menu

• By observing the color of the worksheet

What is the primary purpose of the Page Break Preview?

• To add comments to cells

• To change the font size

• To visualize and adjust page breaks for printing

• To edit cell contents

What happens to the font size when you adjust page breaks to fit more data on one page?

• The font size increases

• The font size decreases

• The font size changes randomly

• The font size remains the same

What additional feature does the Page Layout view offer?

• Option to add headers and footers

• Feature to change cell colors

• Ability to edit formulas

• Tool to sort data

How can you save a specific display and print setting for future use?

• By exporting the settings

• By bookmarking the worksheet

• By creating a Custom View

• By using the Save As option

What can you toggle off to give the worksheet a cleaner look?

• Cell borders

• Sheet tabs

• Grid lines

• Formulas

Why might you avoid turning off headings when working with formulas?

• It increases the worksheet size

• It enhances the print quality

• It helps in identifying cell references

• It makes the worksheet colorful