Office 2000: Introduction to Excel

 Beginning Excel

What is excel: 

1. Excel is a software program that allows users to enter and manipulate data. Students in grades 3-12 can learn to use Excel successfully -- even if their teachers are not expert technology or Excel users.

Terms/Definitions

2. Spreadsheet:  Basic excel document
• 
3. Cell:  The individual fields where you enter data.
4. Columns are lettered
5. Rows are numbered
6. Each cell is labeled with a letter and a number; similar to battleship. 
• Example:  A1, C10

Assignment

Creating the spreadsheet

• Create the following spreadsheet

• 

• Click in cell “D2”
• Click the “Edit Formula” button
1. 
• Click the drop down box.
1. 
2. Select the “Average” option.
• You should now see the following
1. 
2. Make sure that in the number 1 box it says “B2:C2”
• Click “OK”
• You should now see the average in D2

·        

·        We don’t want to do the formula for each cell so here is a shortcut.

o       Hover you mouse pointer over the bottom right hand corner of cell D2.

o       It should now change from a pointer into a “+” sign.

o       

o       Left click and hold, then drag down the “D” column.  This will now put that formula in each row.

o       You should now see averages in each row.

1.      

·        Now select cell B10.

·        Click on the “Edit Formula” button again.

o       

·        Click on the dropdown button and select Average.

o       

o       Make sure that the next box in the “Number1” says “B2:B9”

1.      

o       Click OK button.

·        You should now see the “Total Average Temp.” in cell B10

o       

o       Again, we don’t want to have to input the formula for each column so hover over the bottom right corner of cell B10 until you get the “+” pointer.

1.      

o       Left click and drag to your right a few cells.

o       You should now see the averages across each column.

1.      

Now lets create a chart

• Highlight the data that you want involved in the chart.
• 
• Click on the “Chart Wizard” icon.
• 
• Select the type of chart you would like to have.
• 
• Click “Next”
• Explore the options in the following area.
• 
• Click Next
• Give your chart a title and play with the options.
• 
• Click “Next”
• Click “Finish” in the next box.
• 
• You should now see the following chart.
•