Page 246 - IT_Play_V1.0 Class9
P. 246

In addition to the horizontal and vertical alignment, LibreOffice Calc provides other text control options in the
              same dialog box-Wrap text automatically, Shrink to fit cell size, Text Orientation.
                 Option                      Action Implemented (if selected)

                                             This option  wraps  the  text  in  multiple lines to  accommodate  the  text
                 Wrap text automatically
                                             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.

              Step 6:  Click on the OK button.
              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’.


                                                                                                21 st
                                                Lab Assignment ‘n Activity                    Century   #Technology Literacy
                                                                                               Skills

                   Complete the following activities and tick the circle.
                     Start LibreOffice Calc and open an existing spreadsheet file ‘Cricket’.
                     Apply the following formatting on the content of the sheet.
                        Font style should be ‘Arial Black’.
                        Font size should be of 14.
                        Typeface of the content should be ‘Bold Italic’.
                        Alignment of all the data must be ‘Justified’.
                        Set vertical alignment as ‘Middle’.
                        Save the spreadsheet.
                        Exit from the LibreOffice Calc.


                AUTO FILL

              It is a feature in the spreadsheet package like LibreOffice 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.
              Copying a Formula

              To apply the same formula across multiple cells in rows or columns, you don't need to re-enter it for each cell.
              Instead, you can copy the formula to other cells, which saves time and effort, especially with long or complex
              formulas, and minimises the risk of errors.
              (i) Use of Copy and Paste Commands for Copying Formula

              Step 1:  Select the Cell with the Formula you want to copy.
              Step 2:  Click on the Copy button from the Standard toolbar. OR Press Ctrl + C to copy the formula.
              Step 3:  Select the destination cell where you want to paste the formula.

              Step 4:  Click on the Paste button from the Standard toolbar. OR Press Ctrl + V to paste the formula.




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