Add a Comment to a Cell October 22, 2009
Posted by computertrainer in Excel Tips.Tags: comment, Excel
add a comment
Comments are notes that you enter for a cell. You can add a comment to a cell that has constants or formulas.
- Right click the cell you want to comment on.
- Select Insert Comment.
- In the box, type the comment text.
If you do not want your name in the comment, select and delete the name. - When you finish typing the text, click outside the comment box.
By default you will see a red triangle in the upper right corner of any cell that has a comment. When you hover the mouse over a cell with the red triangle (comment), then the comment box will appear.
Standard Order of Operations in a Formula in Excel October 12, 2009
Posted by computertrainer in Excel Tips.Tags: calculations, Excel, math, order
add a comment
If you combine several operators in a single formula, Microsoft Excel performs the operations in the order shown in the table below.
If a formula contains operators with the same precedence (for example, if a formula contains both a multiplication and division operator) Microsoft Excel evaluates the operators from left to right.
To change the order of evaluation, enclose the part of the formula to be calculated first in parentheses.
Please Excuse My Dear Aunt Sally
( ) Parentheses — Calculate the values of all expressions inside parentheses or brackets first, using the standard order of operations, and working from the innermost parentheses out.
^ Exponents — Next, raise all numbers to the indicated powers.
* / Multiplication & Division — Next, do all the multiplications and divisions from left to right.
+ - Addition and Subtraction — Last, do the remaining additions and subtractions from left to right.
For example, =15-3*4 equals 3, not 48. Using the standard order of operation, 3 is multiplied by 4 giving you 12 and then that number is subtracted from 15. If you wanted an answer of 48 you would use parentheses … =(15-3)*4.
Calculate in Word October 5, 2009
Posted by computertrainer in Word Tips.Tags: calculate, perform math, Word
add a comment
Microsoft Word has a calculator that you can add to a toolbar. You don’t have to be in a table to perform math!
The Calculator is quick to use for any simple on-screen calculations in a Word document.
To add the Calculate tool to a toolbar, follow these directions:
- Right-mouse click on any toolbar, click Customize, then the Command tab.
- In the Categories list, select Tools.
- In the Commands list, find the Tools Calculate command and click on it.
- Drag the Tools Calculate command onto any toolbar. Remember you must see the I-beam to drop it to the toolbar.
- The button appears grayed out until you select an equation.
Office 2007:
- Click the arrowhead to the right of the Quick Launch Toolbar.
- Click More Commands.
- Select All Commands.
- Scroll to Calculate and click the Add button to add it to your Quick Access Toolbar.
Check it out. Type an equation, select it, and click the Tools Calculate (Calculate in 2007) icon. The answer appears in the status bar at the bottom of the window and is copied onto the clipboard. Click where you want the answer and press Ctrl+V to paste the answer.
Remember, + = Add, - = Subtract, * = Multiply, and / = Divide.
Also, remember the standard order of operations within formulas: Please Excuse My Dear Aunt Sally! (Details in next week’s blog.) 15 – 3 * 4 = 3, not 48!
Find and Replace Noun or Adjective Forms or Verb Tenses September 29, 2009
Posted by computertrainer in Word Tips.Tags: Find and Replace, Word
add a comment
To search for:
Singular and plural noun forms
For example, replace “apple” with “orange” at the same time that you replace “apples” with “oranges”.
All adjective forms
For example, replace “worse” with “better” at the same time that you replace “worst” with “best”.
All tenses of a root verb
For example, replace “sit” with “stand” at the same time that you replace “sat” with “stood”.
- On the Edit menu, click Find or Replace.
2003 Find and Replace Dialog Box
2007 Find and Replace Dialog Box
- If you don’t see the Find all word forms check box, click More.
NOTE: The More button is shown as the Less button in the screen shots above. - Select the Find all word forms check box.
- In the Find what box, enter the text you want to find.
- If you want to replace the text, enter the replacement text in the Replace with box.
- Click Find Next, Replace, or Replace All.
- If the replacement text is ambiguous, click the word that best matches the meaning you want.
For example, “saw” can be both a noun and a verb; click “saws” to replace nouns, or click “sawing” to replace verbs. - To cancel a search in progress, press ESC.
Notes
- If you’re replacing text, it’s a good idea to click Replace instead of Replace All; that way, you can confirm each replacement to make sure it’s correct.
- Use the same part of speech and tense for both the search and replacement text. For example, search for “see” and replace it with “observe” (both are verbs in the present tense).
Flip your Computer Screen with a Keystroke September 21, 2009
Posted by computertrainer in Windows.Tags: Flip screen
add a comment
A friend just phoned and somehow flipped her computer desktop screen upside down. How could she get it back right side up?
If you know the answer, it is easy. If you don’t, then you will get very dizzy because you will have to tip your head over to read!
To correct this flip of the screen use the following key combination: Ctrl + Alt + any of the Arrow keys.
Now, that was easy!
HELP! Word Keeps Adding Styles Based on Formatting September 14, 2009
Posted by computertrainer in Office 2007 Tips, Word Tips.add a comment
If you use Word styles, then you might notice that new styles are added to the style list based on formatting changes you have made, not to the style but to items in the document itself.
For example, you are using Heading 1 style and for one of the headings you format the font to be red; the font color for Heading 1 was blue. Now you have a new style named Heading 1 + Red.
I find this feature to be most annoying! This post will show you how to turn off the addition of styles based on formatting changes.
Word 2003
1. Tools, Options, Edit Tab
2. Remove the √ in Keep track of formatting
Word 2007
1. Office Button, Word Options, Advanced category
2. Remove the √ in Keep track of formatting
Add a Comment in a Cell’s Formula October 26, 2009
Posted by computertrainer in Excel Tips.Tags: comment, Excel
add a comment
If you want to add a comment to a cell with a formula but do not want the traditional Comment (see Add a Comment to a Cell posted on 10/22/09), then follow these steps to add the comment at the end of your formula.
You will not be able to see that there is a comment to the formula unless you click the cell that the formula is in. You’ll see the comment on the Formula Bar.