Question

What should you do to insert a footer displaying today's date on the right in an Excel worksheet?

a) Use the "Page Layout" menu
b) Right-click on the cell and choose "Insert Footer"
c) Access the "Insert" tab and select "Date Footer"
d) Go to the "View" tab and click "Page Layout View"

Answer 1

To insert a footer with the current date in Excel, use the "View" tab, select "Page Layout View", click on the footer area, and then choose "Current Date" from the "Header & Footer Tools".

Step-by-step explanation:

To insert a footer displaying today's date on the right in an Excel worksheet, you should:

1. Go to the "View" tab on the Excel ribbon.
2. Click on "Page Layout View".
3. Scroll down to the bottom of the worksheet where it says 'Click to add footer'.
4. Click on the right section of the footer area to place your cursor there.
5. Choose "Header & Footer Tools" which appears when you're in the footer area.
6. Select "Current Date" from the options provided to insert the date.

This will automatically insert the current date in the footer which will be updated every time the worksheet is printed or viewed in the print layout.