Name Khushi Kumari
Class & Sec IX-D
Roll No.: 17
Subject I.T (Practical)
Session 2025-26
Subject Tr Ravindra Sir
Unit 1
Digital Documentation (Advanced) using
LibreOffice Writer
PRACTICAL -01
How you will open the Styles and Formatting window in a document using
LibreOffice writer and how you will apply the style in the document. Explain any
three different types of styles and paste the screenshot of the style and formatting
window.
Answer: LibreOffice Writer provides different types of tools to apply predefined style or
formatting in a document. This style or formatting helps to maintain uniformity in font
size, font face, spacing, heading or overall layout in the documents. There are six
different types of Styles in LibreOffice Writer:
(a) Paragraph Styles,
(b) Character Styles,
(c) Page Styles,
(d) Frame Styles,
(e) List Styles and
(f) Table Styles.
There are several ways to open Style and Formatting window in LibreOffice –
Click on Format > Styles > Manage Style
To open style and formatting window press F11
Using Sidebar Menu
Using Style Drop Down list box from toolbar
Page Styles – Page style is used to define basic page layout like page size, border,
background or footnote etc. You can apply many page styles in a document. If the page
style is not declared then the user can define the default page style.
Paragraph Style – Paragraph style helps to organize the content in paragraphs.
Paragraphs formatting includes border, tab stops, text alignment and line spacing etc. It
also includes character style attributes.
Character style – This style is used to change the appearance of the characters. This
style includes text color, highlighting text, text size and emphasizing it.
PRACTICAL -02
What do you mean by the Fill Format tool in LibreOffice Writer and how you will
apply the same style to multiple sections quickly.
Answer: Fill format is a quick method to apply the same style in different locations in the
document. In Manual formatting every time we have to select the text and we have to
apply the style which takes a lot of time. Instead of manual method we can use the Fill
Format method to apply the style quickly.
Apply the same style to multiple sections quickly using following steps –
Step 1: Open LibreOffice Writer
Step 2: Open Style window
Step 3: Select the paragraph where the style will be copy
Step 4: Click on Fill Format button
Step 5: Take the mouse pointer to the desired location and apply the style.
Step 6: Repeat step 5 until all the changes have been made
PRACTICAL -03
What is a Table of Contents (ToC) and why is it important in a document? Imagine
you are preparing a project report that has several sections and subsections. You
have been asked to add a ToC to make it more organized and easier to navigate.
Write steps to create Table of Content in LibreOffice Writer.
Answer: Table of content is used to create a list of topics and subtopics that have been
covered in the book along with page number, this table of content you can define with
different types of heading. This table of contents can be inserted automatically in the
document. Hyperlink can navigate directly to the selected topic in the document.
Steps to create a Table of Content in LibreOffice Writer are –
To create a Table of content in the document first you have to use paragraph styles for
headings such as main sections will be Heading 1, subsections will be Heading 2 vice
versa.
Step 1: Click on Insert > Table of Contents and Index
Step 2: Select Table of Contents, Index or Bibliography
Step 3: Click on Entries options in ToC
Step 4: Customize Structure and Formatting
Step 5: Click on OK
PRACTICAL -04
What do you mean by track change and why track change options are used in
documents? How you will use accept or reject the changes option in LibreOffice
Writer.
Answer: Track Changes is used when multiple people are working on a single document
and helps to keep a track of the editing being done by other users. Track change
ensures transparency about the person who made the changes, It makes it easy for
authors to see the suggestions without losing the original text and the accept and reject
change option can be used for canceling or accepting any changes in the document.
We can use following steps to accept or reject the changes in the documents –
Step 1: Click on Accept Track Change/ Reject Track Change button
Step 2: To navigate between the changes, Click on Previous Track Changes and
Next Track Changes.
Step 3: Select Accept All Tracked Changes / Reject All Tracked Changes button
respectively.
PRACTICAL -05
Write the steps for inserting image in the LibreOffice Writer and write the
difference between resize image and text wrapping option in the document.
Answer: LibreOffice Writer allows to insert image, charts, diagrams and shapes using
various tools. In LibreOffice writer can insert images using various ways such as using
drag and drop, using dialog box or using cut and copy option.
Inserting Image using image option are –
Step 1: Click on Insert > Image from menu bar
Step 2: Select the image file
Step 3: Click on Open button to insert image
Resize Image – Resizing Image allows to change the dimensions of the image
(height and width), resizing image can maintain aspect ration.
Text Wrapping – It allows the text to flows around the image and manage the
positioning of the image to the text.
Unit 2
Electronic Spreadsheet (Advanced) using
LibreOffice Calc
PRACTICAL -06
You have the following data of students’ and their marks for Pre Mid Term, Mid
Term and Post Mid Term stored in three different worksheets in the same
workbook. How you will use it to consolidate data features in LibreOffice calc to
summarize the data in a single worksheet that will show the average marks of each
student.
Answer: Consolidate data feature allows to combine data from different sheets and
summarize into one place.
Steps to use consolidate data feature in LibreOffice calc are –
Step 1: Open a Workbook
Step 2: Create a new sheet where the data has to combine
Step 3: Click on Data > Consolidate option
Step 4: Select the function from drop down menu
Step 5: Add Source data ranges
Step 6: Click on check button “Copy results to”
Step 7: Click on “Copy result to” and specify the address where you want to copy
the result
Step 8: Click on “Ok” button
PRACTICAL -07
You have the following sales report, you need to calculate the total quantity sold
for each category using the subtotal feature in LibreOffice Calc. Write steps to
apply subtotals in LibreOffice Calc.
Answer: Subtotals is used to find the subtotals of three arrays arranged in labeled
columns in LibreOffice Calc and sorts the data automatically.
Steps for using subtotal are –
Step 1: Click on Data > Subtotals
Step 2: Select Column a column where you want to apply subtotal
Step 3: Select any functions like sum, count, min, max or average etc.
Step 4: Click OK
PRACTICAL -08
What do you mean by Macro? Write the steps to record Macro in LibreOffice calc.
Answer: Macro is used to perform the same task multiple times using formulas. Macros
helps to use to do the same task multiple times.
Follow the following steps to record a macro –
Step 1: Click on Tools > Macros > Record Macro
Step 2: Start doing actions which you want to record
Step 3: After completion of your actions, Click on Save Macro
Step 4: Change the name of Macro
Stet 5: Click on Save button
PRACTICAL -09
You want to create a yearly budget and you want to see how different monthly
savings can affect your total savings at the end of the year. Explain the steps how
you will create What-if Scenarios in LibreOffice Calc.
Answer: What if scenarios is used to compare different alternatives depending on the
changing conditions.
Steps for creating Scenarios in LibreOffice Calc are –
Step 1: Select the cells where you want to apply scenarios
Step 2: Click Tools > Scenarios
Step 3: Enter name of Scenarios
Step 4: Click Ok Button
PRACTICAL -10
Amit is working in a shop where he maintains daily sales data. The data includes the Unit Price
and Quantity Sold for multiple products. You are required to:
i. Calculate Total Sales for each product using the formula:
Total Sales = Unit Price × Quantity Sold
ii. Calculate the Overall Total Sales at the bottom of the column.
iii. Use Macros to automate this process so that it can be run again in future without repeating
the steps manually.
Sample Data Table:
Product Unit Price Quantity Sold Total Sales
Pen 10 100
Pencil 5 200
Notebook 25 80
Eraser 3 150
Total
Ans:
