Page 243 - IT_Play_V1.0 Class9
P. 243

Step 4:  Click on the Numbers tab.
                 Step 5:  Select the desired Scientific option from the Category list.
                 Step 6:  Select the desired Scientific format from the Format list.

                 Step 7:  Click on the OK button.


                        2
                                                                        4

                                                                                                                 6

                        3
                                                                        5

                        1







                                                                                                                 7


                 Now, selected cells will display the values with the specified
                 format of scientific.




                 Formatting a Range of Cells to Display Date
                 To hold the different versions of date, 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 Date option from the Category list.
                 Step 6:  Select the desired Date format from the Format list.
                 Step 7:  Click on the OK button.


                      2
                                                                             4




                                                                             5
                      3
                                                                                                                   6


                      1




                                                                                                                   7




                                                                                   Format Data in the Spreadsheet   241
   238   239   240   241   242   243   244   245   246   247   248