Back | Back To Start | Next

Assignment:

Using the data below, make a graph showing the number of billion dollar disasters, financial damage and number of deaths by year.

• Determine what year you think was the worst and why.
• Copy your finished graph into Word and write a few sentences summing up your findings.
• Make sure the graph has all proper titles and labels.
• Make sure that titles are capitalized.

Before you can do the graph you must combine the data from the chart above. Use the worksheetbelow to help you. The years 2001 and 2000 have been done for you.

1. Write the year under Year.
2. Add up the number of billion dollar disasters in that year.
3. Add up the cost in billions of dollars in that year.
4. Add up the number of deaths in that year.

When you add everything together you will have the numbers to use in your graph.

More help with the assignment:

The table should be set up as follows:

Format the cells in Row 4 by

• Clicking on the number 4
• Right click.
• Choose Format Cells.
• Click the Number tab.
• Click Currency.
• Set Decimal places to 1

The table chosen for the assignment should be a stacked column.

The final table should look like this.

Links to other Excel Online Tutorials:

Excel Full Online tutorials - Excel full tutorial covering most of the functional and operational questions.

MS Excel Very big basic tutorial Tutorial - In this tutorial you get a look into all the required basics. From easy basics of a spreadsheet to charts and graphs.

MS Excel Microsoft Excel - Office 2000 / XP Tutorial - Tutorial covering excel basics including: opening excel, entering data, aligning text, ending a sum and using charts.

MS Excel Tutorials and Projects - Excel spreadsheet creation and projects to help you create your first spreadsheets.

MS Office Training Courseware - Microsoft Office basic programs training and tutorials courseware. Course contains MS Excel, MS Word, MS Access, MS PowerPoint, MS Project and Windows XP Fundamentals. All materials are available for free download.

Merging Cells in Excel - Making your worksheets more "readable" by merging cells.

The Best Chart Types - Choosing a Chart Type For Your Spreadsheet.

Excel Printing - All You Need to Know - How to print properly from excel questions and answers.

Excel Functions and Formulas - This excel tutorial is providing the basics about formulas and functions.

Suggested Reading

Home | About Us | Our Services | Software | Spreadsheets Library | Excel Tutorials | Useful Links | Site Map | Contact Us

| Terms of Conditions |

Unless otherwise stated, all images and text
Spreadsheet123