Page 244 - IT_Play_V1.0 Class9
P. 244

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











              Formatting a Range of Cells to Display Times

              To hold the Time, 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 Time option from the Category list.

              Step 6:  Select the desired Time 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 time.













              Formatting Alignment of a Cell Range

              The data in a cell gets aligned by default based on the type of data entered. (If the data is of text type, it will be
              aligned towards left. If the data is of numeric type, it will be aligned towards right). To align the data of a cell:
              Step 1:   Select a cell or range of cells to be aligned.




                242     Information Technology Play (Ver 1.0)-IX
   239   240   241   242   243   244   245   246   247   248   249