Apps 2-B

REMINDER: Please check Skyward. Several Missing assignments from Word Chapter #7

REMINDER: Project #5 Quiz today

Day #1 – Excel Project #6 – Creating, Sorting, and Querying a Table

Create and Format a Table
Use Lookup Tables in the worksheet
Insert Calculated Fields using structured references
Apply Conditional Formatting and icon sets
Sort Tables
Query a Table
Extract records with criteria ranges
Use Database functions and Conditional Functions
Display automatic subtotals, outline and treemap chart

  • Chapter Directions – Coffee Craft Daily Services
  • Lab #1 – City Market Complete