Unit-1 Digital Documentation

(Advanced)
1) Write steps for following:
 Apply style to a text
Step 1: Press F11 function key to open the style and
formatting windows or Click on
Format » Styles and Formatting
Step 2: The style window will be open
Step 3: Select text area where you want to apply style
Step 4: Double click on the style which you want to
apply

 Apply style using file format mode

Step 1: Open the Style and Formatting window
Step 2: Select the text from where you want to copy the
format.
Step 3: Click on Fill Format window
Step 4: Click on the location where you want to apply
the Style and formatting, the style will applied
automatically
2.1) Write explanation/steps for following:
 Methods for inserting an image:-
The image file can be inserted in a document using the following different ways.

A) Using Image dialog box:

Image dialog box is a general procedure to insert an image in a writer.

Step 1: Click on Insert > Image from menu bar

Step 2: Select image from dialog box

B) Using Drag and Drop Option:

Using drag and drop you can insert images in the document.

Step 1: Open a file browser window (Win+E) and select the image

Step 2: Drag and Drop the image into the document

C) Using Cut, Copy and Paste option –

Another way to insert an image in the document is by using copy and paste.

Step 1: Select the target file

Step 2: Copy the image using right click or using shortcut key Ctrl+C

Step 3: Place the cursor on the location and use CtrI+V to paste the Image in the
document.

D) Inserting an image by linking –

If multiple copies of the same image you want to insert in the document then you can
use image by linking.

Image by linking is beneficial to save the link of the image instead of inserting the image
in the document.

Step 1: Click on Insert Image dialog box

Step 2: Click on Link option

 Settings for positioning within the text
Positioning Image in the Text
Positioning Image can be used for text and other images or
drawing objects in the document.
In LibreOffice the positioning of an image is controlled by
four settings.
1. Arrangement: Arrangement is used to arrange the position
of an image, drawing object or text, if any image is overlapped or
not arranged properly in writing in that condition you can take
the help of arrangement.
2. Anchoring: Anchoring allows an image to retain its position
to a page, Paragraph, character or frame.
3. Alignment: Allows the vertical or horizontal placement of the
image with respect to its anchor.
4. Text Wrapping: Wrapping allows the placement of image in
relation to text.
2.1) Vipin wants to insert images in his document
help him for Inserting image and apply different
filters to it
Vipin, here’s how you can insert an image in LibreOffice
Writer:
1. Open your document in LibreOffice Writer.
2. Click where you want the image to appear.
3. From the top menu, go to insert → Image...
4. A dialog box will appear.
Find the image you want from your computer, select it, and
click Open.
5. The image will now appear in your document.

� Now Vipin, follow these steps to apply filters to the image:

1. First, click on the image you’ve just inserted.
2. Then go to the top menu:
Format → Image → Filter
3. You’ll see several filters like:

 Invert – Turns the colors to their opposites.

 Aging – Makes it look like an old photo.
 Mosaic – Breaks it into small squares.
 Posturize – Reduces colors for an artistic effect.
 Emboss – Gives a 3D raised look.
 Relief – Creates a carved-like appearance.
4. Click any filter to apply it
3.1) Write an explanation/steps for following
 Template and its advantages
A template is a pre-set layout that helps to create
professional and/or formal documents easily.
Features of Templates

 Predefined formats save time.

 Templates ease out the creation of a new document.
 Templates have all the features of a normal document
and can contain text, graphics, styles, images, etc.
 Choosing from a list of templates simplifies work.

 Create a template
Step 1: Open the document
Step 2: Select File > Templates > Save. Template Dialog
window will open.
Step 3: Type the name of the new template
Step 4: Click on save button

 Create custom template

Create a template using In-built/Saved Templates
LibreOffice allows the user to use in-built templates,
online templates as well As the template created and
saved by us.
o Step 1: Open the new document in LibreOffice Writer
o Step 2: Select File > Templates > Manage Templates or
use shortcut key Ctr + Shifting
o Step 3: Select the desired template and click Open
button
o Step 4: Make the desired changes and save the file

 Setting the default template

 Create or Open Your Template
 Save the Document as a Template
 Open the Template Manager
 Locate Your Template
 Set it as the Default Template

4.1) Write an explanation/steps for following:

o ToC and its importance and structure line of
entries
The Index page (List of the page) of every book is known
as table of contents.
Importance of ToC:
A Table of Contents auto-lists headings with page numbers.
It helps the reader easily navigate sections.
Structure Line Explanation
 E#: Chapter number
 E: Entry text
 T: Tab stop
 #: Page number
 LS/LE: Hyperlink start/end
Steps to Create ToC
1. Use heading styles in your document (Heading 1, 2,
etc.).
2. Insert → Table of Contents and Index → Table of
Contents.
3. Click OK.
Edit/Update/Delete ToC
 Right-click on the ToC → choose Edit, Update, or Delete

4.2) Rohan has created a report on Environmental

Pollution in LibreOffice Writer. Help him to add
table of contents to his document with the heading
as Rohan’s Table of Contents.
Rohan created a report on Environmental
Pollution.
To help him:
 Use proper heading styles for all sections.
 Insert a ToC at the top titled "Rohan’s Table of
Contents."
 Unit-2 Electronic Spreadsheet
(Advanced)
1.1)  Explain Data Consolidation.

Data Consolidation allows you to gather together your

data from separate worksheets into a master worksheet.

data from a series of worksheets or workbooks and

summaries it into a single worksheet that you can
update easily.

1. Open multiple worksheets and enter data accordingly.

2. Click on the Data-> Consolidate, a consolidate
dialogue box will open.
3. Select the desired function from Function dialogue
box.
4. In the Source data ranges, enter the data range of the
first source. Or either you can select the range on the
sheet through mouse.
5. Click on Add button. It will appear in Consolidate
ranges area.
6. Repeat it for all data ranges.
7. In copy result to, click on the blank space to enter
1.2) only screenshot required
2.1)  Explain SUBTOTAL ()

This function calculates subtotals from the selected

cells.

on a group or range of cells with labels for row/columns.

1. Select the ranges of cells for calculating subtotal.

2. Click on data -> Subtotal, Subtotal dialogue box will
appear.
3. Select the column that you want to consider for group
by under Group by dropdown list, check the column for
calculating subtotal and select a function in Use function
list box for calculation.
4. Click ok button.

2.2) only screenshot required

3.1)  Write an explanation for scenarios.

A scenario is a set of cell ranges with a given name.

different questions based on the data in those cells.

 -if conditions. You can
apply what-if on different scenarios and check if there
are changes in the results.

can be edited and formatted separately. When you print

the spreadsheet, only the content of the currently active
scenario is printed.

interest with different principal amounts. You can

create different scenarios to calculate it.

3.2) only screenshot required

4.1)  Write explanations for goal seek.
Generally, a formula is applied to get the result for a
given set of input values. But, suppose you know the
result but do not know the input values that give this
result. In such a case, you can use the Goal Seek feature
to find out the input values for which you will get the
given result.

altered in a single Goal Seek operation.

not know at which principal amount you can get that

exact simple interest, in this case, you can use this
feature.

4.2) ONLY Screenshot required

5.1) Write explanations for solver.

Solver is a more descriptive form of Goal Seek.

Seek is used to manipulate one variable cell.

it is specifically designed to minimize or maximize the
result according to a set of rules that you define.
Each of these rules specifies a limiting condition, such
as an argument in the formula should be greater than,
smaller than, or equal to a particular value. You can also
define the constraint that one or more arguments
should be integer(s) or binary values.
for example, If you want to calculate simple interest,
and you want to know principal amount and interest
rate or number of years, solver is an option

5.2) only Screenshot Required

o Create a macro
o Record a macro
o Run a macro

A Macro automates repetitive tasks using recorded steps

or scripts.
Create a Macro
 1. Tools → Macros → Record Macro.
2. Perform actions (e.g., formatting).
3. Click Stop and save.
Run a Macro
1. Go to Tools → Macros → Run Macro.
2. Select and execute saved macro