Page 311 - TP_IT_V1.0_C9_flipbpookl
P. 311

We can format the data by using any of the given ways:
                 •  Click on the Format → Cells option from the Menu bar. It will open the Format   To open the Format
                   Cells dialog box.                                                               Cells dialog box:
                   OR                                                                          Short key
                 •  Use the Formatting toolbar present just below the Standard toolbar.                      +
                   OR                                                                                  Ctrl      1
                 •  Right-click on the  and select the Format Cells option from the context menu. It
                   will open the Format Cells dialog box.
                 The formatting of the data can be done by using some of the given tools:
                 •  Font: It is used to change the font type such as Algerian, Calibri, Century Gothic, etc.
                 •  Font Size: The default font size is 10, which can be increased or decreased.
                 •  Bold: It makes the selected text appear thick.
                 •  Italic: It makes the selected text appear slightly tilted.
                 •  Underline: It underlines the selected text.
                 •  Align Left: It aligns the selected text to the left within a cell.
                 •  Align Center: It aligns the selected text to the center of the cell.
                 •  Align Right: It aligns the selected text to the right within a cell.
                 •  Justified: It aligns the selected text to both  left and right cell borders.
                 •  Decimal Place: It increases or decrease the decimal place of a number.
                 •  Wrap text: It wraps the text within a cell, so all content is displayed within the cell boundaries.
                 •  Number Formatting: This formats the numbers in a cell to display as currency, percentage, date, time, etc.
                 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 use the Decimal Places option 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 the Format → Cells option from the Menu bar.
                 The Format Cells dialog box opens.

                 Step 3:  Select the Numbers tab.
                 Step 4:  Click on the Number category from the Category list box.




                                                                                               Electronic Spreadsheet  309
   306   307   308   309   310   311   312   313   314   315   316