Page 280 - Trackpad IT-402_Class-IX
P. 280

011
                                                                                      022
                                                                                      033
                                                                                      044
                                                                                      055

        Formatting of a Range of Cells as Scientific
        To change the numbers as scientific notation, follow 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 Scientific category.

        Step 5:  Click on OK button. The values will appear in scientific notation.


























        Formatting a Range of Cells to Display Date

        To change the format of the date to a different type, follow the given steps:
        Step 1:  Select the range of cells with the numeric values entered as a date.
        Step 2:  Click on Format → Cells... to open the Format Cells dialog box.

        Step 3:  Select the Numbers tab.
        Step 4:  Click on Date category and select the required format of the date.
        Step 5:  Click on the OK button to see the changes as shown below.






          280   Trackpad Information Technology-IX
   275   276   277   278   279   280   281   282   283   284   285