Spreadsheet+L+3

**Lesson Three: Cell Attributes**

Enter the following data into a spreadsheet and then use a formula to find the average for each subject. To do this you must first select the cell in which you want the answer to go, and then type the correct formula. The formula for finding the average is: =average(range) || where the range Is the group of cells you want to average example:

=average(AL:A4) would find the average of the cells Al, A2, A3, A4   | Hints: You will notice that the word Social Studies won't fit in the cell. To move increase the length of a cell, move your cursor over the A and B at the top of the sheet. When your pointer changes to, click and drag to the right. This will enlarge that column. || || Finally, when you calculate your averages, numbers may look like this 8620.00% instead on 86.2%. This is because 1 is already 100% in decimal notation. Therefore, 86 will be 8600%. To rectify this problem, adjust your average formula as follows: =average(range)/100 || This will divide the numbers by 100 and give you the correct answer. Finally, make sure to calculate an average of all averages in cell G-13.
 * Be sure to include the equal sign, both brackets, and the full colon.
 * You will find that the answer you get in your formula cell will be quite lengthy, for example you may end up with the answer 83.32678943.
 * To control the number of digits which appear after the decimal point we have to set the cell attributes. To do this select all the cells which will have an answer in them (do this by clicking and dragging). Select the cell attributes from a menu. These may be called format cells (Excell) or number (Appleworks).
 * Here you can choose from any number of cell attributes including currency, date, percentage and so on. Click on percentage, and then set the number of places at the right to 2. After you have done this click on OK and you will now find that the numbers which appear in these cells will only have one digit after the decimal point.
 * Experiment and try different cell attributes just to see how different attributes change the look of the answer. I'm not asking you to experiment, I'm TELLING YOU TO EXPERIMENT. NOW! AND ENJOY IT!