Question

1. In Module 2 "headers" and "footers" are described. Explain the difference between them and how to set them up. How can they improve your workbook's appearance?

2. A cell containing a number displays #######. Why does this occur and what can you do to fix it?

Answer 1

*Answer(1):

Excel provides an area for headers and footers so you can add information to the top and bottom of a sheet. They are especially useful if your purpose for using Excel is to create a printed or PDF version of your sheet. The following articles explore the tools Excel provides to edit headers and footers and how you can achieve the look you need on your sheet.

A header can be defined as a text that is located at the top of the page, on the other hand, the footer can be defined as a text that is located at the bottom of the page.

header and footer are text or graphics which are printed on the top and the bottom margin of each of a document. header and footer are normally used to print page number running titles the date of the time or printing a document a company logo the document title or files name etc.

Difference between Header and Footer--
1. A header is a text that is printed at the top of each page in a document whereas footer is printed at the bottom of each page.
2. By default, headers are printed 0.5 inches from the top of the page and footers are printed 0.5 inches from the bottom of the page.
Headers and footers usually contain information like the document name, chapter name, page number, and date. You can decide what headers and footers should have.

Improve your workbook's appearance in following way:

Adding a File Path and Filename

Adding Ampersands in Headers and Footers

Adding Graphics to a Header or Footer

Ampersands in Headers and Footers

First and Last Names in a Page Header

Full Path Names in Headers or Footers

Inserting the Saved Date In a Header or Footer

Keep Your Headings in View

Putting a Different Date in a Header

Putting Cell Contents in Footers

===============================================================================================

*Answer(2): A cell containing a number displays ####### ,this situation occurs when the formatted number does not fit in to the column and to fix this we have to increase column size or we can also increase or decrease the decimal places.