Exam 77-420 Microsoft Excel 2013
1. Create and Manage Worksheets and Workbooks
1.5 Configure Worksheets and Workbooks to Print or Save: Custom Headers and Footers

Page Setup: Custom Footer

3. Try This: Create a Custom Footer

The Header/Footer tab is still open.

Select Custom Footer.

 

Type the following:

Left Section: Charlotte's Website

Center Section: Questions? Call 810.555.1212

Right Section: click on the Date button.

 

What Do You See? When you click on the Insert Date button, Excel will insert &[Date]. This is code that updates the date to the current date when the spreadsheet is opened.

 

Click OK. You will return to the Page Setup window. Please keep going...

graphic2
graphic1
 

Page Layout -> Page Setup ->More->Header/Footer->Custom Footer