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
   274   275   276   277   278   279   280   281   282   283   284