please follow the instructions carefully 2

This criterion is linked to a Learning OutcomeSTEP 1 a-g: Data Consolidation: Group Sheets

4.0 pts

This criterion is linked to a Learning OutcomeSTEP 1 a-g: Data Consolidation: Apply title and subtitle formatting to all worksheets in the group

3.0 pts

This criterion is linked to a Learning OutcomeSTEP 1 a-g: Data Consolidation: Add totals (verticaly and horizontally) and calculate totals for all worksheets in the group

3.0 pts

This criterion is linked to a Learning OutcomeSTEP 1 a-g: Data Consolidation: Add data formats and gridlines

3.0 pts

This criterion is linked to a Learning OutcomeSTEP 1 a-g: Data Consolidation: Ungroup sheets and apply a theme to each sheet in the group

3.0 pts

This criterion is linked to a Learning OutcomeSTEP 2a,b: Create 3-D cell references to complete Summary sheet

5.0 pts

This criterion is linked to a Learning OutcomeSTEP 2c: Create Grand totals in Summary Sheet

4.0 pts

This criterion is linked to a Learning OutcomeSTEP 2:d: Insert Comment

2.0 pts

This criterion is linked to a Learning OutcomeSTEP 2e: Data validation with Error Alert

3.0 pts

This criterion is linked to a Learning OutcomeSTEP 3a: Create 3-D cell references to monthly sales data

3.0 pts

This criterion is linked to a Learning OutcomeSTEP 3b: Create totals for seasons using SUMIF function

3.0 pts

This criterion is linked to a Learning OutcomeSTEP 3c: Create & Format a chart that appropriately compares winter to off-season totals

5.0 pts

This criterion is linked to a Learning OutcomeSTEP 4a: X Games Calculator: Ticket Type drop down list

4.0 pts

This criterion is linked to a Learning OutcomeSTEP 4b: X Games Calculator: Create VLOOKUP for ticket price

2.0 pts

This criterion is linked to a Learning OutcomeSTEP 4c: X Games Calculator: Add Validation with error message for quantity

2.0 pts

This criterion is linked to a Learning OutcomeSTEP 4d,e,f: X Games Calculator: Format & add clip art

4.0 pts

This criterion is linked to a Learning OutcomeSTEP 5: Documentation Sheet: Create Documentation Sheet with all appropriate sections and formatting

5.0 pts

This criterion is linked to a Learning OutcomeSTEP 5a, b: Format sheet & tabs

4.0 pts

This criterion is linked to a Learning OutcomeSTEP 5c: Author set to student name in Excel properties

3.0 pts

This criterion is linked to a Learning OutcomeSTEP 5d: Describe (a) whether you would protect sheet and why, and (b) how to protect it

5.0 pts

This criterion is linked to a Learning OutcomeSTEP 5c: Make a recommendation that analyzes the data and provides a concrete recommendation concerning increasing sales

5.0 pts

This criterion is linked to a Learning OutcomeCOMMENT: What you learned from completing this Lab

5.0 pts