File Requirements

Step-by-Step Instructions

Step 1: Open and Save As

  1. Open PerfectRentals-01.xlsx (or continue from your verified Practice 2 workbook). Click Enable Editing if prompted.
  2. Click File > Save As and save the file as [your initials]Practice03.xlsx.
  3. Ensure the active worksheet tab is named Rental Days.

Step 2: Configure Document Properties & Metadata

  1. Navigate to File > Info.
  2. In the right-hand panel under Properties, select Show All Properties.
  3. Configure the following document metadata fields:
    • Title: Perfect Vacation Rentals - Q1 Report
    • Subject: ISMG 2050 - Practice 3
    • Author: Enter your full name.
    • Company: University of Colorado Denver
  4. Click the back arrow to return to your worksheet.

Step 3: Keyboard Navigation & Formula Auditing

  1. Press Ctrl + Home to return immediately to cell A1.
  2. Press Ctrl + End to jump to the lower-right active cell boundary (H21).
  3. Press Ctrl + ` (grave accent) to toggle formula view mode. Confirm that Column H formulas display =SUM(D5:G5) and Row 19 displays =SUM(D5:D18).
  4. Press Ctrl + ` again to toggle back to calculated values.

Step 4: Page Setup, Gridlines & Centering

  1. Select the Page Layout tab on the Excel ribbon.
  2. In the Page Setup group, set Orientation to Landscape.
  3. Click the dialog box launcher arrow in the bottom-right corner of the Page Setup group:
    • Under the Page tab, set Scaling to Fit to 1 page wide by 1 tall.
    • Under the Margins tab, locate Center on page and check both Horizontally and Vertically.
    • Under the Sheet tab, check the Gridlines box under the Print section.

Step 5: Custom Header & Footer Layout

  1. In the Page Setup dialog box, switch to the Header/Footer tab.
  2. Click Custom Header:
    • Left section: Insert the Sheet Name element (&[Tab]).
    • Right section: Insert the Current Date element (&[Date]).
    • Click OK.
  3. Click Custom Footer:
    • Left section: Type your full student name.
    • Center section: Insert the File Name element (&[File]).
    • Right section: Insert page numbering using the format: Page &[Page] of &[Pages].
    • Click OK, then click OK to close Page Setup.

Step 6: Print Preview Audit & Final Save

  1. Press Ctrl + P to open Print Preview.
  2. Confirm that the entire rental matrix displays centered on a single landscape sheet with visible gridlines, header, and footer tags.
  3. Press Ctrl + Home to reset your selection to cell A1, then save your file.
  4. Submit via the Canvas assignment portal.

Refer to Canvas for official submission cutoff and penalty policies.

Key Skills Practiced