Business Productivity Software

Integrated Office Project (Instructions)

In this assignment, you will be using the chart below to create three different files (one each in Excel, Word, And PowerPoint). Please review the instructions carefully and submit all three files (named as specified below) to the Module 2: Integrated Office Project Assignment.

Excel Project Part

Don't use plagiarized sources. Get Your Custom Essay on
Business Productivity Software
Just from $13/Page
Order Essay

The winning team gets to name the new library. You are the freshman class treasurer. You want to use MS Excel to calculate how well each team did per week and overall. You collected the following information.

 

Team

Week 1

Week 2

Week 3

Week 4

Week 5

Cheetahs

1200

965

1160

849

750

Hyenas

997.5

850

1290

1430

860

Buccaneers

1130

973

890

1234.5

1500

Submariners

800

1090

925

1012.5

1200

Create a chart in Excel that meets the following expectations. Please refer to the rubric to ensure you are meeting the requirements for this portion of the assignment:

1. Find the sum, average, maximum, and minimum for each team.

2. Find the sum, average, maximum, and minimum for each week.

3. Inset a picture of a fund raising activity.

4. Format all amounts to currency.

5. Put the team total in green with a yellow background.

6. Create a pie chart of the team totals.

7. Create a column chart of the weekly totals.

8. Save the Excel file with this file name: Fundraiser.

ORDER NOW »»

and taste our undisputed quality.