Monday, October 20, 2008

Ch.2--"Formatting Cells in Excel"

A new process that I learned in this chapter is the different kinds of cell formats. There are formats for currency to percentages. It is really cool. What you do is highlight the cell/cells that you wish to change its format and go to the format tab and choose cells. Go to the heading number. Read the descriptions for the format names to determine what kind of format you want for your project. For example if you change the format to currency Excel will automatically put a dollar sign in front of the number and it will place the decimal accordingly and put two zeros behind it, just like currency. It can also do fractions. It will display all the numbers you put into Excel as a fraction. This is important to Excel because it makes it easier and faster for someone to type in currencies, fractions, dates and more. It makes it so the person typing does not have to worry about putting a dollar sign or a decimal place into their numbers. You are able to select any number of cells you want for that format and you can have as many different formats as you want. This is good because Excel will allow you to have different formats for different cells.

No comments: