5.2 Introduction

This case contains the following assessments:

• Business Sales for Weekend Donut Shop: This assessment has the student work with sales data for the Weekend Donut Shop. Multiple worksheets are used in this assessment.

• Not Perfect Linen Etsy Store Comments: This assessment uses a PivotTable and functions to analyze the comments for the Not Perfect Linen Etsy store.

• Brookers Ice Cream This assessment uses multiple worksheets to analyze the sales of ice cream for three stores.

• Credit Payoff This assessment uses formulas and scenarios to make a decision of how to payoff outstanding debt.

• Movie StatisticsThis assessment uses conditional formatting to highlight different movie studios,ticket sales and movie releases. These assessment can be divided into three seperate assessments.