← Back to ISMG-2050 Course Hub

Skills Covered

• Page orientation (Portrait vs. Landscape) per worksheet
• Setting and managing Print Area boundaries
• Scaling to fit on specific page counts
• Custom headers and footers (text, page numbers, dates)
• Page break preview and manual insertion of page breaks
• Multi-sheet print management with varying layouts

Part 1: Orientation and Print Area (30 pts)

1. Open [your initials]Practice04.xlsx. Save as [your initials]Practice07.xlsx.
2. You will now configure each sheet for professional printing:
3. Sheet1 (Flash Fill Data):
4. Page Layout > Orientation > Portrait
5. Print Area > Set Print Area for the range A1:D15 (your Flash Fill output)
6. Scale to Fit: Width = 1 page, Height = Automatic
7. Insert in the Center Header: [Your Full Name] - ISMG 2050 Practice 4 Results
8. In the Footer (right-aligned): Last modified: then use the Date & Time field to insert the current date automatically.
9. "Conversion" sheet:
10. Page Layout > Orientation > Landscape
11. Print Area > Set Print Area for A1:D9
12. Scale to Fit: Width = 1 page, Height = 1 page (ensure everything fits on a single printed page)
13. Insert in the Center Header: Currency Conversion Report - Module 2
14. In the Footer (left-aligned): Page then insert Page Number field.

Part 2: Page Breaks and Margins (30 pts)

9. "TaxTable" sheet:
10. View > Page Break Preview to see where Excel will split pages.
11. If the table spans multiple pages, manually adjust page breaks: drag the blue dashed line to ensure all data fits on one page.
12. If needed, insert a manual page break between rows 5 and 6: Select row 6, Page Layout > Breaks > Insert Page Break.
13. Page Layout > Margins > Narrow (0.5" top/bottom, 0.7" left/right) to maximize data visibility.
14. Set the Top Repeating Rows: $1:$1 so the header row prints at the top of every printed page.

Part 3: Headers, Footers, and Page Break Preview (25 pts)

14. Return to Sheet1.
15. In the header Left section, type: ISMG 2050 — Module 2 Practice
16. In the header Center section, use the Page Number field (&P) to insert current page.
17. In the header Right section, type: of &P pages.
18. Insert a custom text watermark if available (Page Layout > Watermark): type "DRAFT" in gray.
19. Switch to Print Preview (Ctrl+P). Verify each sheet renders cleanly with no data clipped off the right edge.

Part 4: Multi-Sheet Print Setup (15 pts)

19. Select all three sheets by Shift-clicking each tab at the bottom of the window.
20. Page Layout > Page Setup dialog launcher (small arrow in corner):
21. Navigate to the Sheet tab.
22. Set Print area: leave blank for now (will print all cells with data).
23. In Orientation: confirm your per-sheet settings are preserved.
24. Unselect all sheets by clicking any single sheet tab.
25. Save the file.

Submission Criteria

• File named exactly [your initials]Practice07.xlsx
• Sheet1: Portrait orientation, print area A1:D15, left header + right-aligned date footer
• "Conversion": Landscape orientation, print area A1:D9, fits on 1 page, center text header, left page number footer
• "TaxTable": Page Break Preview used to verify single-page layout, narrow margins, top repeating rows ($1:$1)
• All three sheets have custom headers and footers with at least one dynamic field (page #, date, or filename)
• Print Preview verified on all sheets: no clipped columns, aligned data
• AI Disclosure statement included in a note below TaxTable data

→ Back to Week 3\u20134 Homework Portal