Page 277 - open office
P. 277

In addition to the horizontal and vertical alignment, ‘Calc’ provides other text control options in the same
                 dialog box-Wrap Text, Shrink to fit, Text Orientation.


                   Option                      Action Implemented (if selected)

                                               This option  wraps  the  text  in  multiple lines to  accommodate  the  text
                   Wrap Text
                                               automatically within the column width by increasing the row height.


                                               This option reduces the font size of the contents to accommodate it  within
                   Shrink to fit Cell size
                                               the column width.

                                               This option helps to rotate the direction of contents in a cell. The user can
                   Text Orientation            either type the degree of angle of rotation or drag the angle indicator and
                                               display the content in the required position.

                 The most common text alignments are left, right, center, justified and filled. These alignments can also be
                 applied by using the shortcut buttons from the formatting toolbar. To apply the required alignment, select the
                 content and click on the required alignment button from the ‘Formatting Toolbar’.


                                                   Lab Assignment ‘n Activity                           Subject Enrichment




                     Complete the following activities and tick on the circle.
                        Start Calc and open an existing spreadsheet file  Cricket .
                        Apply the following formatting on the content of the worksheet.
                         a.  Font style should be ‘Arial Black’.
                         b.  Font size should be of 14.
                         c.  Typeface of the content should be ‘Bold Italic’.

                         d.  Alignment of all the data must be   ustified .
                         e.  Set vertical alignment as ‘Middle’.
                         f.  Save the workbook.
                         g.  Exit from the Calc.




                   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.

                 Format Cell to hold Decimal Values

                 Following are the steps to format cell to hold the decimal values:

                 Step 1:  Select the range of cells.
                 Step 2:  Click on the ‘Format’ menu and then select the ‘Cells’ option.







                                                                                Formatting Cells in Spreadsheet     277
   272   273   274   275   276   277   278   279   280   281   282