Excel 2019 In Practice - Ch 1 Guided Project 1-3 - Wear Ever Shoes - Full answer in 2025

Guided Project 1-3
In this project, you edit a worksheet for Wear-Ever Shoes that tracks their product inventory. You change the zoom size, reset
the panes, and format data. You copy an existing formula to calculate the value of the current stock and insert a column for
new data. After adjusting print options, you set a print area for a specific product line.
[Student Learning Outcomes 1.1, 1.2, 1.4, 1.5, 1.6, 1.7, 1.8]
File Needed: WearEverShoes-01.xlsx (Available from the Start File link.)
Completed Project File Name: [your name]-WearEverShoes-01.xlsx
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.
This image appears when a project instruction has changed to accommodate an update to Microsoft 365
Apps. If the instruction does not match your version of Office, try using the alternate instruction instead.
Steps to complete This Project
Mark the steps as checked when you complete them.
1. Open the WearEverShoes-01.xlsx start file. If the workbook opens in Protected View, click the Enable Editing button
so you can modify it. The file will be renamed automatically to include your name. Change the project file name if directed
to do so by your instructor, and save it.
NOTE: If group titles are not visible on your Ribbon in Excel for Mac, click the Excel menu and select Preferences to open
the Excel Preferences dialog box. Click the View button and check the Group Titles check box under In Ribbon, Show.
Close the Excel Preferences dialog box.
2. Remove a split and freeze panes.
a.
b.
c.
d.
Click the Split button [View tab, Window group]. The split is removed.
Click cell A4 to freeze the column titles at this position.
Click the Freeze Panes button [View tab, Window group].
A solid border appears between rows 3 and 4 to mark the pane.
1/5
https://tulsacc.simnetonline.com/sp/assignments/projects/details/8633867
2/5/24, 11:10 AM Excel 2019 In Practice - Ch 1 Guided Project 1-3 - SIMnet
https://tulsacc.simnetonline.com/sp/assignments/projects/details/8633867 2/5
Figure 1-91 Panes frozen at cell A4
Figure 1-93 Formula to be copied
e. Scroll to row 31 and click cell E31. The column titles are frozen.
f. Type 3 and press Enter (Figure 1-91).
g. Press fn+Cmd+Left Arrow or fn+Ctrl+Left Arrow. The
insertion point returns to cell A4.
3. Change zoom size and unfreeze the pane.
a. Click the Zoom to 100% button [View tab, Zoom group].
b. Click the Unfreeze Panes button [View tab, Window
group].
c. The solid border between rows 3 and 4 is removed.
d. Click cell A1.
4. Check spelling in the worksheet.
a. Click the Spelling button [Review tab, Proofing group]. The first occurrence of “Hikin” is found as misspelled.
b. Select Hiking in the Suggestions list.
c. Click Change All to correct all occurrences of the misspelled word (Figure 1-92)