Unit 4 Module 1 Application Assignment
You are a District Manager for a local drive in restaurant chain. The owner has tasked you with providing total sales for all three districts that the restaurants are in. You know that Excel will assist you in tracking these sales for each restaurant and consolidate the sales on one worksheet.
Attached is a document with the sales for all three districts
1. Build a single worksheet containing a worksheet for each district, label as such
2. Consolidate all the sales data for the districts into one dynamic consolidated worksheet.
3. Save the files as First Initial Last Name BUSA2205 Unit4 Mod1
Unit 4 Module 2 Application Assignment
For this assignment you are conducting research on accidental deaths in select counties in Connecticut. Using the attached file perform the following logic functions.
1. Pick a column (named Female Research) and create an IF Function for each country use the following criteria
If the number of females is greater than 50, return Attention Needed, otherwise return Negative.
2. Pick a column (named Male Research) and create an IF Function for each country use the following criteria
If the number of males is greater than 50, return Attention, otherwise return Negative.
3. Pick a column (named Age Research) and create an IF Function for each country use the following criteria
If the average age is less than 40, return Attention Needed, otherwise return Negative.
4. Pick a column (named Age and Drugs Research) and create an IF-AND Function for each country use the following criteria
If the number average age is less than 40 and accidents caused by drugs is greater than 50, then return Attention, otherwise return Negative.
5. Pick a column (named Age and Alcohol Research) and create an IF-AND Function for each country use the following criteria
If the number average age is less than 30 and accidents caused by alcohol is greater than 40, then return Attention, otherwise return Negative.
All cells that have Attention returned from the logic statements need to highlighted yellow.
Save the file as FirstInitialLastNameBUSA2205Unit4Mod2.xlsx (DBridgesBUSA2205Unit4Mod2.xlsx)