Page 241 - IT_Play_V1.0 Class9
P. 241

Step 6:   Click on the Font Effects tab to select the appropriate option of Font color, Overlining, Strikethrough,
                         etc.
                 Step 7:  Click on the OK button.

                                                                                      6
















                                                                                    7


                   FORMAT CELL

                 The cell in spreadsheet can hold different types of data such as decimal values, percentage, textual values,
                 date & time, etc. The data present in the cell can be customized or formatted using the ‘Format Cells’ option.
                 Formatting a Range of Cells with Decimal Places


                 To hold the decimal values, follow these steps:
                 Step 1:  Select a cell or a range of cells.
                 Step 2:  Click on the Format menu from the Menu bar.

                 Step 3:  Select the Cells option from the drop-down menu. The Format Cells dialog box appears on the
                         screen.
                 Step 4:  Click on the Numbers tab.
                 Step 5:  Select the desired Number option from the Category list.

                 Step 6:  Select the desired number of decimal places (e.g., 2 for two decimal places) from the Format list.
                 Step 7:  Click on the OK button.
                                           2



                                                                       4

                                                                       5
                            3                                                                                6



                            1






                                                                                                             7






                                                                                   Format Data in the Spreadsheet   239
   236   237   238   239   240   241   242   243   244   245   246