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!
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.