1.
How to create New, Save, Open, Close the Document in
Libre Office Writer?
AIM: To create New, Save, Open, Close the Document in Libre Office Writer.
PROCEDURE:
Open Libre Office Writer.
CREATE:
Create New Documents by using FILE menu New Text Document
(OR)
Press CTRL+N together to create a document.
SAVE:
Now save the file by clicking on the menu FILE menu Save (CTRL+S).
Then name in file name box.
OPEN:
To open the document click on FILE menu Open (CTRL+O).
CLOSE:
To close the document click on FILE menu Close (CTRL+Q).
(OR)
Click on “X” on the top right corner.
RESULT:
The above steps are executed successfully.
2. How to Move, Copy, Paste the text in Libre Office Writer?
AIM: To Move, Copy, Paste the text in Libre Office Writer.
PROCEDURE:
Open Libre Office Writer and enter some text.
MOVE (or) CUT:
Select the text and click right button of the mouse and select CUT option
or press CTRL+X.
COPY:
Select the text and click right button of the mouse and select COPY
option or press CTRL+C.
PASTE:
Place the cursor where the text as to be duplication click right button of
the mouse and select PASTE option or press CTRL+V.
RESULT:
The above steps are executed successfully.
3. How to Find and Replace the word in Libre Office Writer?
AIM: To Find and Replace the word in Libre Office Writer.
PROCEDURE:
This feature is used to search for a text and replace it with other text.
Select EDIT FIND and REPLACE the dialog box will open.
Type the text to find the find box.
To change the text with different text enter the new text in the
replace box or press CTRL+F.
RESULT:
The above steps are executed successfully.
4. How to Format a document in Libre Office Writer?
AIM: To Format a document in Libre Office Writer.
PROCEDURE:
FORMATING A TEXT:
Open Libre Office Writer and enter some text.
(i) Font Size, Type, Colours, Style:
Select the text to change the size of the font.
Click on properties available at side bar.
Select appropriately font size.
Select everyone Font Type from Font drop-down menu.
The bold text, select the text end then find the buttons
representing the letter Bold (B), Italic (I), Underline (U) in
Formatting toolbar (or) the shortcut keys for Bold CTRL+B,
Italic CTRL+I, Underline CTRL=U.
(ii) Align Paragraph:
The paragraph can be aligned as Left, Right, Centre and Justify to align
the text, select the text and then select the appropriate tool (Left, Right,
Centre and Justify).
(iii) Bullets and Numbering:
Insert tab in menu bar and then select Bullets and Numbering
option.
A dialog box will appear with Bullets and Numbering symbols select
one option. Then we use Bullets and Numbering.
5. How to Insert Table of Content for a Document in Libre
Office Writer?
AIM: To Insert Table of Content for a Document in Libre Office Writer.
PROCEDURE:
To Create Table of Content for document first we have to create a
document.
And then make sure that all the Headings are styled consistently or not.
Means we have to use the Heading1 Style for chapter title and the
Heading2 and Heading3 for chapter subheadings.
Now go to first page of the document and click Insert Indexes Table
Indexes and Table.
Select Index / Table tab and give name to the Index is created.
RESULT:
The above steps are executed successfully.
6. How to Formatting range of cells with Decimal Places, as
Date, as Time, and Alignment?
AIM: To Formatting range of cells with Decimal Places, as Date, as Time, and
Alignment.
PROCEDURE:
Select the Range of Cells makes right click on it select Format Cell
option.
Format cells dialog box will open.
(i) To Format Decimal Places:
Click on the Number tab.
Change the Decimal Places as required.
(ii) To Format Cell Range as Date:
Click on the Date tab.
Select the Date Format.
Click OK.
(iii) To Format Cell Range as Time:
Click on the Time tab.
Select the Time Format.
Click OK.
(iv) To Format Alignment of Cell Range:
Click on the Alignment tab.
Select Left, Right, and Centre option.
Click OK.
RESULT:
The above steps are executed successfully.
7. How to Copying Formula by using File Handle?
AIM: To Copying Formula by using File Handle.
PROCEDURE:
Select the Cell which contains the formula.
Click the Small Black Square in the bottom right corner of the selected
cell.
Drag the File Handle Up to the required cell.
RESULT:
The above steps are executed successfully.
8. Perform Mathematical Operations on below table?
G7 >
A B C D
1 5 5 7 8
2 8 7 4 7
3 5 5 8 7
4 1 8 8 2
5
AIM: Mathematical Operations in Libre Office Calc.
PROCEDURE:
The Sum of Cells in the range of cells from B1 to C2 is: = sum (B1:C2)
Output is 23.
To Multiply the values in A1, B1 cell formula is: = (A1*B1).
Output is 25.
To Subtract two values in D1, A1 cell formula is: = (D1-A1).
Output is 3.
To Divided two values in A1, B1 cell formula is: = (A1/B1).
Output is 1.
To Average of cells in the range of cells from A1, C1: = AVERAGE (A1:C1).
Output is 5.6.
Finds out the Largest Value among cells range of cells from A2 to C2 and
the cell B3 = MAX (A2:C2:B3).
Output is 8.
Find out the Range of Cells from B1 to C2 and the cell A1= MIN (A1:B1:C2).
Output is 4.
Counts the number of cells that contains number of range of cells from
A1 to C1 = COUNT (A1:C1).
Output is 3.
RESULT:
The above steps are executed successfully.
9. How to create Charts form given Spread sheet Data?
AIM: To create Charts form given Spread sheet Data.
PROCEDURE:
Follow the steps given below to create Charts.
Enter the data which we want to convert into chart.
Select the Range of Data (A1:F7).
Insert Chart.
Select the Type of Chart.
Select the Chart (Column Chart).
Click Finish a Chart as shown in figure will be display.
RESULT:
The above steps are executed successfully.
10. How to Insert New Row or Column in Libre Office Calc?
AIM: To Insert New Row or Column in Libre Office Calc.
PROCEDURE:
To Insert Column:
To Insert the Column or Row, position the cursor or any cell of the
column before which you want to insert the column and select.
Sheet Insert Columns Columns Columns left .
Similarly, to Insert the Column to the Right select Sheet Insert
Columns Columns Columns right.
To Insert Row:
Sheet Insert Row Rows Rows left
Similarly to Insert Row Rows Rows right.
11. How to Record Macro in Libre Office Calc?
AIM: To Record Macro.
PROCEDURE:
To enabled macro in Libre Office Calc go to Tools Options Libre
Office Advanced and selected the enable macro recording option.
To start recording macro by clicking Tools Macros Record Macro
The Record Macro dialog box is displayed with a Stop Recording option.
Now recording sheet actions were started.
After completion of actions click on stop recording button.
Now Save Macro dialog box will appear gives the name to the macro
and save it.
Use the Macro:
To use macros go to Tools Macro Run Macro
Now Macros dialog box will appear, select location and name of the
macro where we saved.
Click on Run, Macro will run.
RESULT:
The about steps are executed successfully.
12. Perform below Operations: (i) Creating a Presentation
(ii) Selecting Slide Layout (iii) Save the Presentation
(iv) Running a Slide Show (v) Closing a Presentation?
AIM: Operations on Libre Office Impress.
PROCEDURE:
(i) Creating a Presentation:
To create a new blank presentation, select the File menu New
or click on the icon: New or use the combination of keys CTRL+N.
(ii) Selecting Slide Layout: Slide Slide Layout Title Slide.
(iii) Save the Presentation:
To save the Presentation you are working on follow the steps as
given below: select the File menu Save, or use the shortcut keys
combination CTRL+S, or click on the save button on the standard
toolbar.
This will open the save dialog box which allows the select the
location on the disk and assign the name to save the presentation.
(iv) Running a Slide Show:
To run the slide show, click Slide Show Start from First Slide on
the main menu bar or click the Slide Show icon on the presentation
toolbar or the Slide Sorter toolbar or press F5. The slide shown starts
to run press any key on the keyboard to exit the presentation.
(v) Closing a Presentation:
To close a presentation, select File menu Close or use the
keyboard shortcut keys CTRL+N.
RESULT:
The above steps are executed successfully.
13. How to Insert an Image and how to Format the Image?
AIM: To Insert Image and perform Format option on Image.
PROCEDURE:
Insert an Image:
To Insert an Image from the Gallery.
Select Insert Media Gallery from the Menu. The
Gallery displays the available themes with images.
Select suitable images.
Click on the Image and drag on to the workspace.
Replace the mouse button and the Image will be placed into
your slide.
Format the Image:
(i) Moving Image:
To move the image in the slide, click on an image,
observe that the cursor changes the four arrow symbol.
Click and drag the Picture to the desired position.
Release the mouse button.
(ii) Resizing Image:
Select the image by clicking on it, observe that Selection
Handles displayed.
Position the cursor over one of the Selection Handles.
The cursor changes the shape giving a graphical
representation of the direction of the resizing.
Click and drag to Resize the Image.
Release the mouse button when satisfied with the new
image.
(iii) Rotating Images:
The image can be rotated in any direction using the
rotate icon to manually rotate an image.
Select the image to display the selection handles.
Click the Rotate Icon on the line and Filling toolbar.
RESULT:
The above steps are executed successfully.
14. How to Draw Group and Ungroup the Graphic Objects?
AIM: To Draw Group and Ungroup the Graphic Objects.
PROCEDURE:
Drawing Graphic Objects:
The Drawing toolbar having the majority of the tools used to
create graphical objects to activity this tool bar, select View Toolbars
Drawing from main menu bar.
a. Drawing Lines
b. Drawing Shapes
Grouping objects:
More than one object can be grouped together and treated as
single objects. Single Object, Moved, Rotated, Deleted, and so on to group
objects together.
Select the objects to be grouped using selection tool on the Drawing
Toolbar or hold down the Shift key and click on each object to all the
object go to Edit Select All (CTRL+A).
When the Selection Handles are displayed go to Format Group
Ungroup on the menu bar or use the keyboard combination
CTRL+ALT+SHIFT+G.
RESULT:
The above steps are executed successfully.
15. How to Add transitions the Libre Office Impress?
AIM: To Add transitions the Libre Office Impress.
PROCEDURE:
In the side bar select the Slide Transition icon to open the Slide
Transition section.
In the Slides Pane or Slide Sorter View, select the slides to apply the
Transition. It will applicable to current slide only. If you want to apply
the transition to all slides Do not select any slides.
In the apply to select a slides list, select a transition.
RESULT:
The above steps are executed successfully.
16. How to Insert a Table in Libre Office Impress?
AIM: To Insert a Table in Libre Office Impress.
PROCEDURE:
Tables are inserted by selecting the Table icon on the standard toolbar.
A Table can be inserted from the Insert tab by selecting Insert Table
in the Insert Table dialog box. The number of columns and the number
of rows are specified.
RESULT:
The above steps are executed successfully.
17. How to Create a Database and Table in Database using
Libre Office base Software?
AIM: To Create a Database and Table.
PROCEDURE:
Open Libre Office base and click on creating a new Database Next
Finish.
Give the name to Database on File Name box.
Click on Save.
Creating Table in Database:
Open a Database which we saved earlier.
Click on Table; enter the column names in field name box.
Enter the Data type related to field name in field type box.
In the description field you can enter some notes about the field.
Select the length of the data in Database on length box.
Now go to File Save, Save dialog box will appear.
Give the name to Table in table name box.
Click OK.
RESULT:
The above steps are executed successfully.
