Practical Programs : Libre OfficeWriter
Question 1:
Write the steps to apply styles in a document
Aim:
To write the steps to apply styles in a document
Procedure:
Step 1 : Start All Programs Libre Office Text Document
Step 2 : Type the following text
Styles and formatting
Paragraph Styles
Character styles
Frame Styles
Page Styles
List Styles
Step 3 : To change the font type : Arial Narrow , Font size : 12 , Font colour : Red and apply
heading as bold , italic and underline.
Step 4 : Place the cursor in the text and click format styles and formatting option or F11.
Step 5 : Select list styles icon and choose any list style and then double click.
Step 6 : Save the file.
Result : The list styles are applied successfully.
Question 2 :
Write a program to make a picture using drawing objects and group option.
Aim :
To write a program to make a picture using drawing objects group option.
Procedure:
Step 1 : Start All Programs Libre Office Text Document.
Step 2 : Click View Tool bars Drawing
Step 3 : Select the drawing tools to make the following picture.
Step 4: Select all the shapes by holding down the shift key.
Step 5 : Click Format Group Group option.
Step 6 : Save the file.
Result:
The Picture was create and grouped successfully.
Question 3:
Write a program to create a text document using text wrapping option.
Aim :
To write a program to create a text document using text wrapping option.
Procedure:
Step 1 : Start All Programs Libre Office Text Document.
Step 2 : Type the following and insert the picture.
Happiness is an emotional state characterized by feelings of joy, satisfaction, contentment,
and fulfilment. Kindness towards nature, animals and other people has the ability to transform the
world and make it a beautiful place for living. Kindness is basically being polite, compassionate
and thoughtful.
Step 3: Select the picture and click Format Wrap apply following wrap options.
(Page wrap, Optima page wrap, Wrap Left , Wrap Right, Wrap Through)
Step 4 : Save the file.
Result : The text wrapping options was applied successfully.
Question 4:
Write a program to create a table of contents.
Aim :
To write a program to create a table of contents.
Procedure:
Step 1: Start All Programs Open Office Text Document.
Step 2 : Create 5 pages document and apply styles and formatting keep the cursor in page 1.
Step 3 : Click Insert Index and tables
Step 4 : Do the following
• Change the title.
• Apply the Hyperlink
• Apply the Background option
Step 5 : Save the file.
Result : The table of contents were created successfully.
LIBRE OFFICECALC
Question 5:
Write a steps to create a spreadsheet as given table and display the sum according to items
and then company.
Aim:
To create a spreadsheet as given table and display the sum according to item and then
company.
Procedure:
Step 1: Start All programs Libre OfficeLibre OfficeCalc.
Step 2: Create the given table.
Step 3: Select the range of data with column heading.
Step 4: Click on data Subtotals , Subtotals dialog box appears.
Step 5: In 1st Group by box, select the item column.
Step 6: In 2nd Group Group by box, select the company column.
Step 7: In calculate subtotals for box, select Quantity column.
Step 8: Select the function sum from the use function box.
Step 9: Click Ok.
Step 10: Save the file.
Result: The subtotal was calculated successfully.
Question 6:
Write a steps to create consolidation mark statement.
Aim:
To write a steps to create consolidation mark statement.
Procedure:
Step 1: Start All programs Libre Office Libre OfficeCalc.
Step 2: Create a four tables sheet name as Term-1,Term-2,Term-3, Final.
Step 3: Click on Data consolidation the consolidation dialog box appears.
Step 4: In source data range select C3:E7 in PA-1 sheet and click add button.
Step 5: In source data range select C3:E7 in PA- 2 sheet and click add button.
Step 6: In source data range select C3:E7 in PA-3 sheet and click add button.
Step 7: In copy result to tab, select C3:E7 in Final Mark sheet and click ok button.
Step 8: Save the file.
Result : The marks were consolidate successfully.
Question 7:
Write a steps to calculate the total marks to achieve 95%.
Aim:
To write a steps to calculate the total marks to achieve 95%.
Procedure:
Step 1: Start All programs Libre Office Libre Office Calc.
Step 2: Create table as given.
Step 3: Click B3cell and type = B1 / B2.
Step 4: Click Tools Goal Seek. The Goal Seek dialog box appears.
Step 5: In formula cell tab select cell B3.
Step 6: In Target value tab type 95.
Step 7: In variable cell tab select cell B1.
Step 8: Dialog box appears click yes.
Step 9: Save the file.
Result : Total mark was successfully calculated.
Practical Programs : Libre OfficeBase
Question 8:
Write the steps to create a table in Libre OfficeBase
Aim:
To write the steps to create a table in Libre OfficeBase
Procedure:
Step 1 : Start All Programs Libre Office Data Base
Step 2 : Choose Create a new database and click the Next Button.
Step 3 : Click the Finish Button and Save the file
Step 4 : Click Table in Data Base Pane and click Create Table in Design View..
Step 5 : Assign the following fields
Field Name Field Type
Order_ID Text [VAR CHAR]
Order_Date Date[Date]
Customer_ID Text [VARCHAR]
Amount Decimal[DECIMAL]
Step 6 : Enter the following details in table.
Step 7 : Save the table.
Result : The table was created successfully.
Question 9 :
Write a program to create form in Libre OfficeBase.
Aim :
To write a program to create form in Libre OfficeBase.
Procedure:
Step 1 : Start All Programs Libre Office Data Base
Step 2 : Create a table using design view
Step 3 : Click Forms in Data Base Pane and click Use wizard to create a form.
Step 4: In form wizard click Field Selection and choose table as Product, change the all
fields to field in form and click the Next button
Step 5 : Click setup a sub form option and click the Next button.
Step 6 : Click Arrange controls and choose the any option and click the Next button.
Step 7 : Click Set data entry choose The form is display all data and click the Next
button.
Step 8 : Click Apply Styles and choose Apply Styles = Violet , Field Border = 3D look
and click the Next button.
Step 9: Click Set Name and type Product Details and click the finish button.
Step 10 : Save the file.
Result:
The Form was created successfully.
Question 10:
Write a program to create a report in Data Base.
Aim :
To write a program to create a report in Data Base.
Procedure:
Step 1 : Start All Programs Libre Office Data Base
Step 2 : Create a table using design view
Step 3 :Click Report in Data Base Pane and click Use wizard to create a Report.
Step 4: In Report wizard click Field Selection and choose table as Mark list, Change all
the fields to fields in report and click the Next button.
Step 5: Choose Labeling fields option and click the next button.
Step 6: Click Grouping option and click the Next button.
Step 7: Choose the Sort options and click the Next button.
Step 8: Click Choose layout option and click the Next button.
Step 9: Click create report option and click the Next button.
Step 10: Save the files fully.
