Page 190 - CA 165 ver 1.0 Class 9
P. 190

Similarly, click on the ‘Vertical’ drop down list. It opens with various vertical alignment options which
                  are given below:

                             Option                              Action Implemented (if selected)

                   Bottom                       The contents will be aligned towards the bottom of the row.

                   Top                          The contents will be aligned towards the top of the row.
                   Middle                       The contents will be aligned in vertically centered position.

                                                The contents will be aligned according to the default settings type of
                   Default
                                                data being entered.

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


                             Option                               Action Implemented (if selected)
                                                This  option wraps  the  text in  multiple  lines to  accommodate it
                   Wrap Text                    automatically within the column width by increasing the row height.


                                                This option reduces the font size of the contents to accommodate it
                   Shrink to fit Cell size
                                                within the column width.
                                                This option helps to change the direction of contents in a Cell. The
                   Text Orientation             user can 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 or filled. These alignments can also be
                  applied by using 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’.

                    AUTO FILL

                  It is an additional feature in spreadsheet package like ‘Calc’ in which a certain
                  kind of predefined series of data such as name of months of a year, serial
                  numbers, etc. are automatically generated once the user feeds the initial
                  data.

                  To print series of months of the year:
                  Step 1:   Type the initial data (month name) of the series in one cell.

                  Step 2:   Select the cell. An AutoFill handle (a small black plus sign) appears
                            at the bottom-right corner of the selected cell.

                  Step 3:   Click the Auto Fill handle tool and drag it over the range of cells to                Drag
                            fill the defined series, then release the mouse button. The series of
                            months will be displayed. (The given series is displayed because it
                            is predefined/stored as a custom list)







                   188    Touchpad Computer Applications-IX
   185   186   187   188   189   190   191   192   193   194   195