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

