Copy the cell contents in columns A
through
F and in rows 1 through 13 into a new Excel worksheet.
Complete columns D, E, and F using formulas (hints are given in rows
16,
17, 18 and 19).
Format the spreadsheet and print it both
in regular format and in
formula format.
Print in Landscape format.
Excel Graphing Practice
Graph #1
Study the chart below. Create a graph that compares the
total
casualties the British+German Hessians
and the Americans suffered in all of the battles of the Revolutionary
War.
Graph #2
Begin with the spreadsheet shown below. Create a graph that shows
how
the total slave population in the colonies
changed from 1650 to 1770.
You must make the totals in column B.
Read (do not type into Excel) the note in rows 12, 13, & 14.
Graph
#3
Create a graph that shows the percentage of the colonial
population
made up of each of the following
ethnic divisions: English 48.7%,
African
20.0%, Scot-Irish 7.8%, German 6.9%, Scottish 6.6%, Dutch 2.7%,
French 1.4%, Swedish 0.6%, Other 5.3%.
Click here to return to the Mr. Zacc's Computer Class page.