Page 279 - Trackpad IT-402_Class-IX
P. 279
• Underline: It underlines the selected text.
• Align Left: It aligns the selected text to the left in a cell. To open the Format
• Align Center Horizontally: It aligns the selected text to the center of the cell. Cells dialog box:
• Align Right: It aligns the selected text to the right of the cell.
• Justified: It aligns the selected text to the left and right cell borders. Short key
• Add Decimal Place: It increases the decimal place of a number. Ctrl + 1
• Delete Decimal Place: It decreases the decimal place of a number.
Formatting a Range of Cells with Decimal Places
To format the number with a decimal place, we can either use the two options (Add Decimal Place
and Delete Decimal Place) present on the formatting toolbar or change it through the Format Cells
dialog box. Perform the following steps to do so:
Step 1: Select the range of cells containing the numbers.
Step 2: Click on Format → Cells... to open the Format Cells dialog box.
Step 3: Select the Numbers tab.
Step 4: Click on Number Category.
Step 5: From the list, select the Format of the number.
Step 6: Change the Decimal places to 2 from the Options section.
Step 7: Click on the OK button to see the changes as shown below.
Formatting a Range of Cells as Labels
Numbers are not preceded by ‘0’. If you try to put zero before a number, then it will automatically
be removed after moving to the next cell. In order to display zero before a number, it has to be
converted into text which can be done by following the given steps:
Step 1: Select the range of cells with the numeric values.
Step 2: Click on Format → 'Cells...' to open the Format Cells dialog box.
Step 3: Select the Numbers tab.
Step 4: Click on Text Category.
Step 5: Click on the OK button to see the changes as shown below.
Electronic Spreadsheet 279

