How To Format The Worksheet In Excel 2010

MS Excel Cell can hold different types of data like Numbers, Currency, Dates, etc. You can set the cell type in various ways as shown below − Right Click on the cell » Format cells » Number.
Click on the Ribbon from the ribbon.

Various Cell Formats
Below are the various cell formats.

General − This is the default cell format of Cell.
Number − This displays cell as number with separator.
Currency − This displays cell as currency i.e. with currency sign.
Accounting − Similar to Currency, used for accounting purpose.
Date − Various date formats are available under this like 17-09-2013, 17th-Sep-2013, etc.
Time − Various Time formats are available under this, like 1.30PM, 13.30, etc.
Percentage − This displays cell as percentage with decimal places like 50.00%.
Fraction − This displays cell as fraction like 1/4, 1/2 etc.
Scientific − This displays cell as exponential like 5.6E+01.
Text − This displays cell as normal text.
Special − Special formats of cell like Zip code, Phone Number.
Custom − You can use custom format by using this.

Setting Fonts in Excel 2010
You can assign any of the fonts that is installed for your printer to cells in a worksheet.
Setting Font from Home

You can set the font of the selected text from Home » Font group » select the font.

Setting Font From Format Cell Dialogue
Right click on cell » Format cells » Font Tab
Press Control + 1 or Shift + Control + F