Monday, December 04, 2006
EXCEL TIPS - Block 3
Create a comment that explains a tip you have for other students who are learning and using EXCEL.
Create a comment that explains a tip you have for other students who are learning and using EXCEL.
Here are the guidelines:
- Make it original.
- Read the comments that already have been posted.
- Make sure your tip works.
- Before your click on Publish, minimize this window and test your own tip.
- Take your time.
- Proofread your comment and check for grammar.
- Use complete sentences.
- Keep it simple.
- If your tip requires multiple steps, list them separately with enough detail.
Follow the example below to meet the minimum expectation.
Example: Tip - Copy and Paste a cell's formatting only.
- Click on the cell you want to copy the Formatting for.
- Right click and choose Copy.
- Click on the cell(s) you want to copy the formatting to.
- Choose Edit - Paste Special from the Standard Tool Bar.
- Choose Format Only and OK.
# posted by Mr. Turton @ 12:58 PM 
Comments:
<< Home
1.) To repeat numbers or words drag the little black box at the bottom right hand corner of the botton of the cell you want to copy.
2.) Hold it down and drag it down into the cells you would like the information copied.
3.) Let go and click off the cells.
2.) Hold it down and drag it down into the cells you would like the information copied.
3.) Let go and click off the cells.
1.) In excel to move a piece of information you must first highlight. 2.) Then right click and choose the option cut.
3.) Next, you right click on the cell you would like to move it to and click paste.
3.) Next, you right click on the cell you would like to move it to and click paste.
# posted by 
: 12:38 PM, December 13, 2006
: 12:38 PM, December 13, 2006
1.) To figure out a sum. Place an equal sign in the empty cell you want the total in.
2.) Use the equation =sum(:). In between the semi-colons start off with the cells that you would like to add. example: =sum(e1:e5).
3.)Press enter and you will get your value wanted.
2.) Use the equation =sum(:). In between the semi-colons start off with the cells that you would like to add. example: =sum(e1:e5).
3.)Press enter and you will get your value wanted.
# posted by : 12:42 PM, December 13, 2006
: 12:42 PM, December 13, 2006
To use the IF function:
1.)Click on a cell
2.)Go up to the Insert button and click on Function
3.)Under select a function, select "IF"
4.)In the logical test field, type a formula like "c5>5"
5.) In the Value if true field, type a phrase you want to be displayed if the formula is true
6.)In the Value if false field, type a phrase you want to be displayed if the formula is false
7.) Click ok and fill the cells you want to use the IF function for...IF you dare!!!!
1.)Click on a cell
2.)Go up to the Insert button and click on Function
3.)Under select a function, select "IF"
4.)In the logical test field, type a formula like "c5>5"
5.) In the Value if true field, type a phrase you want to be displayed if the formula is true
6.)In the Value if false field, type a phrase you want to be displayed if the formula is false
7.) Click ok and fill the cells you want to use the IF function for...IF you dare!!!!
# posted by : 12:45 PM, December 13, 2006
: 12:45 PM, December 13, 2006
If you wanted to add a group of numbers together fast in excel you can use the "auto sum" key. This key is located at the top of the standard toolbar.
1. highlight the group of numbers + one cell
2. click the "auto sum" key ( it looks like an E ).
3. click off of the highlighted numbers
4. and theres your answer
*whats nice about this key, is that it writes out the formula for you, all you have to do is use your mouse*
1. highlight the group of numbers + one cell
2. click the "auto sum" key ( it looks like an E ).
3. click off of the highlighted numbers
4. and theres your answer
*whats nice about this key, is that it writes out the formula for you, all you have to do is use your mouse*
to use the function tool
1. click on button 2. choose witch function you will need for example: sum or maximum. 3. click on the cells you wish to use 4. click enter
1. click on button 2. choose witch function you will need for example: sum or maximum. 3. click on the cells you wish to use 4. click enter
To Get Your Information In alphabetical order:
1.)Highlight all of your information you want to sort.
2.)Then go up to the Formatting Toolbar.
3.) Click the sort ascending button.
4.) It should be in order!
1.)Highlight all of your information you want to sort.
2.)Then go up to the Formatting Toolbar.
3.) Click the sort ascending button.
4.) It should be in order!
# posted by : 12:27 PM, December 20, 2006
: 12:27 PM, December 20, 2006
To Auto format:
1.) Go to the Format toolbar
2.) Select "Auto format" (2nd from bottom)
3.) Choose style
1.) Go to the Format toolbar
2.) Select "Auto format" (2nd from bottom)
3.) Choose style
If you want to quickly find the sum of the numbers in the desired amount of cells cells use auto fill.
STEPS:
1. highlight the desired amount of columns
2. Click the auto fill button
3. Then the sum of the numbers should be filled into a column below the highlighted numbers
STEPS:
1. highlight the desired amount of columns
2. Click the auto fill button
3. Then the sum of the numbers should be filled into a column below the highlighted numbers
# posted by : 12:50 PM, January 02, 2007
: 12:50 PM, January 02, 2007
If you want to quickly find the sum of the numbers in the desired amount of cells cells use auto fill.
STEPS:
1. highlight the desired amount of columns
2. Click the auto fill button
3. Then the sum of the numbers should be filled into a column below the highlighted numbers
Post a Comment
STEPS:
1. highlight the desired amount of columns
2. Click the auto fill button
3. Then the sum of the numbers should be filled into a column below the highlighted numbers
<< Home
