Mathematical Order of Operations
6 + 8 * 2 = ?what?
Answer is 28 or 22 B E D M A S
B = ( ) Brackets
E = 28 Exponents
D = / Division
M = * Multiplication
A = + Addition
S = - Subtraction
Concatenate
(put two strings together) you would use the ampersand &
ie. C2&” “&D2&” “&E2
Excel automatically open a document every time you start the program. The folder that Excel checks by default is named XLSTART
Functions
=IF(YourQuestion , DoIfTrue , DoIfFalse)
=Now() returns today’s date and time
=Rnd() returns a random number
=Round(Number,DecimalPlaces) ie. Round(Tax,2) this
rounds your tax to two decimal Places. Always round when working with money.
=Average(stringofcells) returns the average of a list of records on a
field in a report
=Sum(stringofcells) returns the Sum of a list of records on a field
in a report
=Right(cell,Places) Returns the left most characters based
on the number of places
=Left(cell,Places) Returns the left most characters based
on the number of places
=Len(cell) Returns the number of characters in a field Easter Egg in Excel 2000
1) Boot Excel 2000
2) Under file menu, do 'Save as Web Page'
3) Say 'Publish Sheet' and 'Add Interactivity'
4) Save to some htm page on your drive.
5) Load the htm page with IE. You should have Excel in the middle of the page.
6) Scroll to row 2000, column WC. Select row 2000, and tab so that WC is the active column.
7) Hold down Shift+Crtl+Alt and click the Office logo in the upper-left.
8) If you have DirectX, you will be playing what looks like spy hunter. Use the
arrow keys to drive, space to fire, O to drop oil slicks, and when it gets
dark, use H for your headlights.
Troubleshooting a formula
You can display your formulas in all cells by pressing [Ctrl]~.
If you want to view the dependent cells for a particular cell, select the cell first before you press [Ctrl]~.
Flight Simmulator in Excel 97
1. On a blank worksheet press F5.
2. In the "Go To" windows enter "r97c12:r97c24"
3. Press enter.
4. Press the TAB key.
5. Hold down Control + Shift.
6. Click the chart wizard tool-bar icon.
7. Have fun and enjoy.
Fill doen/right Short cut
The Fill handle provides a handy way to duplicate
values and formulas in adjacent cells, there are special shortcut
keys you can use.
- Select the cell you want to duplicate, plus the adjacent cells which
you'd like to insert the duplicated data.
- Next, press [Ctrl]D to fill the data down the selected
portion of the column, or press [Ctrl]R to fill the data to the
right, across the selected portion of the row.
Back To Main Page
Back To Main Page
