Excel Intro:




Numbers can be written in different ways and still mean the same amount. For example, 1 can also be written as 1.00, 1.000, or 100%, depending on exactly what you are doing and how you want to look at your numbers. [For the perfectionists out there: Yes, I know that there are differences in the exact meaning of the numbers above, but for most purposes in spreadsheets we can treat them as the same.] Excel includes buttons for some of the most common ways to format numbers. Later you will use a dialog that has even more choices. Currency: formats the number as money, like $1.00 if your system is set to use dollars. Excel comes in different languages, and will use the appropriate local currency. The button may change to the general currency symbol! You can also change the currency used with the Format dialog. You are not stuck with the default! The dialog is good to use when you want a different currency only some of the time. Percent: formats the number as a percentage, like 100%. Comma: formats the number to show 2 decimal places to the right of the decimal and uses commas to separate every 3 digits to the left of the decimal. NonEnglish versions of Excel may show a different button, . (Why doesn't the whole world do things the way I do?!) Increase/Decrease Decimals: changes the number of places showing to the right of the decimal. The number is rounded when decreasing decimals. When increasing decimals, the original digits are shown, rounded to the number of decimal places you have chosen. Apparent errors in calculated values: Calculations use the underlying numbers in the cells, not the numbers that you see. This can make a difference in the results of the calculation.
Example:
Cell B2 contains the number 512.46 and cell C2 contains 66.6666. Cell D2 shows
the sum of B2 and C2, which is 579.1266. Format the cells to show only one decimal point. Then the values are rounded so that B2 displays 512.5 and C2 shows 66.7. What will you see in D2? The numbers showing in the cells add up to 579.2, but 579.1 is what shows. Confusing? Excel does the calculation for D2 with the original numbers, not the formatted numbers, and then does the formatting for D2. [Note to teachers: You may need to review percentages and rounding procedures with your students to be sure they understand those ideas.] 
Project 1: Excel Intro Search Glossary Appendix 

Start with: (Excel open to budget.xls from resource files) Number Formats: Currency
What changed: Number Formats: Percent
All the numbers are changed to percentages. Since these were large numbers, they look even larger as percentages. What changed: Number Formats: Comma
What changed: Number Formats: Change Decimals
What changed: What changed:

~~ 1 Cor. 10:31 ...whatever you do, do it all for the glory of God. ~~ 