I need an explanation for this Mathematics question to help me study.

Complete Lab 4: Summit Ridge Mountain Resort: Warming Hut Monthly Income Consolidation

COURSE: BIS155 Lab 4

COURSE: BIS155 Lab 4

Criteria Ratings Pts

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

 4.0 pts Full Marks 0.0 pts No Marks

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 Full Marks 0.0 pts No Marks

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 Full Marks 0.0 pts No Marks

3.0 pts

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

 3.0 pts Full Marks 0.0 pts No Marks

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 Full Marks 0.0 pts No Marks

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 Full Marks 0.0 pts No Marks

5.0 pts

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

 4.0 pts Full Marks 0.0 pts No Marks

4.0 pts

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

 2.0 pts Full Marks 0.0 pts No Marks

2.0 pts

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

 3.0 pts Full Marks 0.0 pts No Marks

3.0 pts

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

 3.0 pts Full Marks 0.0 pts No Marks

3.0 pts

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

 3.0 pts Full Marks 0.0 pts No Marks

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 Full Marks 0.0 pts No Marks

5.0 pts

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

 4.0 pts Full Marks 0.0 pts No Marks

4.0 pts

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

 2.0 pts Full Marks 0.0 pts No Marks

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 Full Marks 0.0 pts No Marks

2.0 pts

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

 4.0 pts Full Marks 0.0 pts No Marks

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 Full Marks 0.0 pts No Marks

5.0 pts

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

 4.0 pts Full Marks 0.0 pts No Marks

4.0 pts

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

 3.0 pts Full Marks 0.0 pts No Marks

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 Full Marks 0.0 pts No Marks

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 Full Marks 0.0 pts No Marks

5.0 pts

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

 5.0 pts Full Marks 0.0 pts No Marks

5.0 pts