For this assignment, you will be using Excel produce a high quality one-page spreadsheet of features of the students (and teacher) in this classroom. You will have to gather data, enter it in your chart, and use simple addition (sum) functions to get your totals.
Guidelines:
-It must contain the following headings list, justified center, in CAPITOLS:
|
|
GIRLS |
BOYS |
TEACHER |
TOTALS |
-It must contain the following list in the FIRST column, justified left, in lower case:
|
Wearing something red |
|
Wearing something blue |
|
Wearing shoes |
|
Wearing glasses |
|
Wearing sweats |
|
Has brown hair |
|
Has black hair |
|
Has blonde hair |
|
Is losing hair |
|
Looks really cool |
|
Could be President one day |
|
Working hard on assignment |
|
Looks confused about assignment |
You need to use one of the formulas we learned to add up the totals. DO NOT ADD IN YOUR HEAD OR USE A CALCULATOR!!!
-Format the chart so that each COLUMN or ROW is a different color. Make sure to format just the cells with data, NOT the entire column. You can also choose to use auto-format if you wish!
-Extra Credit (5 points) Add this row to your worksheet, collect the data,
and fill in the cells: -Number of tooth fillings?
Good luck!!