Microsoft Excel 2021365 - Beginner to Advanced - Inserting Headers and Footers

The video tutorial explains how to add headers and footers to documents, focusing on two methods: using the page layout view and the page setup dialog. It covers customizing headers and footers, including adding file names, dates, times, and page numbers. The tutorial also demonstrates how to make modifications and preview the final output.

What is one of the benefits of using headers and footers in a spreadsheet?

• To change the spreadsheet's theme

• To increase the font size of the text

• To include useful information like document name and page numbers

• To add colorful backgrounds

Which view allows you to directly see and edit headers and footers?

• Data view

• Page layout view

• Normal view

• Formula view

How can you access the header and footer options from the page setup dialog box?

• By right-clicking on the spreadsheet

• By clicking the diagonal arrow in the page layout tab

• By selecting 'File' and then 'Options'

• By clicking the 'Insert' tab

What is an advantage of using the page setup dialog box for headers and footers?

• It changes the document's theme

• It automatically saves the document

• It provides preset options for common header and footer elements

• It allows for colorful text

When customizing a header, what can you insert into the center section?

• A background image

• The name of the file

• A hyperlink

• The document's theme

What can be added to the left section of a custom footer?

• A background image

• A hyperlink

• The date

• The document's theme

How can you display the page number as 'Page 1 of 5' in a footer?

• By using both the page number and number of pages buttons

• By changing the document's theme

• By inserting only the page number

• By typing it manually