Excel 2024 In Practice - Ch 1 Guided Project 1-3

Guided Project 1-3 - SIMnet Project Steps to complete This Project

Mark the steps as checked when you complete them.

1.Open the workbook EX2024-GuidedProject-1-3.xlsx start file. If the workbook opens in Protected View, click Enable Editing in the security bar. 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.

2.Open the workbook WearEver-01.xlsx downloaded from the Resources link. If the workbook opens in Protected View, click Enable Editing in the security bar.

Zoom out and unfreeze panes.

3.Click the Zoom Out button in the Status bar five times to return to a 100% zoom size.

4.Click the Freeze Panes button [View tab, Window group] and choose Unfreeze Panes.

5.Click the Switch Windows button [View tab, Window group].

6.Confirm that both WearEver-01 and [your name]-EX2024-GuidedProject-1-3 are open.

7.Display the WearEver-01 workbook.

8.Copy a worksheet to another workbook.

9.Right-click the Sheet1 tab in WearEver-01 and choose Move or Copy.

10.Click the To book drop-down list and select [your name]-EX2024-GuidedProject-1-3.

11.Select the Create a copy box (Figure 1-102).

12.Select the destination workbook for the copied sheet

Figure 1-102 Select destination workbook for the copy

13.Click OK. The copied sheet inserts as Sheet1 (2) in [your name]-EX2024-GuidedProject-1-3 and is active.

14.Click the Switch Windows button [View tab, Window group] and choose WearEver-01.

15.Close the workbook without saving.

16.Verify that you are working in [your name]-EX2024-GuidedProject-1-3.

17.Rename and delete sheets.

18.Double-click the Sheet1 (2) tab.

19.Type Inventory and press Enter.

20.Right-click the Sheet1 tab and choose Delete.

Fill a label series and delete a column.

21.Click cell A4.

22.Type WEA001 and press Enter.

23.Select A4 and double-click its Fill Handle.

24.Right-click the column J heading and choose Delete.

25.Use the Fill Handle to copy a formula.

26.Click H4. The formula displays in the Formula bar. The formula multiplies the quantity by the cost to calculate the value of the current stock (Figure 1-103).

The asterisk * is the multiplication symbol

Figure 1-103 Formula to be copied

27.Double-click the Fill pointer for cell H4. The formula is copied down the column. (Press Enter to complete the function if you didn’t double-click fast enough.)

Merge across and set word wrap.

28.Select cells A1:I2.

29.Click the arrow with the Merge & Center button [Home tab, Alignment group].

30.Select Merge Across. The cells in each row merge and the labels are left-aligned (Figure 1-104).

31.Use Merge Across to combine cells without centering

Figure 1-104 Use Merge Across to combine cells without centering

32.Select cell F3 and click the Expand Formula Bar arrow at the right edge of the Formula bar (Figure 1-105). The label has a line break after the word “or,” but the row is not tall enough to display two lines.

Line break after or

Figure 1-105 Line break after "or"

33.Click the Wrap Text button [Home tab, Alignment group]. The row height adjusts to display the label on two lines.

Collapse the Formula bar.

34.Change alignment and format data.

35.Select cells A4:C39 and click the Increase Indent button [Home tab, Alignment group] once. This moves the label away from the border for easier reading.

36.Select cells F4:F39 and click the Center button [Home tab, Alignment group].

37.Select cells G4:I39.

38.Click the Number Format drop-down list [Home tab, Number group] and choose Currency.

39.Select cells A1:A2 and click the Font Size arrow [Home tab, Font group].

40.Choose 20 as the new size.

41.Select cells A3:I3 and click the Bold button [Home tab, Font group].

42.Click the Format button [Home tab, Cells group] and choose Row Height.

43.Type 35 and press Enter.

44.Click the Center button [Home tab, Font group].

45.Display and calculate total inventory value.

46.Click cell G40.

47.Type Current Inventory Value at Cost and press Enter.

48.Select cell G40 and click the Bold button [Home tab, Font group].

49.Click the Align Right button [Home tab, Alignment group].

50.Select cell H40 and double-click the AutoSum button [Home tab, Editing group].

AutoFit column H to display the value.

51.Add borders and set row height.

52.Select cells A3:I40.

53.Click the Borders drop-down arrow [Home tab, Font group] and select All Borders.

54.Select cells A4:I40.

55.Click the Format button [Home tab, Cells group] and choose Row Height.

56.Type 20 and press Enter.

57.Press Ctrl+Home.

58.Use Page Layout view to insert a footer.

59.Click the Page Layout view button in the Status bar.

60.Click the center header section to display the Header & Footer command tab.

61.Click the Go to Footer button [Header & Footer tab, Navigation group] and click its right section.

62.Click the File Name button in the Header & Footer Elements group. The code is &[File].

63.Click a worksheet cell to see the file name.

Switch to Normal view and press Ctrl+Home.

64.Change page setup options.

65.Click the File tab and choose Print.

66.Click the Next Page button two or three times to see how the worksheet spreads across printed pages. The number of pages depends on your printer settings.

67.Click No Scaling in the Settings area and choose Fit Sheet on One Page.

68.Return to the worksheet.

69.Use the Name box and set a print area.

70.Click the Name box, type a3:f11, and press Enter.

71.Click the Print Area button [Page Layout tab, Page Setup group] and select Set Print Area.

72.Press Ctrl+Home.

73.Click the File tab and select Print to preview the print area (Figure 106). The footer prints with a print area.

74.Print area includes the footer

Figure 1-106 Print area with footer

75.Return to the worksheet.

76.Save and close the workbook. The print area is saved with the workbook (Figure 1-107).

Excel 1-3 completed

Figure 1-107 Excel 1-3 completed

77.Upload and save your project file.

78.Submit file for grading.