Practice 3: Navigation, Document Properties & Page Setup

Step-by-Step Instructions

Step 1: Open and Save As

1. Open [your initials]Practice02.xlsx. Click Enable Editing if Protected View opens.
2. Save As → [your initials]Practice03.xlsx.
3. Click Save.

Step 2: Select the Rental Days Worksheet

1. Click the Rental Days sheet tab to ensure it is the active worksheet.

Step 3: Use the Name Box and Go To Commands

1. Type D5 into the Name Box (top-left, left of the formula bar) and press Enter. Cell D5 becomes active.
2. Type 6 in cell D5 and press Enter.
3. Press F5 to open the Go To dialog box. Type A8:C8 and press Enter — this selects three cells.

Step 4: Use the Find Command

1. Select cell A5.
2. Click Find & Select (Home tab → Editing group) → Find.
3. Type 33 in the "Find what" box.
4. Click Options >> to expand the dialog. Verify: Scope = Sheet, Look in = By Rows, Within = Formulas.
5. Click Find All. An alert appears: Excel could not find "33" as a value — this is expected, because 33 may be a formula result rather than a literal value.
6. Close the alert. Change "Look in" from Formulas to Values.
7. Click Find All again. Cells H5 and H7 are found (they contain values that evaluate to 33).
8. Select cell G5, type 10, press Enter.
9. Select cell G7, type 8, press Enter.
10. Click Find All again. No cells found with value 33 (because the changed values no longer equal 33). Close both dialog boxes.

Step 5: Enter Document Properties

1. Click the File tab → Info.
2. Click Show All Properties at the bottom of the properties list to expand it.
3. Fill in these properties:
   • Title: [your initials]Practice03
   • Status: Draft
   • Subject: Rental days by property
4. Click Show Fewer Properties, then return to the worksheet.

Step 6: Add Header and Footer to Grouped Sheets

1. Hold Ctrl and click the Next Period tab to group both sheets together (both tabs appear white/highlighted).
2. Click the Header & Footer button (Insert tab → Text group). This switches to Page Layout view.
3. In the header area, click the right section, then click Sheet Name (Header & Footer Elements group). The code &[Tab] appears.
4. Click Go to Footer → click the right section of the footer area.
5. Click File Name. The code &[File] appears.
6. Select cell A1, then click Normal view button in the status bar. Sheets remain grouped.

Step 7: Change Page Setup for Grouped Sheets

1. Click the Page Layout tab → Orientation → Landscape.
2. Click File → Print to preview both sheets.
3. Use the Next Page/Prev Page arrows to verify the header/footer appears on both "Rental Days" and "Next Period."
4. In Print Settings, click Custom Margins. Check the Horizontally box under "Center on page." Click OK.
5. Preview again to confirm centered alignment. Return to the worksheet.
6. Right-click the Next Period sheet tab → Ungroup Sheets.

Step 8: Finalize and Submit

1. Review your completed workbook for accuracy.
2. Save ([your initials]Practice03.xlsx).
3. Upload via the Canvas assignment portal.