Data Cleansing:

Here we have data from the Springfield Beans coffee shop. This inventory data needs prepared before it can be imported or otherwise analyzed. Here are some questions to get you started:

InventorylD: What problems might you look for in this column of data? Consider the $5$ factors of quality data.

ItemCategory: This column is a combination of two fields. Consider "Traditional $$ MediumaRoast$-$Brewed Coffee". Here the Item is "Traditional Medium Roast" and the Category is "Brewed Coffee". If you wanted to count the number of Brewed Coffee items in inventory or create a PivotTable showing each Item by Category, how does this data need to be cleansed?

ExpirationDate: This column contains a date on which an item expires. If you wanted to calculate the number of days between today's date and the expiration date, what changes need to be made to this column?

All work must be completed with functions. The emphasis here is on dynamic data. If anything in columns A$-$C were to change, the corresponding results in D$-$G must update.