Page 313 - TP_IT_V1.0_C9_flipbpookl
P. 313

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 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 Scientific category from the Category list box.

                 Step 5:   Select the desired format of the number from the Format list box.
                 Step 6:  Click on the OK button.

                 The values will appear in scientific notation.




























                 Formatting a Range of Cells to Display Date

                 In a spreadsheet, by default the date format is in American Format, where mm-month, dd-date, yyyy-year. However,
                 this default format can vary depending on the regional settings of your software and operating system. The date
                 12/09/2023 means that it is the 09th day of December 2023. In a spreadsheet application, the user can change this
                 Date in many different formats. 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 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 Date category from the Category list box.

                 Step 5:  Select the desired format of the number from the Format list box.
                 Step 6:  Click on the OK button.










                                                                                               Electronic Spreadsheet  311
   308   309   310   311   312   313   314   315   316   317   318