1. Create a document and apply Styles and Formatting in LibreOffice Writer.

❖ Paragraph Style, Character Style, Frame Style, Page Style, List Style
Open LibreOffice Writer and Type the paragraph that you want to apply style and
formatting.
Select Styles and Formatting option from Format menu or from standard toolbar or
press F11.
❖ Paragraph Style – Select Paragraph style → right click the mouse button and
select New to create new paragraph style and name it as New Style.
i. Paragraph Style dialog box appears.
• Change Background color
• Change Font
• Apply drop cap
ii. Click OK

iii. Select the typed paragraph and double click on New Style from Paragraph Style.

1
Follow the same steps to apply Character Style, Frame Style, Page Style, List Style.

2
2. Insert an image and perform the following in LibreOffice Writer.
❖ Modify the image
❖ Resize the image
❖ Rotating the image

For inserting an image, select one option from the following:

• Drag and drop, Insert Picture Dialog, From Clipboard, From Gallery or Using
Scanner.

❖ Modifying the Image: – Select the picture and modify it using the Picture Tool.

Resize the image:

• Click the picture to show the resizing handles as above.
• Position the pointer over one of the resizing handles. The pointer changes shape
giving a graphical representation of the direction of the resizing.
• Click and drag to resize the picture.
• Release the mouse button when satisfied with new size.

3
 Rotate the image:
• Open File → New → Drawing and insert the picture.

• Select to rotate the image.

• Position the pointer over the red handle rotate the picture.

4
3. Create drawing objects and perform the following in LibreOffice Writer.
❖ Resizing and Coloring
❖ Grouping
❖ Apply any three Graphical properties.
• Select View→ Toolbar→ Drawing
❖ Resizing and Coloring
• Draw the images and resize it using the green handles.
• Select the colors from property window and fill it.

5
❖ Grouping
• Select the pictures to be grouped by holding the shift key.
• Right click the mouse button and click group.
• The selected pictures become a single picture.

6
 ❖ Apply three Graphical properties:
1. Send to Back:
• Select the picture to be placed at the back of given image.
• Right click the mouse button. Arrange → Send to back.

2. Alignments:

7
3. Wrapping:

• Select the picture and right click the mouse button to choose Wrap.

8
4. Create a template in LibreOffice Writer.
❖ From a Document.
• From a Document.
• Type the content in the Writer and save it.
• Open the designed template in any file.

9
5. Create a table and perform the following in LibreOffice Writer.
❖ Merge cells
❖ Add images and Colour to a cell.

❖ Merge cells
• To insert table: Select Table Insert Table (ctrl + F12) and specify number of
rows and columns.
• Select the cells to be merged. Table Merge Cells.

❖ Add images to a cell:

• Follow any of the methods learned to insert a picture.
• Tools → Gallery

10
 • Select the cell and insert the pictures.

❖ Add colors to a cell:

• Select the cells and fill background Colour from Table properties.

11
6. Create and customize Table of Contents and perform the following in LibreOffice
Writer.
❖ Change the color and apply styles.
❖ Set hyperlink for chapters.
❖ Remove page number from chapter names.

❖ Change the color and apply styles.

• Create the document
• Select Insert → Index and Tables.
• Change the color by selecting the Background Tab.
• Change the styles by selecting the Styles tab.
❖ Set hyperlink for chapters.
• Set the hyperlink by Selecting Entries Tab.
• Select the level and set hyperlink LS and LE for the chapter name.
❖ Remove page number from chapter names.
• Select the Entries Tab.
• Select the level from which you want to remove page number.
• From the Structure select page number and press delete button .

12
7. Prepare a Leave application using Mail Merge feature of LibreOffice Writer.
• Select Tools → Mail Merge Wizard
• Click, Select Address List
• Create database and save,

• Enter addresses by setting necessary fields.

• Save the table.

• Insert address block.

13
14
• Create a salutation.

15
• Adjust layout

• Preview and edit the document.

• Edit individual document.

• Save the document and generate Mail Merged letters.

16
Sample Documents

17
8. YOUTH BANK has its deposit and withdrawal detail of 3 months. Help them to prepare
a CONSOLIDATED DATA for the above years using LibreOffice Calc.

• Enter the deposit and withdrawal of customers for each month in different
sheets.

• Select Sheet in which you need the consolidated report.

• Select Data → Consolidate
• Add consolidation ranges by selecting sheets. Click OK.

18
CONSOLODATED DATA

19
9. STAR Distributers distributes products in different areas. Calculate the area wise
distribution of products using SUBTOTALS IN LibreOffice Calc.
• Enter the data and select the entered data.

• Select 1st Group tab. From the Group by box select Place and click the check boxes in
the calculate subtotal box.
• Click OK.
• District wise Total products distributed, and Grand Total will be displayed.

20
10. Prepare a SCENARIO TO CALCULATE Simple Interest for different principal
amounts, rate of interest and year in LibreOffice Calc.
• Enter Principal Amount, Rate of interest and year. Calculate Simple Interest using the
formula SI = (P*N*R)/100
• Select the entered data.
• Select Tools Scenarios.
• In the dialog box type the scenario name and select a boarder colour.
• Click OK.

• Create different scenarios and save it.

21
• To switch between different scenarios, click the right corner arrow.

• For Edit the scenario, select View Navigator (F5).

Select the scenario to be edited and click OK.

22
11. Prepare a SCENARIO TO CALCULATE Simple Interest for different principal
amounts, rate of interest and year in LibreOffice Calc.
• Enter Principal Amount, Rate of interest and year. Calculate Simple Interest using the
formula SI = (P*N*R)/100
• Select the entered data.
• Select Tools Scenarios.
• In the dialog box type the scenario name and select a boarder colour.
• Click OK.

• Create different scenarios and save it.

23
• To switch between different scenarios, click the right corner arrow.

• For Edit the scenario, select View Navigator (F5).

Select the scenario to be edited and click OK.

24
12.A student is planning her goals about the marks she should attain in the forthcoming
Semester 4 examinations in order to achieve a distinction (75%). Assuming that
examination of each subject is for 100 marks, her marks for the previous semester are
given as below. (Use GOAL SEEK in LibreOffice Calc). ATIONS in LibreOffice Calc.

Subject 1 Subject 2 Subject 3 Subject 4

Semester 1 82 67 53 87
Semester 2 88 78 76 69
Semester 3 89 85 91 67
th
Find out how many marks she should obtain in 4 semester to secure distinction.
• Enter the data into LibreOffice Calc as given and leave row for Semester 4 marks
and Percentage.

• Select Percentage column of Subject 1 and apply formula to calculate percentage.

(S1+S2+S3+S4)/4
• Select Tools → Goal Seek

25
• Enter formula cell address, Target value and variable cell address as Semester 4
cell address.
• Click OK
• Apply the same for other subjects.

26
13. Using SOLVER option in LibreOffice Calc, project the simple interest amount by
changing principal amount while calculating simple interest.
• Enter Principal Amount, Rate of Interest and year. Calculate Simple Interest
using the formula SI = (P*N*R)/100.

• Select Tools → Solver

• Fix the Interest to 1500 by changing value of Principal.
• Specify the corresponding cell address.

• Click Solve.

27
14. Create a MACRO for applying a similar formula for similar range of data in
LibreOffice Calc.
❖ Record a macro
❖ Run a macro
• Open a spreadsheet to create a macro.
• Click on Tools → Macros → Record Macro and start performing the
action.

• Click on Stop Recording. The Basic Macros dialog box appears

28
• Follow the steps to save Macro.

29
 ❖ Run a macro
• Select the cell where you want to apply the macro.
• Click on Tools → Macros → Run Macro .

• The Macro Selector dialog box appears. Select the desired macro from Macro
name list box.

30
• Click the Run button. Macro will get executed.

31
15. a) Create a database in LibreOffice:
i) Create a Student table with attributes Roll No. (Set as Primary key), Name, Class,
Total Marks using Create Table in Design View option.
ii) Insert records into the Student table.
iii) Display all records using SQL.
iv) Sort the records in descending order of Total Marks.
v) Display the details of the Student with Roll no. 4
b) Create Form using Wizard.
c) Create Report Using Wizard.

a) Create a database in LibreOffice:

i) To create a Student table with attributes, Roll No. (Set as Primary key), Name,
Class, Total Marks using Create Table in Design View option.

• Open LibreOffice base database.

• Click on Tables. Select Create Table in Design View option.

• Type required Field names, Field Types and applicable Field properties .

32
• Click on Save and in next window type Student as Table name.
• Student table created.

ii) Insert records into the Student table.

• To Insert records into the Student, click on Student table, it will get open to insert
records.

33
• Type all records and save.

iii) Display all records using SQL.

• To display all records from Student table, select Queries from database bar and
select Create Query in SQL view.

34
• Type command
SELECT * FROM “Student”
And save Query.

• Click on saved Query, records will be displayed.

35
 iv) Sort the records in descending order of name.
• Type command
SELECT * FROM “Student” ORDER BY “Total_Marks” DESC;
And save Query.

36
 v) Display the details of the Student with Roll no. 4
• Type command
SELECT * FROM “Student” ORDER BY “Total_Marks” DESC;
And save Query.

37
 b) Create Form using Wizard.
• Select Form from database bar and select Use Wizard to Create Form.

• Select the Table and move fields to Form and click Next.

• Tick the Check box and Add Subform and click next.

38
• Add the fields and click Next.

• In the arrange control wizard select the arrangement of Main form and Sub form.
Click Next.

39
• Click Next for Data Entry Wizard.
• In the Apply Styles Wizard select the color and click Next.

• Type name for the Form and click Finish.

40
 c) Create Report Using Wizard.
• Select Reports from database bar and select Use Wizard to create Report.
• Select Fields and Click Next.

41
• Select Labelling Fields and Click Next.

• Select Grouping. Click Next.

• Select Sort options. Click Next.
• Choose desired layout and Click Next.

42
• Give a name to Report and Click Finish.

43