1. Question: Riya is preparing a project in LibreOffice Writer.

She wants all headings to look

the same. Which feature should she use and why? Answer: She should use Styles
(Heading Styles) because they make all headings uniform and allow formatting to be
changed everywhere at once.
2. Question: Mohan accidentally changed formatting manually throughout his document.
Which LibreOffice feature could have saved time and how? Answer: He should have used
Styles. Styles apply formatting in one click and can be updated everywhere by modifying
the style once.
3. Question: Name any two types of styles in LibreOffice Writer and write one use of each.
Answer: * Paragraph Style: Used to format entire paragraphs (alignment, spacing,
indentation).
• Character Style: Used to format selected text (font, size, bold, italic, color).
4. Question: What is the difference between Paragraph Style and Character Style? Answer:
Paragraph Style applies to a whole paragraph and controls alignment, spacing, and
indentation. Character Style applies only to selected text and controls font, size, bold, and
italics.
5. Question: Why are styles better than manual formatting? Give one reason. Answer: Styles
save time because changing the style once updates formatting throughout the entire
document.
6. Question: Sneha wants page numbers and margins to be consistent in her document.
Which style category will help her? Answer: Page Style helps manage margins, page
numbers, headers, and footers consistently.
7. Question: What is a Page Style in LibreOffice Writer? Write one feature. Answer: A Page
Style controls the layout of a page. A key feature is that it sets margins, orientation,
headers, and footers.
8. Question: Define Frame Style and write one situation where it is used. Answer: Frame
Style is used to format frames that hold objects like images or text boxes. It is used to
position and add borders to pictures.
9. Question: How do styles help in maintaining document uniformity? Answer: Styles apply
the same formatting rules throughout the document, keeping the appearance consistent.
10. Question: Write the steps to apply a style using the Styles and Formatting window.
Answer: 1. Click the 'Styles and Formatting' icon or press F11. 2. Select the category of
style (e.g., Paragraph). 3. Click on the item to be formatted. 4. Double-click the style name
to apply it.
11. Question: How can you open the Styles and Formatting window using a keyboard
shortcut? Answer: You can open the Styles and Formatting window by pressing the F11
key.
12. Question: What is Fill Format Mode? Write its use. Answer: Fill Format Mode is used to
apply a style to many different areas quickly without having to go back to the Styles
window. It works like a "paint bucket" for formatting.
13. Question: How do you exit Fill Format Mode in LibreOffice Writer? Answer: To exit Fill
Format Mode, click the Fill Format icon again or press the Esc key.
14. Question: Explain the process of creating a new style from a selection. Answer: 1. Format
the text manually as desired. 2. Select the formatted text. 3. Open the Styles window. 4.
Click the 'New Style from Selection' icon and provide a name for the style.
15. Question: How can you update a style from a selection? Answer: 1. Select text that has
the style you want to update. 2. Apply manual changes to it. 3. In the Styles window, select
the style you want to update. 4. Click the 'Update Style' icon.
16. Question: What is the purpose of the 'Load Styles' feature in LibreOffice Writer? Answer:
The 'Load Styles' feature allows you to copy styles from another document or template into
your current document.
17. Question: Can you copy styles from one document to another? If yes, how? Answer: Yes,
by using the 'Load Styles' dialog box, clicking 'From File', and selecting the document that
contains the desired styles.
18. Question: What are the different ways to insert an image into a document? Answer: You
can insert an image by using the 'Insert' menu (Image), by dragging and dropping from a
folder, or by copying and pasting from another application.
19. Question: How can you insert an image directly from a scanner? Answer: Go to Insert ->
Media -> Scan -> Select Source, then choose your scanner and initiate the scan.
20. Question: What is the use of the Gallery in LibreOffice Writer? Answer: The Gallery
provides a convenient way to group and insert reusable objects like graphics and sounds
into your document.
21. Question: How do you resize an image in a document without distorting its proportions?
Answer: Hold down the Shift key while dragging one of the corner handles of the image.
22. Question: What is meant by 'Cropping' an image? Answer: Cropping means removing
unwanted outer parts of an image to focus on a specific area or to change its aspect ratio.
23. Question: Explain the 'Keep Ratio' option in the Crop dialog box. Answer: When 'Keep
Ratio' is selected, changing the scale of one dimension (width or height) automatically
changes the other to maintain the image's original proportions.
24. Question: What are the different types of Text Wrapping options available for images?
Answer: Common options include 'None' (text stays above/below), 'Before', 'After', 'Parallel'
(text flows on both sides), and 'Through' (image is on top of text).
25. Question: What is the purpose of the 'Anchor' option in the Image dialog box? Answer:
Anchoring refers to the reference point for the graphics. This point could be the page, or
frame where the object is, a paragraph, or even a character. An image always has an
anchoring point.
26. Question: Explain the difference between 'To Page' and 'To Paragraph' anchoring.
Answer: 'To Page' anchors the image to the page itself, remaining in a fixed position
regardless of text movement. 'To Paragraph' anchors the image to a specific paragraph; if
the paragraph moves to another page, the image moves with it.
27. Question: What is a Template in LibreOffice Writer? Answer: A template is a model
document that you use to create other documents. For example, you can create a template
for business reports that has your company logo on the first page.
28. Question: Write two advantages of using templates for creating documents. Answer: 1. It
saves time by providing a predefined layout. 2. It ensures consistency and professionalism
across all documents of the same type.
29. Question: How can you create a new template from an existing document? Answer: Open
the document, go to File -> Templates -> Save as Template, choose a category, and give
it a name.
30. Question: What are the steps to set a custom template as the default template? Answer:
Go to File -> Templates -> Manage Templates, right-click the desired template, and select
'Set as Default'.
31. Question: How can you reset the default template back to the original settings? Answer:
Go to File -> Templates -> Manage Templates, click the 'Action' icon (cogwheel), and
select 'Reset Default Template'.
32. Question: What is a Table of Contents (TOC) and why is it useful? Answer: A TOC is a list
of headings in a document with their page numbers. It is useful because it allows readers to
quickly find specific sections in a long document.
33. Question: Which menu option is used to insert a Table of Contents in LibreOffice Writer?
Answer: Go to Insert -> Table of Contents and Index -> Table of Contents, Index or
Bibliography.
34. Question: What is the prerequisite for generating an automatic Table of Contents?
Answer: You must use Heading Styles (Heading 1, Heading 2, etc.) for the titles and
subtitles throughout your document.
35. Question: How can you update the Table of Contents after making changes to the
document headings? Answer: Right-click anywhere in the Table of Contents and select
Update Index.
36. Question: Explain the 'Levels' feature in the Table of Contents settings. Answer: The
'Levels' feature determines how many layers of headings (e.g., Heading 1 to Heading 10)
are included in the Table of Contents.
37. Question: How can you protect a Table of Contents from being edited manually? Answer:
In the TOC dialog box, ensure the 'Protected against manual changes' checkbox is
checked under the Type tab.
38. Question: What is Mail Merge? Write one situation where it is used. Answer: Mail Merge is
a tool used to create multiple personalized documents (like letters or labels) from a single
template and a data source. It is used for sending personalized wedding invitations.
39. Question: Name the two main components required for Mail Merge. Answer: 1. Main
Document (the letter/form). 2. Data Source (the list of names/addresses).
40. Question: What is a 'Data Source' in the context of Mail Merge? Answer: A data source is
a file (like a spreadsheet or database) that contains the variable information to be inserted
into the main document, such as names and addresses.
41. Question: What is a 'Main Document' in Mail Merge? Answer: The main document
contains the text and graphics that are the same for every version of the merged document,
along with placeholders for variable data.
42. Question: Explain the purpose of 'Merge Fields'. Answer: Merge fields are placeholders in
the main document where the information from the data source (like <<Name>>) will be
inserted during the merge process.
43. Question: Write the steps to create a data source for Mail Merge within LibreOffice Writer.
Answer: Go to Tools -> Mail Merge Wizard, select 'Use a current document', choose
'Letter', and then click 'Select Address List' to create or add a list.
44. Question: How can you preview merged documents before printing? Answer: In the Mail
Merge toolbar or Wizard, use the 'Preview' buttons (arrows) to scroll through each record
to see how the final document looks.
45. Question: What is the difference between 'Printing' and 'Saving' merged documents?
Answer: Printing sends the documents directly to the printer, while 'Saving' creates a new
file containing all the merged pages for later use.
46. Question: Can you use an external spreadsheet (like Calc) as a data source? How?
Answer: Yes, by selecting 'Use an existing list' in the Mail Merge Wizard and browsing to
select the .ods or .csv file.
47. Question: What is a 'Macro' in LibreOffice Writer? Answer: A macro is a saved sequence
of commands or keystrokes that are stored for later use to automate repetitive tasks.
48. Question: How do macros help in automating repetitive tasks? Answer: Instead of
performing a long series of steps manually every time, you can record them once and run
the macro to perform all steps instantly.
49. Question: Write the steps to record a basic macro. Answer: 1. Go to Tools -> Macros ->
Record Macro. 2. Perform the actions you want to save. 3. Click Stop Recording. 4. Give
the macro a name and save it.
50. Question: What is the 'Consolidate' feature in LibreOffice Calc? Answer: Data
Consolidation allows you to gather together your data from separate worksheets into a
single master worksheet. It takes data from various ranges and combines it into a single
range.
51. Question: Explain the use of 'Subtotals' in a spreadsheet. Answer: Subtotals are used to
automatically calculate subtotals and grand totals for a set of data in a sheet. It groups data
based on a column and applies functions like Sum, Average, or Count.
52. Question: What is 'What-If Analysis'? Name any two tools used for it. Answer: What-If
Analysis is the process of changing the values in cells to see how those changes will affect
the outcome of formulas on the worksheet. Two tools are Scenario Manager and Goal
Seek.
53. Question: Define 'Scenarios' in the context of spreadsheets. Answer: Scenarios are a tool
to test "what-if" questions. Each scenario is a named set of cell values that you can
substitute at any time to see different results (e.g., best case vs. worst case budget).
54. Question: What is 'Goal Seek'? When is it used? Answer: Goal Seek is used when you
know the result you want from a formula, but you are not sure what input value the formula
needs to get that result. It works backward from the output to the input.
55. Question: What is the 'Solver' tool in LibreOffice Calc? Answer: Solver is an advanced
version of Goal Seek. While Goal Seek deals with only one unknown variable, Solver deals
with equations with multiple unknown variables and constraints.
56. Question: How do you create a hyperlink to a web page in Calc? Answer: Select the cell,
go to Insert -> Hyperlink, select 'Internet' on the left, enter the URL in the 'Target' box, and
click Apply.
57. Question: What is the difference between a Relative Hyperlink and an Absolute Hyperlink?
Answer: An Absolute link stops working if the target file is moved. A Relative link points to
a location relative to the current file, so it continues to work if the entire folder structure is
moved.
58. Question: What is 'Linking Data' between different sheets? Answer: Linking refers to
referencing a cell or range of cells in another sheet or even another spreadsheet file. When
the source data changes, the linked cell updates automatically.
59. Question: How can you share a spreadsheet with multiple users? Answer: Go to Tools ->
Share Document. Check the box 'Share this spreadsheet with other users' and click OK.
This allows multiple users to edit the file simultaneously.
60. Question: What happens when two users try to edit the same cell in a shared
spreadsheet? Answer: A conflict occurs. LibreOffice will show a 'Resolve Conflicts' dialog
box, allowing the user to choose which change to keep.
61. Question: What is a Database? Give an example of database software. Answer: A
database is an organized collection of structured information or data. Examples include
LibreOffice Base, MySQL, and Oracle.
62. Question: Define a 'Table' in a database. Answer: A table is the basic unit of a database
that stores data in the form of rows (records) and columns (fields).
63. Question: What is a 'Field' and a 'Record'? Answer: A Field is a single column in a table
representing a specific attribute (e.g., Roll Number). A Record is a single row representing
a complete set of data for one entity (e.g., all details for one student).
64. Question: What is a Primary Key? Why is it important? Answer: A Primary Key is a unique
field that identifies each record in a table. It is important because it prevents duplicate
entries and ensures data integrity.
65. Question: What is a Foreign Key? Answer: A Foreign Key is a field in one table that refers
to the Primary Key in another table. It is used to create a link or relationship between two
tables.
66. Question: Explain the 'One-to-Many' relationship. Answer: In this relationship, one record
in Table A can be associated with many records in Table B. For example, one Department
can have many Employees.
67. Question: What is the purpose of a 'Query' in a database? Answer: A query is used to
retrieve specific data from one or more tables based on certain criteria or conditions.
68. Question: What is a 'Form' in LibreOffice Base? Answer: A form provides a user-friendly
interface to enter, edit, and view data in a table, rather than working directly in the table
grid.
69. Question: What is a 'Report' in a database? Answer: A report is used to present data from
a table or query in a formatted, printable layout (e.g., a monthly sales summary).
70. Question: Name four common data types in LibreOffice Base. Answer: 1. Integer
(Numeric) 2. Varchar (Text) 3. Date 4. Boolean (Yes/No).
71. Question: What is the difference between 'Flat File' and 'Relational' databases? Answer: A
Flat File database stores all data in a single table (like a spreadsheet). A Relational
database stores data in multiple related tables to reduce redundancy.
72. Question: What is the 'Design View' in a table? Answer: Design View is used to define the
structure of a table, where you specify field names, data types, and properties like the
Primary Key.
73. Question: What is 'Referential Integrity'? Answer: It is a rule that ensures relationships
between tables remain consistent. It prevents users from adding a record to a related table
if there is no matching record in the primary table.
74. Question: How do you run a query in LibreOffice Base? Answer: Go to the 'Queries'
section, double-click on a saved query name, or create a new one using the Wizard or
Design View and click 'Run Query' (F5).
75. Question: During a science experiment, sparks caught near a computer lab. What safety
measures should be followed? Answer: Keep fire extinguishers accessible and ensure
students evacuate calmly.
76. Question: Sohan installed software that reminds him to take breaks every 30 minutes. How
does this help his health? Answer: It helps prevent eye strain and musculoskeletal
discomfort by prompting regular pauses.
77. Question: State two healthy living habits that support workplace safety. Answer: 1.
Regular physical activity to reduce stress and improve health. 2. Adequate sleep and
balanced diet to maintain energy and focus at work.
78. Question: What is meant by accidents and emergencies? Give one example of each.
Answer: Accidents are unplanned events that cause injury or damage (e.g., slipping on a
wet floor). Emergencies are sudden situations requiring immediate action (e.g., fire
breakout).
79. Question: What is ergonomics and why is it important at the workplace? Answer:
Ergonomics is the science of designing workstations and tasks to fit workers' needs and
 promote comfort. It helps prevent pain, strain, and injuries from repetitive or uncomfortable
positions.
80. Question: What is a first aid rule at workplace? Answer: First aid rules include having a
well-stocked first aid kit and trained personnel to provide immediate care for minor injuries.
81. Question: What is fire safety? Give two measures to ensure fire safety. Answer: Fire
safety means practices and equipment used to prevent fires and protect people if a fire
occurs. Measures include placing smoke alarms and fire extinguishers at proper locations,
and conducting regular fire drills with clear escape plans.
82. Question: List any four sources of hazards at an organisation. Answer: Potential sources
include poor ventilation, inappropriate lighting, improper handling of office equipment, and
stress or long working hours.
83. Question: Define hazard. Give two examples of workplace hazards. Answer: A hazard is
anything that can cause harm, injury, or damage to people or property at work. Examples
include poor sitting posture or prolonged computer use (ergonomic hazard) and slippery
floors that can cause falls.

85. Question: What is meant by health, safety, and security at the workplace?

Answer: Health refers to the physical, mental, and social well-being of employees. Safety
means protecting people from work-related injuries and accidents. Security refers to measures
that protect employees and assets from harm and threats.