| A | B |
|---|
| sing Merge and Center | If you attempt to Merge and Center with data in more than one cell, you will wipe out data in all but the upper-leftmost cell. Don't worry, Excel will warn you! |
| Using Auto Sum | Excel will automatically do what it is set to do. In this case, the program finds all adjacent numbers in a column, or row, and includes them in the range. |
| Using Merge and Center | For giving a clean design look to your worksheet, consider using Excel's Merge and Center feature. This is a two step process: |
| Using Auto fill | If there is a pattern in the data you are going to enter, Excel can detect the pattern and fill it in for you. |
| Cursor styles | There are four common cursor styles used in Excel. If you wish to use the automatic features of Excel, you should become familiar with them. |
| Placing a function | Before placing a function (a built in equation) make sure the selected cell is where you want the function to go. |
| Enter data | One of the principal reasons for using a spreadsheet is to perform calculations. |
| Edit bar | The edit bar at the top names the function (Sum) then lists the mathematical function to be performed (=SUM(B2:B9)). Excel selects the range numbers immediately above or to the left of the function. If there is a gap in the intended range you must enter the proper range in the edit bar. |
| Using AutoSum | Remember that Excel allows you to quickly find the total of a column or row of numbers. |
| Using another function | Excel has many built-in equations (functions). |
| When using a function | Whenever you insert a function, a dialog box pops up to explain the chosen function. |
