In this project, you edit a worksheet for Wear$-$Ever Shoes change the zoom size, reset the panes, and format da calculate the value of the current stock and insert a colu options, you set a print area for a specific product line. $[$Student Learning Outcomes $1\mathrm{.}1,1\mathrm{.}2,1\mathrm{.}4,1\mathrm{.}5,1\mathrm{.}6,1\mathrm{.}7,1$

File Needed: WearEverShoes$-01.$xIsx $($Available from the Completed Project File Name: $[$your name$]-$WearEverShoe

Skills Covered in This Project

Open and save a workbook.

Change zoom size and remove a split.

Freeze panes.

Format labels and values.

Use the Fill Handle to copy a formula and fill a series.

Check spelling.

Apply a workbook theme, cell styles, and font attributes.

Merge and center labels.

Insert a column and adjust column widths and row heights

Adjust alignment, indents, and borders.

Rename the sheet tab.

Use Page Layout view to insert a footer.