BUSA 2205: Fundamentals of Computer Applications (OER): Unit 4: Advanced Spreadsheet Concepts

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)