WRITER

DOCUMENT

1
Ex: No. 1

Applying Styles in a Document

Create a Writer document and apply different styles on it using LibreOffice.

Aim: To apply different styles on the document using LibreOffice Writer.

Procedure:
Step1: Open LibreOffice and Select Writer Document.
Step2: Select File → New → Text document option.
Step3: Type a paragraph.
Step4: To apply styles, select the desired text
Step5: Open Styles Menu using Sidebar by clicking styles icon.
Step6: Double click on desired style to apply.
Step7: Now the predefined styles were applied to the selected text.
Step8: After applying styles, save the document.

2
Ex: No. 2

Creating New Style

Create an new style in Writer document and apply it using LibreOffice.

Aim: To create and apply different styles on the document using LibreOffice
Writer.
Procedure:
Step1: Open LibreOffice and Select Writer Document.
Step2: Select File → New → Text document option.
Step3: Type a paragraph.
Step4: Format the content of the paragraph with font face, font size, line
spacing etc.
Step5: Select Paragraph button from Style menu of sidebar.
Step6: Click Style Action button and select New Style From Selection option.
Step7: A Create Style dialog box will appear.
Step8: Type ‘mystyle’ as style name in the box and click ok.
Step9: Now the style name ‘mystyle’ will appear in the drop down list under
Paragraph category.
Step10: Choose the paragraph in the document, where you have to apply your
style.
Step11: Select the style you have created in styles menu and double click it.
Step12: Now the created styles were applied to the selected text.
Step13: After applying styles, save the document.

3
Ex: No. 3

Inserting An Image and Cropping it

Insert an image into a document and crop the picture as per the requirement
into the document.

Aim: To insert a picture into a document and crop the picture as per the
requirement using LibreOffice Writer.
Procedure:
Step1: Open LibreOffice and Select Writer Document.
Step2: Select File → New → Text document option.
Step3: Select Insert → Image option.
Step4: Opens Insert Image browsing window to select an image. Select the
desired image.
Step5: Click on crop tool from Image toolbar.
Step6: The eight small squares surrounding the image will be changed into
blue colored handles.
Step7: By clicking any of these handles of the image and drag the cursor
towards the center of image.
Step8: The image is being cropped up to the dotted lines.
Step9: Click anywhere on the page or press Esc key to leave the crop tool.
Step10: Now the image is cropped, save the document.

4
Ex: No. 4

Inserting different Drawing Objects and Grouping

Insert three different drawing objects(smiley face, rounded rectangle, ellipse)
on the document. Include the three drawing objects into a single group.

Aim: To insert different drawing objects and make into a single group using
LibreOffice writer.
Procedure:
Step1: Open LibreOffice and Select Writer Document.
Step2: Select File → New → Text document option.
Step3: To display Drawing Toolbar, Click on View → Toolbars → Drawing
option.
Step4: Drawing objects toolbar appear at the bottom of the screen.
Step5: Select the drawing tool and click-and-drag on the document, now the
selected drawing object is inserted into the document. This process
continues for inserting all the drawing objects (smiley face, rounded
rectangle, ellipse).
Step6: To group the above drawing objects, hold shift key and keep on
selecting all the drawing objects one by one.
Step7: Select Format → Group → Group option.
Step8: This process will group all three selected drawing objects, Save the
document.

5
Ex: No. 5

Creating a Template
Create a Template and save the current styles and appearance of a document.

Aim: To create a Template and save the current styles and appearance of a
Writer document using LibreOffice Writer.
Procedure:
Step1: Open LibreOffice and Select Writer Document.
Step2: Create or open the document whose template is to be created.
Step3: Select File → Templates → Save.
Step4: The Save As Template dialog box appears.
Step5: Select the category of the template.
Step6: Click and select Set As Default Template check box.
Step7: Click Save button to save the template with an extension .ott .

6
 CALC
SPREADSHEET

7
Ex: No. 6

Consolidating Data
A MNC company having two branches namely ABC and XYZ. We have the Sales
records for the month of January and February of both the branches in two
different sheets named ABC_Branch and XYZ_Branch. Now we must
consolidate these two sheets to get the sum of both the sheets monthly to get
the insight about the sale as per product and branch.

Aim: To consolidate sum of Products in two different sheets named

ABC_Branch and XYZ_Branch into Result sheet using LibreOffice Calc
Spreadsheet.
Procedure:
Step 1: Open the Spreadsheet with two sheets ‘ABC_Branch’ and ‘XYZ_Branch’.
Step 2: Add a new sheet and rename it as ‘Result’.
Step 3: Click on Data → Consolidate. The Consolidate dialog window will open.
Step 4: In the Function box, choose Sum function from the drop down as we
want to add the data from all the sheets.
Step 5: Click in the Source data ranges box and then click on the worksheet
ABC_Branch and select the area to be consolidated and then click on
the Add button will add the copy reference in the consolidation ranges.

8
Step 6: Click on the sheet XYZ_Branch and select the area to be consolidated
and then click on Add will add the next consolidation range.
Step 7: Click on the ‘+’ sign next to Options in the Consolidate dialog window
to change the settings.
Step 8: ‘Consolidate by’ has two options Row labels and Column labels. Check
row label or column label or both if we want to consolidate it by
matching the label.
Step 9: Click on ‘Copy results to’ and then click on any of the cell in the ‘Result’
sheet where we want to copy the result after consolidation.
Step 10: Click on OK button will display the ‘Result’ sheet with data after
consolidation.

9
Ex: No. 7

Subtotals
The marks secured in various subjects by students of Class X as shown in the
table given below. To take out the average of the subjects scored in each class,
use the subtotal tool which automatically group the data on a particular
column and perform the selected function on any of the column.

Aim: To find the average of the subjects scored in each class, use the subtotal
tool which automatically group the data on a particular column and perform
the selected function on any of the column using LibreOffice Calc Spreadsheet.
Procedure:
Step 1: Open the Spreadsheet Calc.
Step 2: Create a sheet with above data to take the marks for students in a term
for a class.
Step 3: Now, to calculate the average marks scored by the students of each
class in each subject by class-wise and subject analysis.
Step 4: Click on Data → Subtotal. The subtotal dialog box will appear.
Step 5: Choose the column, Class under Group by in the 1st Group on which
we need to group the whole data. Also, select the subjects English,
Maths, Language, Science and Social Science under Calculate subtotals
for. For each subject click on the Average under Use function
individually otherwise Sum function will be used by default.

10
Step 6: Click OK, now we get the average marks of students by class-wise and
subject-wise.

11
Ex: No. 8

What-if Analysis Tool

Calculate the profit on annual series of sale depending on the Selling Price,
Cost Price, and Fixed Cost expenses.

Aim: To calculate the profit on annual series of sale depending on the Selling
Price, Cost Price, and Fixed Cost expenses using LibreOffice Calc Spreadsheet.
Procedure:

Step 1: Create the sheet as given data above.

Step 2: In Cell B6 enter the formula = B5 * ( B2 – B3) – B4
Step 3: Select the cell range from D3:E11
Step 4: Click on Data → Multiple Operations will display the Multiple
operations dialog window.
Step 5: We have formula in cell B6, as we want to use the same cell address to
be copied therefore, we have used absolute cell referencing and written
it as $B$6.
Step 6: In this, we have another variable as number of items sold which is in
the cell $B$5.
Step 7. Click on OK will generate a result sheet with multiple operations.

12
Ex: No. 9

Goal Seek
A student has received marks in 4 subjects and must appear for the 5th
subject and plans an aggregate as 70. So, he can use goal seek tool to check
how many marks he must score in the 5th subject to get the required
percentage.

Aim: To find the mark of 5th subject by using goal seek tool in LibreOffice Calc
Spreadsheet.
Procedure:
Step 1: Create the marksheet as given data above. Enter the average function
in cell B7 as = Average(B2:B6).
Step 2: Click on Tools → Goal Seek will display the Goal seek dialog window.
Step 3: Write the cell address of the formula B7 in the Formula cell box.
Step 4: Write the cell address of the cell which is to be generated by the
system in the Variable cell box. In cell B6 which we want to be filled as
per the average marks needed.
Step 5: Enter the result in the Target value box. we have to get minimum 70
aggregate so we will write 70 in the target value.

13
Step 6: Clicking on OK will display an error as LibreOffice Calc will not accept
the Variable cell to be empty. So, this error dialog window will prompt
to add 0 value in the variable cell.
Step 7: Click on Yes and then repeat the step 2 will display the dialog window
and prompts whether to change the cell with the calculated value.
Step 8: Click on Yes will change the value with the calculated one in the sheet.

14
Ex: No. 10

MACROS
Record a macro to apply the following style to the Heading “Data Analysis” in
the cell A1.
The font style should be “Times New Roman.” The font size should be “14”.
The font color should be “Blue.” Cells from A1 to G1 should be merged and
centered.
Run the macro.

Aim: To record a macro to apply the different style and run the macro to get
those styles in new sheet using LibreOffice Calc Spreadsheet.
Procedure:
Step 1: Create the spreadsheet. Write the heading “Data Analysis” in cell A1.
Step 2: Choose Tools → Macros → Record Macro. Perform the actions
mentioned below in the spreadsheet.
(a) The font style should be “Times New Roman.”
(b) The font size should be “14”.
(c) The font color should be “Blue.”
(d) Cells from A1 to G1 should be merged and centered.
Step 3: Click Stop Recording to stop the Macro Recorder.
Step 4: The Basic Macro dialog appears, in which you can save and run the
macro.
Step 5: A Standard library is present by default when a spreadsheet is created
and saved.
Step 6: To save the macro, first select the object where we want to save the
macro in the Save macro in list box. The Main macro is saved by default
in the Standard Library in Module1. We can change the name of the
macro as “Formatheading.”

15
Step 7: To run the previously created Macro “Formatheading.” Open a new
sheet to run macro.
Step 8: Open the Macro selector dialog box by clicking
Tools → Macros → Run Macro.
Step 9: Click on MyMacros → Standard → Module1. Then select
“Formatheading” from the Macro Name box and click Run.
Step 10: Now all the formatted styles in Macro were appeared in the sheet.

16
 BASE
DATABASE

17