109
1. Create a line
chart.
2. Select cells using
multi ple ranges.
3. Use the Fill
Eff ects feature in
a chart.
T
he Summer Olympic Games are an internati onal multi -sport event,
occurring every four years, organized by the Internati onal Olympic
Committ ee. Medals are awarded in each event, with gold medals for fi rst
place, silver for second, and bronze for third--a traditi on that started in 1904.
The games have expanded from a 42-event competi ti on with fewer than 250
male athletes to a 300-event sporti ng traditi on with over 10,000 competi tors
from 205 nati ons. The United States has hosted four Summer Olympic
Games--more than any other nati on.
The following acti vity illustrates how spreadsheets can be used to graph the
number of competi tors in the Summer Olympic Games over the years.
46
Summer Olympic Games
1. Create a NEW spreadsheet.
Unless otherwise stated, the font should be 10 point Arial.
2. Type the data as shown.
3. Change the font size of cell A1 to 16 point.
4. Bold and underline row 3.
5. Format column widths and alignments as follows:
a. Column A to 10.0 and left align.
b. Column B to 22.0 and left align.
c. Column C to 25.0 and left align
d. Column D to 20.0 and center align.
6. Create a line chart as follows:
a. Select cells A3 A11 and D3 D11 simultaneously. To do this, select cells A3
A11, then hold down <CTRL> and select cells D3 D11. Both cell ranges should
be selected.
b. Using the Chart Wizard, select Line for the Chart type and "Line with markers
displayed at each data value" for the Chart sub-type.
c. Click on the Series tab.
d. Click on Year and click on Remove tab.
e. Defi ne the Category (X) axis labels by selecti ng cells A4 A11.
f. Enter the chart ti tle as "SUMMER OLYMPICS," the ti tle for Category (X) axis as
"YEAR," and the ti tle for value (Y) axis as "# OF COMPETITORS."
g. Display the legend to the right of the chart.
NEW SKILL
NEW SKILL
ACTIVITY
For Evaluation Purposes Only