Excel+Spreadsheets

=The 2008 Summer Olympics=

Activity 1:
Make a column graph showing the 5 countries who won the most medals at the 2008 Olympics. Show the number of gold, silver, and bronze medals won by those countries by graphing 3 bars for each country. Add appropriate titles and legends.

[[image:phelps.jpg align="left" caption="Michael Phelps"]]Activity 2:
Several people won more than one medal for the U.S. Make a bar graph showing the top 5 medalists for the U.S. Show how many medals they won and show their names.

Go to this site to get information for making graphs: http://results.beijing2008.cn/WRM/ENG/INF/GL/95A/GL0000000.shtml

Activity 3--Commission:

 * 1) Pretend you are a salesperson at Dillards. You get 25% commission for your sales.
 * 2) Make a spreadsheet to show your sales for the weeks below. Make the columns wider as needed.
 * 3) Bold the titles as shown.
 * 4) Merge and center the main title.
 * 5) Add formulas to find Total Sales for each week, Commission for each week, and Total Commission for the 5 weeks.
 * 6) Put a box border around the cell that has the total commission.
 * 7) Underline the titles row.
 * 8) Copy the entire table and place it below the 1st table on the spreadsheet.
 * 9) Change the numbers as they appear in the second spreadsheet below. Watch how the totals change.
 * 10) Make a column graph to show your Commission for the 5 weeks.


 * **Priscilla's Sales** ||
 * **Week of:** || **8-Nov** || **15-Nov** || **22-Nov** || **29-Nov** || **6-Dec** ||
 * Monday || $125.00 || $115.00 || $175.00 || $250.00 || $275.00 ||
 * Tuesday || $150.00 || $165.00 || $145.00 || $350.00 || $375.00 ||
 * Wednesday || $225.00 || $225.00 || $215.00 || $450.00 || $465.00 ||
 * Thursday || $125.00 || $150.00 || $125.00 || $325.00 || $350.00 ||
 * Friday || $350.00 || $400.00 || $375.00 || $450.00 || $475.00 ||
 * **Total Sales** ||  ||   ||   ||   ||   ||
 * **Commission** ||  ||   ||   ||   ||   ||
 * **Total Commission:** ||  ||   ||   ||   ||   ||
 * **Priscilla's Sales** ||
 * **Week of:** || **8-Nov** || **15-Nov** || **22-Nov** || **29-Nov** || **6-Dec** ||
 * Monday || $115.00 || $125.00 || $185.00 || $275.00 || $300.00 ||
 * Tuesday || $125.00 || $175.00 || $125.00 || $375.00 || $350.00 ||
 * Wednesday || $205.00 || $215.00 || $200.00 || $425.00 || $450.00 ||
 * Thursday || $115.00 || $175.00 || $135.00 || $315.00 || $425.00 ||
 * Friday || $300.00 || $450.00 || $385.00 || $500.00 || $450.00 ||
 * **Total Sales** ||  ||   ||   ||   ||   ||
 * **Commission** ||  ||   ||   ||   ||   ||
 * **Total Commission:** ||  ||   ||   ||   ||   ||
 * Wednesday || $205.00 || $215.00 || $200.00 || $425.00 || $450.00 ||
 * Thursday || $115.00 || $175.00 || $135.00 || $315.00 || $425.00 ||
 * Friday || $300.00 || $450.00 || $385.00 || $500.00 || $450.00 ||
 * **Total Sales** ||  ||   ||   ||   ||   ||
 * **Commission** ||  ||   ||   ||   ||   ||
 * **Total Commission:** ||  ||   ||   ||   ||   ||
 * **Commission** ||  ||   ||   ||   ||   ||
 * **Total Commission:** ||  ||   ||   ||   ||   ||
 * **Total Commission:** ||  ||   ||   ||   ||   ||