S.

No Practical Teacher's Sign

1 Explain the styles given in
the Styles and Formatting
Window for writer and paste
the screen shot of the
window also
2 Write the steps to create
new style in Libre Office
Writer.
3 Write the steps to
consolidate data of two
sheets in Libre Office Calc .
4 Write the steps to record
Macro in Libre office calc.
5 Write the steps to create
table with minimum five
fields on an entity "STUDENT"
in design view.
6 Write the command for the
following table Student
7 Illustrate the use of various
options under computer
Accessibility in Keyboard,
Mouse, Display tab
8 Write the steps to create
instant messaging account
for Google Talk
Q1. Explain the styles given in the Styles and Formatting Window
for writer and paste the screen shot of the window also.

Ans. Libre Office Writer supports the following types of styles:

1. Page styles
2. Paragraph styles
3. Character styles
4. Frame styles
5. Numbering styles
6. Cell styles
7. Graphics styles
8. Presentation Styles

Styles given for Writer are shown below

Character Styles

Paragraph Style
Frame Styles
Page Styles

List Styles

Styles and Formatting Window – Snapshot

Page styles : include margins, headers and footers, borders and
backgrounds. In Calc, page styles also include the sequence for printing
sheets.
Paragraph styles : control all aspects of a paragraph’s appearance, such as
text alignment, tab stops, line spacing, and borders, and can include
character formatting.
within a paragraph, such as the font and size of text, or bold and italic
formats.
Frame styles : are used to format graphic and text frames, including
wrapping type, borders, backgrounds, and columns.
Numbering styles : apply similar alignment, numbering or bullet
characters, and fonts to numbered or bulleted lists.

Character styles : affect selected text

******************************

Styles in the Styles and Formatting Window

(LibreOffice Writer)

The Styles and Formatting window (also called

Sidebar → Styles) provides several categories of
styles. These styles help maintain a consistent and
professional look throughout your document.

LibreOffice Writer includes five main categories of styles:

1. Paragraph Styles

These control the appearance of entire paragraphs.

They define:

• Font type, size, color

• Alignment (left, right, center, justified)

• Line spacing

• Indents and spacing

• Numbering and outline levels

Examples: Text Body, Heading 1, Heading 2, Title, Subtitle, List Paragraph

Use them to maintain consistent formatting in long documents.

2. Character Styles

These apply formatting

to selected text within a
paragraph without
affecting the whole
paragraph.

They define:

• Font variations
(bold, italic, small
caps)

• Color
 •

• Highlighting

• Language for spell-check

Examples: Emphasis, Strong Emphasis, Source Text, Internet Link

Use when you want to apply consistent inline formatting.

3. Frame Styles

Used for formatting frames, such as:

• Text frames

• Floating frames

• Graphics frames

They control:

• Borders

• Backgrounds

• Size and positioning

• Columns

Examples: Frame, Graphics, Marginalia

Use when inserting images or separating content blocks.

4. Page Styles

Control the layout of entire pages.

They define:

• Page size and orientation

• Margins
 • Headers and footers

• Background

• Column layout

Examples: Default Page Style, First Page, Right Page, Left Page

Use for managing multi-page document layout consistently.

5. List Styles

Used for bullet and numbering formatting.

They define:

• Bullet type

• Numbering style

• Level formatting

• Spacing and indentation

Examples: Numbering 1, List 1, List 2

Use for lists that must remain consistent across the document.

***********************************
Q2. Write the steps to create new style in Lebre Office

Writer. Ans. We can create New (Custom) Styles in two

ways

1. Creating a new style from a selection :

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, click on the New
Style from Selection icon
 4. After Clicking on New Style from Selection, create style
dialog box appear.
5. Write the name for the new style and click on OK

Q3. Write the steps to consolidate data of two sheets in Open

Office Calc . Ans. 1. Open a new file in Libre Office Calc and write the

following data :

Sheet-1 screen shot

2. Open another file in Libre Office Calc and write the following Data

Sheet-2 screen shot

3. Open the third sheet and click on Data → Consolidate. The following
dialog box appear

4. Click to select Source data range of first sheet and then click on Add
button.
5. After adding Source data range from both the sheets, the dialog
box will appear like shown below:
 6. Click on the green button and select the Cell where you want the
consolidated data.
7. After adding both the range and selecting the cell where we want the
result, click on OK button
8. After clicking OK button, we will get the consolidated data as shown
below.

Q4. Write the steps to record Macro in Libre office calc.

Ans.
How to Record a Macro in LibreOffice Calc

1. Enable Macro Recording (if not already enabled)

Macro recording is disabled by default in LibreOffice.

To enable it:

1. Open Tools → Options.

2. Navigate to LibreOffice → Advanced.

3. Check the box “Enable macro recording (limited)”.

4. Click OK and restart LibreOffice if required.

2. Start Recording a Macro

1. Open your Calc spreadsheet.

2. Go to Tools → Macros → Record Macro.

3. A small “Stop Recording” dialog will appear.

4. Perform the actions you want to record (typing, formatting, selecting

cells, etc.).

5. When done, click Stop Recording.

3. Save the Macro

1. After stopping, a dialog appears showing where to save the macro.

2. Choose:

o My Macros → to save globally, or

o This document → to save only in this spreadsheet

3. Navigate to Standard → Module1 (or create a new module).

4. Enter a name for your macro.

 5. Click Save.

4. Run the Recorded Macro

1. Go to Tools → Macros → Run Macro.

2. Navigate to your macro in the selected library/module.

3. Select it and click Run.

Optional: Assign the Macro to a Shortcut or Button

For keyboard shortcut:

1. Go to Tools → Customize.

2. Select the Keyboard tab.

3. Choose a shortcut and assign your macro.

For a toolbar button:

1. Go to Tools → Customize.

2. Select the Toolbars tab.

3. Add a new command and link it to your macro.

*****

Following steps create a macro that performs paste special with multiply.
1. Open a new file in calc.
2. Enter the following data.
 3. Select cell A3, which contains the number 3, and copy the value to the
clipboard.
4. Select the range A1:C3. 5. Use Tools > Macros > Record Macro to
start the macro recorder.
5. The Record Macro dialog is displayed with a stop recording button.

6. Use Edit > Paste Special to open the Paste Special dialog.

7. Set the operation to Multiply and click OK. The cells are now
multiplied by 3.

8. Click Stop Recording to stop the macro recorder. The

[Link] Basic Macros dialog opens and save the macro at
specified place with a particular name.
Q5. Write the steps to create table with minimum five fields on an
entity "STUDENT" in design view.

Ans. We will design the following table.

Field Name Data Type Constraint

ID Integer Primary Key
Name Varchar
Address Varchar
Phone Varchar
DOB Date

1. Click on Create Table in Design View… option available under Tasks

and a Table Design window appears as shown below.

2. Specify the field name and data type of the field to be created as
shown below.
 3. In the gray box at the left of the line, right-click and select
Primary Key, bringing up a key icon in the box

4. Save the table (File > Save)

Q6. Write the command for the following table Student.

Rollno Class Name Phone_no

1 XII Sumit 1234565
2 X Amit 3564583
3 X Anuj 1236589
4 XI Mini 5869542

1. Display all the records of table Student.

2. Insert record of your choice
3. Display record of student whose roll number is 3
4. Display record of students who are in class 'X
5. Display the record of 'Anuj'
Ans.
1. Select * from student;
2. Insert into student values(5, 'XI' , 'Suman' , 6953245)
3. Select * from student where Rollno = 3;
4. Select * from student where class = 'X'
 5. Select * from student where name = 'Anuj';

*************************************************************
*******

Q7. Illustrate the use of various options under computer

Accessibility in Keyboard, Mouse, Display tab .

Ans. To launch accessibility options in WindowsXP, Click Start > Control

Panel > Accessibility Options.

The Accessibility Options window appears

Keyboard Tab :

Sticky Keys

Sticky Keys is an accessibility feature to help computer users with physical

disabilities. To enable Sticky Keys, select Use Sticky Keys.

• Click Apply.
• Click OK.

The Sticky Keys icon appears in the system tray.

Filter Keys :

Filter Keys is a feature of Microsoft Windows. It is an accessibility

function that tells the keyboard to ignore brief or repeated keystrokes,
making typing easier for people with hand tremors.
• To enable Filter Keys, check Use Filter Keys.

• Click Settings under Filter Keys and check “Ignore Repeated Keystrokes”.
• Click Apply.

• Click OK.
Display Tab:

Select the Display Tab. A window with options to configure accessibility

options for display is displayed with option.

• High Contrast
• Cursor Options
Mouse Tab :

MouseKeys
MouseKeys is an accessibility feature that assists people who have
difficulty using a mouse. Select the Mouse Tab, a window to configure
accessibility options for mouse will be displayed

• To enable MouseKeys, Check Use MouseKeys.

• Click Apply.
• Click OK.

****************************************************************

****