Скачать или смотреть Excel 2021 In Practice - Ch 1 Guided Project 1-3 || Excel 2021 In Practice - Ch 1 Guided Project 1-3

Excel 2021 In Practice - Ch 1 Guided Project 1-3 || Excel 2021 In Practice - Ch 1 Guided Project 1-3


#Excel 2021 In Practice - Ch 1 Guided Project 1-3#In Practice - Ch 1 Guided Project 1-3#Ch 1 Guided Project 1-3#2021 In Practice - Ch 1 Guided Project 1-3#Guided Project 1-3


Contact us:

Whatsapp: +923271393884

Gmail: [email protected]

Whatsapp chat link:

http://tinyurl.com/24wmzw93


Excel 2021 In Practice - Ch 1 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. Click the Split button [View tab, Window group]. The split is removed.
b. Click cell A4 to freeze the column titles at this position.
c. Click the Freeze Panes button [View tab, Window group].
d. A solid border appears between rows 3 and 4 to mark the pane.

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 Ctrl+Home. 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.










Figure 1-91 Panes frozen at cell A4



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).

Figure 1-92 Change all occurrences of a misspelled word

d. Click OK.
5. Use the Fill Handle to copy a formula.
a. Click H4. The formula displays in the Formula bar. The formula multiples the quantity by the cost to calculate the value of the current stock (Figure 1-93).
b. Point to the Fill Handle for cell H4.
c. Double-click the Fill pointer. The formula is copied down the entire column.

d. Press Ctrl+Home.
6. Click the Themes button [Page Layout tab, Themes group] and choose Ion from the gallery.
7. Merge and center the titles.
a. Select cells A1:J1 and click the Merge & Center button [Home tab, Alignment group].
b. Merge and center cells A2:J2.
8. Apply cell styles and adjust row height.