Practice 16: SmartArt Graphics & Dynamic Hyperlinks

Key Topics & Core Concepts

SmartArt Graphic Insertion: Selecting visual process and hierarchy layouts to diagram organizational workflows.
SmartArt Formatting: Applying color style variants, shape fills, and typography hierarchy to enhance visual presentation.
Internal Worksheet Hyperlinks: Inserting dynamic link targets pointing to specific cells and sheets within the active workbook.
Return Navigation & Document Polish: Configuring reciprocal 'Back to Summary' bookmark links and clearing formula audit flags.

Assignment Overview & Deliverables

In this concluding Chapter 7 practice lab, you will add a professional SmartArt organizational diagram to the Perfect Vacation Rentals workbook and build an interactive internal hyperlink system connecting all quarterly worksheets.

Starter Workbook: Download PerfectRentals-05-1.xlsx (or continue with your completed file from Practice 15)
Completed File Name: [your initials] Practice16_FinalNav.xlsx
Active Worksheets: Consolidation, Quarter 1, Quarter 2, Quarter 3, and Quarter 4

Step-by-Step Instructions

Step 1: Open Starter & Review Consolidation Sheet

Download and open PerfectRentals-05-1.xlsx in Excel (or continue from Practice 15).
Click Enable Editing if opened in Protected View.
Save the workbook as [your initials] Practice16_FinalNav.xlsx.
Click the Consolidation worksheet tab.

Step 2: Insert and Populate SmartArt Graphic

Select cell A12 on the Consolidation worksheet.
On the Ribbon, go to Insert > SmartArt (in the Illustrations group).
In the SmartArt gallery, select Process from the left list, choose Basic Process (or Step Down Process), and click OK.
In the Text Pane (or directly in the graphic shapes), enter the quarterly planning cycle labels:
- First shape: Q1: Spring Booking Audit
- Second shape: Q2: Peak Season Ingestion
- Third shape: Q3 & Q4: Annual Reconciliation
Resize and position the SmartArt graphic cleanly within range A12:F22.

Step 3: Format SmartArt Style & Colors

With the SmartArt graphic selected, open the SmartArt Design tab on the Ribbon.
Click Change Colors and choose Colorful - Accent Colors.
In the SmartArt Styles group, choose Moderate Effect or Intense Effect.

Step 4: Create Internal Navigation Hyperlinks

In row 24 on the Consolidation sheet, create an interactive navigation directory starting at cell A24:
- Cell A24: Type Jump to Quarter 1
- Cell B24: Type Jump to Quarter 2
- Cell C24: Type Jump to Quarter 3
- Cell D24: Type Jump to Quarter 4
Select cell A24 and press Ctrl + K (or Cmd + K on Mac) to open the Insert Hyperlink dialog.
Under Link to:, select Place in This Document.
Select the Quarter 1 sheet reference and leave cell reference as A1. Click OK.
Repeat this process for cells B24 through D24, pointing each respectively to Quarter 2!A1, Quarter 3!A1, and Quarter 4!A1.

Step 5: Add Reciprocal 'Return to Summary' Hyperlinks

Click the Quarter 1 sheet tab.
In cell A12, type: ← Back to Consolidation Summary.
Select cell A12, press Ctrl + K, select Place in This Document, and target Consolidation!A1. Click OK.
Copy cell A12 and paste it into cell A12 of the Quarter 2, Quarter 3, and Quarter 4 worksheets.
Test clicking the links to verify seamless round-trip navigation across all sheets.
Save your completed workbook.

Practice exercises are formative and prepare you for homework submissions. Refer to Canvas for official submission cutoff and penalty policies.

Key Skills Evaluated

Skill Area	Verification Target
SmartArt Graphic Insertion	Process layout configured with quarterly workflow text and clean positioning.
SmartArt Styling	Accent colors and Moderate/Intense visual style effects applied.
Internal Hyperlinks	'Place in This Document' bookmarks configured from Consolidation to all quarterly sheets.
Reciprocal Navigation	Return links on all quarterly sheets cleanly returning to Consolidation!A1.