[accesscomp] Dan's tip
- From: "Bob Acosta" <boacosta@xxxxxxxxxxx>
- To: "tektalk discussion" <tektalkdiscussion@xxxxxxxxxxxxxxxxxxx>
- Date: Wed, 29 Aug 2012 19:51:35 -0700
Using Sum and Average In Excel Ten
If you would like to create a gradebook to do grade averages or want to keep
track of a week/monthly budget, using Excel can make these tasks much
easier.
The directions and discriptions here are going to be to the point and not a
lot of explaining so as to make it simpler to understand. Sometimes one
just wants to know how to get a job done and not all the extra chatter. That
is what this document is for.
The formula used here will work in Excel 2003, 2007 or 10.
Microsoft Excel is part of the Microsoft Office Suite.
If you are using Windows XP, do the following to open Excel from the
Programs menu.
1. Press the start button or click on the start menu.
2. Press the letter p for "programs" or click on "Programs."
3. Press the letter m until reaching "Microsoft Office."
4. Press the right arrow once.
5. Arrow down to "Microsoft Excel" and press enter.
Opening Excel in Vista and Windows Seven:
Special Note: This is how I reach Microsoft Office." I recognize there may
be other ways.
1. Press the start button or click on the start menu.
2. Arrow up once to "all programs."
3. Arrow once to the right.
4. I have found it necessary to arrow down a few times if using the
keyboard before pressing the letter m to reach Microsoft Office. Frequently
when arrowing once right and pressing the letter m to reach "Microsoft
Office" I experience difficulty. So iArrow down a few times and then press
the letter m until So, once arrowing up once to "all pr ograms", arrow once
right. Then arrow down a few times and press the letter m until reaching
"Microsoft Office."
5. Arrow once to the right when reaching "Microsoft Office."
6. Arrow down to "Microsoft Excel" and press enter.
You can put a shortcut to Excel on the desktop thus saving going to the
programs menu for opeing Excel each time.
Sending an Excel Shortcut to the desktop in Windows XP;
1. Press the start button or click on "start menu."
2. Press the letter p for "programs" or click on "programs.
3. Press the letter m until reaching "microsoft Office" or click on the
same icon.
4. From the keyboard, once reaching "Microsoft Ovvice", arrow once to the
right.
5. Arrow down to "Microsoft Excel."
6. If using a mouse, click the right button.
If using a keyboard, press the application key or shift plus f10.
7. Press the letter n.
8. Press the letter d for "desktop" followed by pressing enter.
Sending an Excel shortcut to the desktop in Vista and Windows Seven:
1. Press the start button or click the start menu.
2. Arrow up once to "All programs.
3. Arrow once to the right.
4. Arrow down a few times.
5. Press the letter m until reaching "microsoft Excel."
6. Arrow once to the right.
7. Arrow down to "Microsoft Excel."
8. Press the application key if using a keyboard.
If using a mouse, press the right button.
9. Press the letter n for "send to."
10. Press the letter d for "desktop" followed by hitting enter.
When first opening Excel y ou are placed into the top left corner or "a1."
Across the sheet are columns going from top to bottom. They are llabeled by
letter as in A, B, C etc.
Going down the sheet are rows going from left to right. They are each
numbered as in "A1, a2, etc."
Where the column and row meet creates a cell.
Moving between columns is done by pressing tab and shift tab or left/right
arrow.
Moving between rows is done by up/down arrow.
In order to enter numbers or text into a cell, move to that cell as in a1
and start typing. Remember that by default, eight caracters fit into a
cell.
If once overlaps, there is a way to auto fit the text.
I use the top row going across for name headers for each column. In order
to enter text or numbers into
If making a gradebook one could make the following labels in the first row
of each column.
Move to a1 and enter in last
Tab to b1 and type first.
Tab to c1 and type in assign.
Tab to d1 and type grade.
Press the home key once and you are put in to a1.
Arrow once to a2 and type a person's last name.
Tab to b2 and type a person's first name.
Tab once to c3 and type in the name of a given assignment.
If this overlaps, we will fix that in a second.
Tab once to d4 and enter in a number for that grade.
Now regarding the overlaping. Move to the cell that has the largest amount
of text.
Press alt plus the letter h.
Press the letter o.
Arrow down to ""auto fit row width" and press enter.
This caused Excel to make sure any cell that is as large as the one you just
made to auto fit will not over lap.
Once you several numbers in the column of grades that is D, you can create a
forumla to calculate an
After entering the last grade, arrow down once more to a blank cell.
You are now going to figure the average of grades between D2 through the
last numbered cell you entered a number in.
Write the formula as shown below. Where I use the letter n, insert the
final number for y our gradebook.
You must start every formula with an equal sign.
=average(D2:Dn) Remember to enter your final cell number where I put the
letter n and to capitalize all letters in a formula.
Once entering your formula press enter.
Then arrow up once and the answer is now in that cell.
Remember that all letters must be capitalized in a formula.
One can also use the above formula for getting the som of numbers.
If you wanted to add all numbers in a given series of rows as in D2 through
D10, do the following.
=sum(D2:D10)
And press enter.
Then arrow up once and the answer is there.
Now anytime you change any of those numbers in cells included in that
formula, the answer will be automatically changed. That is the same for the
average formula shown above.
Below are some symbols and sample formula you can practice with.
· 7+9
· 19-3
· 222*19
· 17/4
· 1799/2.4
Notice the various signs used in the above formulas
· + (plus sign) is the addition symbol
· - (minus sign) is the subtraction symbol
· * (asterisk, star) is the multiplication symbol
· / (forward slash) is the division symbol
Below are some Special JAWS keys to use with Excel.
· List Cells in a Column SHIFT-JAWS KEY-C
· List Cells in a Row SHIFT-JAWS KEY-R
· List Cells with Formulas JAWS KEY-SHIFT-F
· List Cells with Comments CTRL-SHIFT-APOSTROPHE
· List Visible Cells with Data CTRL-SHIFT-D
· List Worksheets CTRL-SHIFT-S
· List Cells at Page Break CTRL-SHIFT-B
· List Defined Monitor Cells CTRL-SHIFT-M
· Say Range of cells visible in active window ALT-SHIFT-V
· Read Hyperlink ALT-SHIFT-H
Describe Cell Border ALT-SHIFT-B
Dan Thompson
dthompson5@xxxxxxxxx
this message has been scanned with microsoft security essentials
_______________________________________________
Danstips mailing list
Danstips@xxxxxxxxxxxxxxx
http://jacobsexton.com/mailman/listinfo/danstips_jacobsexton.com
Robert Acosta, President
Helping Hands for the Blind
Email: boacosta@xxxxxxxxxxx
Web Site: www.helpinghands4theblind.org
You can assist Helping Hands for the Blind by donating your used computers to
us. If you have a blind friend in need of a computer, please mail us at the
above address.
Other related posts:
