Name -Payal Kumari

Class- 10 Roll no.- 3

Session – 2025-26
Q.1 Write down the steps to create a style in Libreoffice.

Steps: 1) Open the Styles and Formatting window and choose the type of style you want to create.
2) In the document, select the item you want to save as a style.

3) In the Styles and Formatting window, select on the New Style from Selection icon.

4) In the Create Style dialog, type a name for the new style.
Q.2 Write down the steps to create a Template in Libreoffice.

1. Steps: To save a file as a template, select File > Save As.

2. Double-click This PC.

3. Type a name for your template in the File name box.

4. For a basic template, select the template item in the Save

as type list. In Word for example, select Word Template. ...
5. Select Save.

Q.3 Write down the steps to insert an image in Libreoffice.

Steps: 1) Click in the LibreOffice document where you want the image to appear.

2) Choose Insert > Image on the Menu bar or click the Insert Image icon on the Standard toolbar.
3) On the Insert Image dialog, navigate to the file to be inserted, and select it.

4) At the bottom of the dialog is a Link option.

Q.4 Write down the steps to create TOC in Libreoffice.

Steps:1) To create a table of contents

(TOC) in LibreOffice Writer, first, ensure
your document uses heading styles
(Heading 1, Heading 2, etc.) to structure
your content.

2)Then, position your cursor where you

want the TOC, navigate to "Insert >
Indexes and Tables > Indexes and
Tables",
3)select "Table of Contents" as the type, and click OK.

Q.5 Write down the steps to crop an image in LIbreoffice.

1. Steps: Insert the image: Go to "Insert > Picture > From File..." and select the image
you want to use.

2. Select the image: Click on the inserted image to select it.

3. Open the Crop tool: Right-click on the image and choose "Crop Picture...".

4. Adjust cropping handles: You'll see black handles around the image. Drag these
handles inward to crop the image to your desired size and shape.

5. Apply the crop: Click outside the image (or press Enter) to apply the cropping
changes.
Q.6 Write down the steps of Table of Content of Data in the Libreoffice.

Steps: To create a table of contents in Writer,

first click where you want the table to appear.

Then, navigate to Insert > Indexes and Tables > Indexes and
Tables.

In the dialog box, select "Table of Contents" as the type.

Customize the table of contents by selecting options on the

"Index/Table" tab click "OK" to generate it.

Q.7 Write down the steps to consolidate the data in libreoffice Calc.

1. Steps: Open the document that contains the cell ranges to be consolidated.

2. Choose Data > Consolidate to open the

Consolidate dialog.

3. If the Source data range list contains named

ranges, you can select a source. ...

4. Click Add. ...

5. Select additional ranges and click Add after each

selection.

Q.8 Write down the steps of Sub-Total in Libreoffice Calc.

Steps: To use the subtotal feature in Calc,

first, sort your data by the column you want to

group by.

Then, go to Data > Subtotals, choose the grouping

column, the function (like SUM, AVERAGE, etc.),
and the columns for the subtotal.

Finally, click OK to apply the subtotals.

Q. 9 Write down the steps of Scenarios in Libreoffice Calc.

 1. Steps: Open your spreadsheet in LibreOffice
Calc.

2. Select the range of cells that you want to

include in the scenario.

3. Go to the menu bar and click on 'Tools'.

4. Select 'Scenarios' from the dropdown menu.

5. In the Scenarios dialog box, enter a name for

the scenario and set any additional options.

Q.10 Write down the steps to analyse the

data using Goal Seek feature.

Steps: To use Goal Seek:

1. Fill the cell with the unknown data

with a 0 (or any other value). ... To use Goal Seek:

2. Fill the cell with the unknown data with a 0 (or any other value). ...

3. Select the cell containing the Formula (in our example the Average grade) and
Choose Tools > Goal Seek from the main menu.

4. In the Goal Seek dialog window fill in the parameters.

Q. 11 Write down the steps to create a Database in Libreoffice Base.

Steps: Right-click Databases, and then select New Database.

In New Database, enter a database name.

To create the database by accepting all default values.

select OK; otherwise, continue with the following optional steps.

To change the owner name, select (...) to select another owner

Q. 12 Write down the steps to insert data in table.

Steps: Entering Data in Tables

1. Use the Operating tool or the Labeling tool to click inside a cell and

enter the data.

2. Press the <Shift> key while you press the arrow keys to move the
cursor to adjacent cells.
 3. If the VI is in edit mode, press the <Enter> key on the keyboard to move the cursor to
the cell below.

Q. 13 Write down the steps to create Query using Wizard in Base.

Steps: Use the Query Wizard

1. On the Create tab, in the Queries group, click Query

Wizard.

2. In the New Query dialog box, click Simple Query

Wizard, and then click OK.

3. Next, you add fields. ...

4. If you did not add any number fields (fields that

contain numeric data), skip ahead .

Q.14 Write down the steps to insert record in the form.

Steps: Add a record to a table or form

1. Open the table in Datasheet View or the form in Form View.

2. On the Home tab, in the Records group, click New, or click New (blank) record, or
press Ctrl+ Plus Sign (+).

3. Find the record with an asterisk in the record selector, and enter your new
information.

Q. 15 Write down the steps to delete a record in the form.

Steps: To delete a record in a form, first select the record you wish to delete.

Then, either press the DELETE key,

navigate to Home > Records > Delete, or
use the shortcut Ctrl + Minus .

A confirmation dialog may appear before

the record is permanently removed.