 |
| Navigation Links |
 Step
2 |
| More Basics |
More work with formulas |
| Cut, copy, paste, delete |
| Shortcuts |
| Working with dates |
| Formatting cells |
| Linking Excel and Word |
| Text Version |
Welcome to Excelling with Excel 2007
More Basics
So far,
so good, no? I think you are progressing nicely and it is time to look
at other formulas in Excel. When you have completed this
page, email me for the
assignment on average, minimum, maximum. Then you wil be ready to move
on to cut, copy, paste.
average, minimum and maximum
Although Excel has the function option which we will explore later, many
Excel users prefer to type in their formulas when the formulas are simple
because it is faster. We will continue to type our formulas in the formula
bar. A diagram is at the end of the notes on doing average, min and max.
Doing an average
- Open a new workbook and in cell A5 type the word average
- In cells B1:B4 (remember this means cells B1-B4), type these numbers: 14, 8, 22, 6
- Click on cell B5 - this is where we want our answer to appear
- In the formula bar type: =average(
- NOW, click on cell B1 and drag - that means hold the click and move the mouse - through cell B4
- Look in your formula bar - the formula should read =average(B1:B4
- Just add an ending parens )
- Your formula should look like this: =average(B1:B4)
- Tap enter and the answer should appear - I sure hope you got 12.5
- And, for some fun, to see the magic of Excel, change any of the numbers in cells B1 through B4 and watch Excel change the average
Doing min and max
Min and Max means for Excel to look at a series of number and determine the maximum (max) number, this would be the largest number in the series. Min means minimum and this would tell Excel to determine the smallest number in the series.
- Using the same workbook sheet - the one with the averages
- Type Min in cell A6 and Max in cell A7
- Now, select cell B6
- In the formula bar type =max(
- NOW, click on cell B1 and drag - that means hold the click and move the mouse - through cell B4
- Look in your formula bar - the formula should read =max(B1:B4
- Just add an ending parens )
- Your formula should look like this: =max(B1:B4)
- Tap enter and the answer should appear
- I think you can do the min now
- You would
do the same process EXCEPT the formula would begin =min(
and be sure you select the correct cell for the result
You are now ready for the assignment on averages, min and max. Email me for these assignments. AND you are ready to move on to the next topic - the function dialog box. Take me there.
Diagram:
