n$.$ Select cells A$4$:H$4,$ press Ctrl and select cells A$19$:H$19,$ and apply Light Gray, Background $2$ as Fill

Color.

o$.$ AutoFit column widths if needed.

Insert a footer and scale the data to print.

a$.,$ Click the Insert tab and click the Header & Footer button $[$Text group$].$

b$.$ In the left footer section, insert the Sheet Name field.

c$.$ In the right footer section, insert the File Name field.

d$.$ Click a worksheet cell and return to Normal view.

e$.$ Open print preview in the Backstage view and scale the worksheet to fit a single page.

Add document properties.

a$.$ Open the Info screen in the Backstage view.

b$.$ Edit the Title property to display Sales by Department.

c$.$ Edit the Status property to display First draft.

Save and close the workbook $($Figure $1-109).$