This preview shows page 1. Sign up to view the full content.
Unformatted text preview: You can also combine methods of defining cells. For example, if you wanted to find the sum of the contents of cells B3 through B28, B32 and B40 through B100 the Excel command you would use is: =sum(B3:B28,B32,B40:B100) Some other useful hints: If in doubt, use parentheses to make sure things get calculated in the right order. For example, =3+5/2 results in 5.5. But, =(3+5)/2 results in 4. In the first case, it would be better to use =3+(5/2) in Excel. Pushing the Ctrl + ~ keys will display the formulas for the entire spreadsheet. Pressing these two keys again reverts back to the calculated numbers....
View Full Document
- Summer '08