FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -An important thing to remember is that formatting cells in Excel changes only the appearance, or visual representation, of a cell value but not the value itself. For example, if you have number 0.5678 in some cell and you format that cell to display only 2 decimal places, the number will appear as 0.57.

Detailed explanation-2: -Excel begins with a default width of 8 characters and translates this into a given number of pixels, depending on the Normal style font. It then rounds this number up to the nearest multiple of 8 pixels, so that scrolling across columns and rows is faster.

Detailed explanation-3: -Set a column to a specific width On the Home tab, in the Cells group, click Format. Under Cell Size, click Column Width. In the Column width box, type the value that you want. Click OK.