Practice Exercise

Practice 4: Flash Fill and Cell Referencing

Learn Ctrl+E Flash Fill for automatic pattern recognition (name parsing). Master relative ($A$1), absolute ($A$1), and mixed ($A1, A$1) cell references. Includes currency conversion exercise with a locked exchange rate constant.

Due: Sunday, September 14 at 11:59 PM MT • Starter: starter_data_wk3.xlsx • Submit: [initials]Practice04.xlsx

Practice Exercise

Practice 5: Math Operators and Conditional Formatting

Build a Salary Report using math operators (+, -, *, /, ^). Apply threshold-based conditional formatting (greater/less than rules), data bars, and color scales. Includes file extension type documentation (.xlsx, .csv, .pdf, .xlsm).

Due: Sunday, September 14 at 11:59 PM MT • Submit: [initials]Practice05.xlsx

Practice Exercise

Practice 6: Customer Tracking with Data Import

Import customer_data.csv using Data > Get Data. Apply Icon Sets (arrows), data bars, and color scales (heat maps). Create region summary tables with SUMIF formulas. Professional table styling and number formatting.

Due: Sunday, September 21 at 11:59 PM MT • Starter: customer_data.csv • Submit: [initials]Practice06.xlsx

Practice Exercise

Practice 7: Page Setup and Multi-Sheet Print Optimization

Configure per-sheet orientation (portrait/landscape), set print areas, scale to fit pages, custom headers/footers with dynamic fields (page #, dates). Use Page Break Preview for multi-sheet layout management.

Due: Sunday, September 21 at 11:59 PM MT • Submit: [initials]Practice07.xlsx

Comprehensive Project

College Cost Calculator

Build a four-year college cost projection from scratch. Absolute cell references across multiple sheets ($), SUMIF/SUMPRODUCT aggregation, conditional formatting threshold alerts (over $20K/year highlighted red), data bars for growth visualization, and page setup with print areas per sheet.

Due: Sunday, September 21 at 11:59 PM MT • Start blank • Submit: [initials]CollegeCost.xlsx

Comprehensive Project

Cost Analysis Report

Analyze multi-category operational costs using SUMIF-based department aggregation. Variance calculations ($ and %). Conditional formatting: red for over-budget, green for under-budget, data bars on variance %. Landscape print setup with headers/footers and page scaling. Builds on Eller Systems dataset from Module 1.

Due: Sunday, September 21 at 11:59 PM MT • Starter: starter_data_wk3.xlsx + Eller-02.xlsx • Submit: [initials]CostAnalysis.xlsx