Vocational Skills

Class X

Unit 1:
Digital Documentation (Advanced) using
LibreOffice Writer
Chapter 1 Introduction to Styles

Multiple Choice

[1] Which of the following features in LibreOffice Writer is/are used to create the given
document?
a) Page Borders b) Envelop c) Picture From File d) Indexes and Tables

[2] Styles menu (from sidebar) in Writer provide options to work on

(a) Paragraph Styles (b) Frame Styles (c) Page Styles (d) All of the above
Ans. (d) All Styles

[3] What is style template in LibreOffice writer?

(a) Pre-determined form and mode of document file (b) One kind of model style
(c) One type of document (d) Cluster of documents in Writer
Ans. a) Pre-determined form and mode of document file

[4] Which of the following gives the status of your document like page numbers, number of
pages?
(a) Status bar (b) Standard toolbar (c) Formatting (d) Title bar
Ans. a) Status bar

[5] Which of the following can be used to access a style menu?

(a) F11 function key (b) Sidebar Menu (c) Formatting toolbar (d) All of these
Ans. d) All of these

Part B Fill in the blanks

[1] A style is a collection of different formats.
[2] Styles are especially handy in __________________.
Ans. sidebar or style menu
[3] Proper use of styles improves _________________ in a document.
Ans. Consistency
[4] The first five buttons at the top of the Styles window select the category of
_____________________
Ans. Paragraph Styles
[5] Using predefined ________________________creates Bookmark in the document.
Ans. heading
[6] On opening a new file ____________ Style is used for formatting the document.
Ans. default

1
 [7] In page layout documents, you can arrange ____________________ like text boxes and
graphics.
Ans. objects
[8] Character styles are often integrated in ____________________ Style.
Ans. paragraph
[9] _________________ allows to apply style at different places in the document.
Ans. Fill format
[10] Predefined Style ____________________ be updated by Drag and Drop method.
Ans. cannot

Part C Short answer questions

1. What do you understand by styles in LibreOffice writer document?

o Styles are set of formatting saved as a single unit under a specific name. These set
of formatting applies as a combination on any paragraph, text, images or tables in
the document.
o Example: For Chapter Title – Font: Arial, Size: 16 , Colour: Blue can be a style for
document
2. Write advantages of using Style over manual formatting, for designing a document.
o Consistent format becomes difficult when manual formatting is used. Styles
reduced the inconsistency in formatting
o Reduce time and efforts in formatting a document
3. What are the different categories of style in LibreOffice writer document?
o Paragraph styles
o Character Styles
o Page Styles
o Frame Styles
o List Styles
o Table Styles
4. Write down the steps to update a style.
o Select the style to be updated
o Apply the formatting for a style
o Open Styles dialog box and click on Style action button then choose Update
selected style or Click on Style –> Update Selected Style
5. What do you understand by custom styles in LibreOffice writer?
o Custom styles refers to a style created as per user’s need which is not present in the
style gallery.
6. In a document Introduction paragraph is to be designed extensively by setting its font
(face, size, weight, colour), space above it and giving number to heading. Given below
are the steps used to do so.
Ans. (i) Select the Introduction (paragraph)
(ii) Open Font list from Toolbar
(iii) Select the font
(iv) Open Font size from Toolbar
(v) Select the desired font size
(vi) Select Font weight (Bold) from the toolbar
(vii) Open Font color from Toolbar
(viii) Select desired color
(ix) Using Format menu option, select Spacing > Paragraph > Indent and Spacing (x) Edit
space above paragraph
(xi) Add number by Selecting Numbered list from Toolbar.

2
 7. Give two examples, where instead of Style, using manual formatting will be
beneficial.
o Applying character formatting where only font needs to be changed or very less
formatting is required
o The format needs to be applied on one or two content in the document
8. Give one situation, in which you will prefer to use Fill Format for styling your
document.
o Fill format is used when a specific style is required to be applied frequently on
series of content
9. Write steps to load style(s) from a template.
o Open a document in which styles needs to be loaded
o Click on Load Styles from template option from through style action button from
Styles dialog box or Click on Styles -> Load Styles from Template

Chapter 2
Working with Images Libre Office Writer.
1. The text or image which appears faintly in the background of a page is called
_________________.
(a) Water mark
(b) Trade mark
(c) Copyright
(d) Embossing
Ans. (a) Water mark

2. JPG or JPEG in image format stands for _________________.

(a) Joint Photographic Experts Group
(b) Joint Picture Experts Group
(c) Joint Photographic Experts Graph
(d) Joint Photographic Experts General
Ans. (a) Joint Photographic Experts Group

3. In Drawing Object Properties toolbar, Grouping options provided are _________________.

(a) Exit Group
(b) Ungroup
(c) Enter Group
(d) All of these
Ans. (d) All of these

4. Which of the following is not the correct file extension for an image file?
(a) GIF
(b) JPEG
(c) Odt
(d) PNG
Ans. (c) odt

3
5. Image toolbar does not provide a tool for _________________.
(a) filtering
(b) cropping
(c) copying
(d) flipping
Ans. (c) copying

Type B Fill in the blanks – NCERT Solutions Chapter 2 Working with Images Libre Office Writer
1. _________ tool cuts off non-desirable part of the image.
Ans. crop
2. To change both brightness and contrast of the image ________________ tool can be used.
Ans. colour
3. To simulate the effect of time on picture _____________ tool is used.
Ans. aging
4. _________ place image at the bottom of all objects.
Ans. send to back
5. An image can be deleted by ____________ it and pressing DELETE key.
Ans. selecting
6. In drawing tools, basic shapes list provide ____________ shapes.
Ans. basic/24
7. Anchor act as _____________ point for a drawing.
Ans. reference
8. There are ________________ options for aligning an image horizontally.
Ans. three
9. The ___________ handles of image are used for rotating it.
Ans. rotating
10. Changing properties of an object _____________ creation, retain them throughout the session
Ans. before

short answer questions.

1. What is a digital image? How can you create one?

Ans. A digital image, which is representation of image in finite set of digital values 0 or 1, known as
pixels.
A digital image can be created using drawing tools, charts, photo, logo , captured through camera or
downloaded from internet.

2. Write steps to insert an image from the gallery using Drag and Drop method.
Ans. To insert an image from the gallery using Drag and Drop method:
1. Open Libre Office Writer and place the cursor where image is required.
2. Locate the folder or press window + E key and open the folder where picture is saved.
3. Select the picture or image to be inserted.
4. Drag the image into the document
5. Drop the image into the document

3. How is resizing of image different from cropping it?

Ans. Cropping image refers to removing (cut-off) unwanted part from the image where resizing image
refers to reducing or enlarging the image by its width and height.

4
4. What are the tools available in drawing toolbar? Describe any five tools.
Ans. The drawing toolbar has following tools to draw and manage various drawing objects. These
tools are ae follows:
1. Select Tool (Arrow)
2. Draw lines
3. Draw basic shapes such as square, rectangle, polygone, oval etc.
4. Basic Shapes (list)
5. Symbol (List)
6. Star (List)
7. Flow chart (List)
8. Call outs
9. Fontwork
10. Points
11. Toggle Extrusion
1) Select Tool : This tool allows to select the objects drawn on the paper or document.
2) Draw Lines: There are various lines can be drawn such as straight line, arrow, curves and polygons.
3) Draw basic shapes: The basic shapes such as polygon, rectangle, rounded rectangle, square, ellipse,
circle, triangle, right angle triangle can be drawn in the document.
4) Basic Shapes (list): This list contains 24 basic shapes which can be drawn in the document.
5) Symbol (List) : It provides list of symbolic drawing objects such as smiley face, heart, sun, moon,
cloud, lightning bolt, flower, prohibited etc.

5. How is linking of an image different from embedding? Give a situation in which you would
prefer to link an image.
Ans. Linking image refers to providing reference for the original image rather than inserting image
completely. Embedding image refers to inserting actual image in the document.
Linking is always a good option when the same image is required in the document, multiple times.

6. Write steps to change properties for drawing objects.

Ans. To change the properties for drawing objects follow the given steps:
1. Select the drawing object.
2. Now the drawing object properties toolbar is available.
3. Select the property which you want to change.
4. Apply the parameters and save the file.

7. What are the benefits and drawbacks of grouping drawing objects?

Ans.
Benefits:
1. Allows to move the grouped objects together.
2. Allows to change the common properties together.
3. The alignment remains intact.
Disadvantages:
1. Ungrouped objects moved in the document one by one.
2. If any properties needs to be changed, then it can be changed individually.
3. If alignment of any image required to be changed it can be changed one by one.

5
8. Describe any two tools from Drawing Object Properties toolbar.
Ans. Drawing object properties toolbar provides certain tools to change and customize the properties
of drawing tools. Using these toolbar object an be moved, resized, edited and configured on various
aspects.
1. Anchor: It sets an anchor for the drawing object. It can be anchored to paragraph, to character or as
character.
2. Wrapping: It is used to arrange the text and drawing objects parallel, optimal, before, after, through
etc.

9. Write steps to insert an image in a basic drawing shape.

Ans. To insert an image in a basic shape follow the below given steps:
1. Draw a basic shape.
2. Select the shape.
3. Click on Insert -> Image option.
4. The image will be inserted into the object.

10. Write factors controlling positioning of an image in a document.

Ans. To control the positioning of image , writer provides below given options:
1. Arrangement
2. Anchoring
3. Alignment
4. Text Wrapping
1)Arrangement: Arrangement tool determines the position of the current drawing with respect to
other drawing or text. It changes the appearance from left to right. There are six tools in the arrange.
They are:
1. Bring to front – Place image on top of all objects
2. Forward One – Place image one level up in the case of overlapping image
3. Back One – Send image one level down in overlapping image
4. Send to back – Place image at the bottom of all objects
5. To foreground – Moves object in front of the text
6. To background – Moves the object behind the text
2) Anchoring:It acts as a reference point for image or drawing. Anchoring allows an image to retain its
position to a page, paragraph, character or frame.
3) Alignment: It places image horizontally or vertically. The image can be aligned at left, center or
right horizontally. Similarly, top, middle and bottom are vertically alignment.
4) Text Wrapping: : It places the image in relation with text written in the document. It provides six
options as following:
1. Wrap off: Text is placed on above and below image
2. Text flows around image. When image is moved it will rearrange the text on next page
3. Optimal Page wrap: In Page Wrap, if the space between image and margin is less than 2 cm then text
will
not be placed on that side
4. Wrap left: Text is placed on left side of image

6
 5. Wrap Right: Text is placed on right side of image
6. Wrap through: The text will be placed around the image
NCERT Textbook Internal Assignment Questions
Let us see the assignment questions given in the textbook.
Assignment 1
Explore how to insert an image from Writer’s Gallery or from any other device?
Ans.
To insert image from writer’s gallery follow these steps:
1. Activate the gallery pane through View –> Gallery option.
OR
Click on Media –> Gallery option.
2. Select a picture and drag it into the document.
To insert image from other device follow these steps:
1. Click on Insert –> Image option. Insert Image dialog will appear.
2, Choose the destination folder to insert an image and select an image.
3. Click on Open button.
4. Image will be inserted.
To insert image from scanner:
1. Click on Insert –> Media –> Scan –> Select Source option.
2. Select source dialog box will appear.
3. Select a device and choose the picture to insert.
Assignment 2
Use SHIFT key, while resizing the object, in both the cases and observe the difference in action.
Ans. If the SHIFT key is presses while dragging the or resizing the object, it will retain the original
proportions of the image.

Chapter 3
Advanced features of writer.
Type A Multiple choice questions
[1] Which of the following is NOT true about Table of Contents, Index or Bibliography dialog box?
(a) It has four tabs
(b) On the Type tab, by default, the checkbox for Protected against Manual Changes option will be
selected.
(c) The Styles tab contains options to change the background colour.
(d) None of the above
Ans. (c) The Styles tab contains options to change the background colour.

[2] Which of the following tabs is by default active when the Table of Contents, Entries or
Bibliography dialog box is opened?
(a) Entries
(b) Background
(c) Styles
(d) Type
Ans. (d) Type

7
[3] Which of the following tabs contains options to set styles for various entries in the ToC?
(a) Entries
(b) Background
(c) Styles
(d) Type
Ans. (a) Entries

[4] Which of the following can be added in the background of Table of Contents in LibreOffice
Writer?
(a) Color
(b) Graphic
(c) Both a and b
(d) Neither a nor b
Ans. (c) Both a and b

[5] Which of the following is NOT true about templates?

(a) The styles and formatting features can be reused.
(b) LibreOffice provides online templates
(c) We cannot create our own templates.
(d) None of the above.
Ans. (d) None of the above

[6] Which of the following is the shortcut key to open the Templates dialog box?
(a) Ctrl+Alt+N
(b) Shift+Ctrl+N
(c) Ctrl+Alt+T
(d) Shift+Alt+T
Ans. (b) Shift + Ctrl + N

[7] Which of the following buttons, in the Templates dialog box, will be clicked to save a template
displayed in the list of templates?
a) Export
(b) Import
(c) Move
(d) None of the above
Ans. (d) None of the above

[8] Which of the following is the shortcut key to select he entire document?
(a) Ctrl+S(b) Ctrl+A(c) Ctrl+D
(d) Ctrl+B
Ans. (b) Ctrl + A

[9] Which of the following is the correct sequence of options to open the Templates dialog box?
(a) File > Manage Templates > Templates
(b) File > Templates > Manage Templates
(c) Insert > Templates >Manage Templates
(d) Insert > Manage Templates > Templates
Ans. (b) File > Templates > Manage Templates

8
[10] Which of the following is true about Track Changes feature of Writer?
(a) You cannot record a change made in the document.
(b) A comment of a particular author only can be deleted
(c) Any change made to the document is permanent.
(d) None of the above
Ans. (b) A comment of a particular author only can be deleted

[11] Which of the following menus contains the Track Changes option?
(a) File
(b) Edit
(c) View
(d) Insert
Ans. (b) Edit

[12] Which of the following is the shortcut key to start recording the changes being made in the
document?
(a) Ctrl+Shift+C.
(b) Alt+Shift+C
(c) Ctrl+Alt+C
(d) Shift+C+F2
Ans. (a) Ctrl + Shift + C

Type B Fill in the blanks

[1] To navigate to the topic from the ToC, press __________ key while clicking the mouse button on that
topic.
Ans. CTRL
[2] To remove the applied paragraph styling in the ToC, select the outline level in the Levels list box, and
then click the ___________ button.
Ans. default
[3] If the checkbox for___________________ option is selected, the ToC is protected from any accidental
change.
Ans. Protected against manual changes
[4] To update the ToC manually, right click and select _________________ option from the pop up menu.
Ans. Update Index
[5] The_____________ tab contains options to set the number of columns that we want to have in our ToC.
Ans. Columns
[6] A ____________ is a preset layout that helps us to create professional and formal documents easily.
Ans. Template
[7] The default template in Writer is ____________.
Ans. Blank Document
[8] To find the template that is being used in the current document, select ___________ option from the
File menu.
Ans. properties
[9] The ________ button is clicked in Templates dialog box to view online templates.
Ans. Browse online template
[10] The ___________ feature of Writer offers us an alternative method to keep a record of all the changes
made in the original document.
Ans. Changes Record

9
[11] The shortcut key to start recording the changes is _________________.
Ans. Ctrl + Shift + C
[12] After the Track Changes feature is ON, the added characters are shown
as _____________________ text.
Ans. different coloured

Type C State whether the given statements are True or False

[1] The topics in Table of Contents are hyperlinked.
Ans. True
[2] The Table of Contents in LibreOffice Writer can be updated automatically.
Ans. False
[3] TABLE of Contents can be inserted even if the section headings are not styled.
Ans. False
[4] Once a ToC is created, it cannot be edited.
Ans. False
[5] We cannot add a graphic as a background of ToC.
Ans. False
[6] A single template can be used for multiple documents.
Ans. True
[7] A template cannot contain graphics.
Ans. False
[8] All documents in Writer are based upon templates.
Ans. True
[9] The online templates cannot be added to the list of templates in the templates dialog box.
Ans. False
[10] A template once created can be edited again and again.
Ans. True
[11] The changes recorded have to be accepted by the original author.
Ans. True
[12] We can delete the comments added in a document by the user.
Ans. True

Type D Answer the following questions

[1] What is the need of table of contents?
Ans. The need for table of contents is as follows:
1. To prepare an index in the beginning of document such as text book.
2. It organize all the headings with hyperlinks.
3. Hyperlinks makes document navigation easy and simple.

[2] What will happen if the ‘Protected Against Manual Changes’ option is not selected in the Type
tab of Table of Contents, Index or Bibliography dialog box?
Ans. If ‘Protected Against Manual Changes’ box is unchecked, then the contents of ToC can be changed
directly on the document page, just like any other text on the document.

[3] Name the five tabs present in the Table of Contents, Index or Bibliography dialog box.
Ans. The five tabs are as follows:
1. Type

10
2. Entries
3. Style
4. Columns
5. Background

[4] What do you mean by customization of ToC?

Ans. Customization of ToC refers to applying various settings and changing the appearance of ToC as per
user’s requirements. Such settings like ToC type, heading styles, ToC styles, background can be customized
to make ToC more pleasant.

[5] How headings and sub-headings of a document differentiated in ToC?

Ans. Headings and sub-headings are part of document hierarchy. The headings are top level headings where
as sub headings are displayed under top level headings.

[6] Define a template.

Ans. Headings and sub-headings are part of document hierarchy. The headings are top level headings where
as sub headings are displayed under top level headings.

[7] Give any one advantage of using a template for your document.
Ans. Template allows to create professional looking documents. Template provides a copy specific content
including graphics, such as logo of a company, image of a product or text, such as tag lines of a product or a
company, legal notices or even headers and footers in multiple documents.

[8] What is the difference between importing and exporting a template?

Ans.
Importing templates refers to loading templates from other sources such as downloaded from internet or
some other sources.
Exporting templates refers to transferring a template from a specific category to other document or other
sources.

[9] Name any two categories of templates.

Ans. Libre office writer provides the below given categories to save a template:
1. My Templates
2. Business Correspondence
3. Drawings
4. Localization
5. MediaWiki
6. Other Business Documents
7. Personal Correspondence and Documents
8. Presentations
9. Styles

[10 When is exporting of templates useful? Give any one reason.

Ans. Exporting template is useful when it is required to used by multiple users.

[11] What is the difference between Accept Track Change and Accept All Tracked Changes buttons?

11
Ans. Accept track change option allows to accept the selected change only in the document where as
Accept all tracked changes button allows to accept all the changes in one click done by everyone.

[12] How do we prepare a document for review?

Ans. To prepare a document for review, click on Edit > Track Changes > Record option.

[13] Identify and label the Record button, Insert Comments button, Accept All Tracked Changes,
Reject Track Change buttons in the following figures of Track Changes toolbar.

[14] Identify and label “Browse Online Templates button, Export button, Import button” in the
following Templates dialog box.
Ans. The browse online templates button is not available in the latest version. You can download templates
online from Online Templates .
The import button is present in Manage Drop down in the dialog box.
The export button is also not available in the latest version.

12
 Unit 2: Electronic Spreadsheet (Advanced)
using LibreOffice Calc

Chapter 4
Analyse Data Using Scenarios and Goal Seek.

A. Multiple Choice Questions

(1) Which of the following feature is not used for data analysis in spreadsheet?
(a) Consolidating data
(b) Goal Seek
(c) Subtotal
(d) Page layout
Ans. (d) Page Layout
Consolidating data, Goal Seek and Page layout are used for data analysis

[2] Which of the following office tool is known for data analysis?
(a) Writer
(b) Calc
(c) Impress
(d) Draw
Ans. (b) Calc
Writer – Used for documentation
Impress – Used for presentations
Draw – Used for images

[3] Which of the following operations cannot be performed using LibreOfficeCalc?

(a) Store and manipulate data

13
(b) Create graphical representation of data
(c) Analysis of data
(d) Mail merge
Ans. (d) Mail Merge
Mail merge can be performed using LibreOffice writer, LibreOfficecalc can be used to save the data source.

[4] What is the extension of spreadsheet file in Calc?

(a) .odb
(b) .odt
(c) .odg
(d) .ods
Ans. (d) .ods
.odb – LibreOffce Base file
.odt – LibreOffice Writer File
.odg – LibreOffce Drawing

[5] The default function while using Consolidate is _________.

(a) Average
(b) Sum
(c) Max
(d) Count
Ans. (b) Sum
The default function is Sum

[6] Group by is used in _______ tool to apply summary functions on columns.

(a) Consolidate function
(b) Group and Outline
(c) What-if scenario
(d) Subtotal tool
Ans. (d) Subtotal tool

[7] Which tool is used to predict the output while changing the input?
(a) Consolidate function
(b) What-if scenario
(c) Goal seek
(d) Find and Replace
Ans. (b) What-if Scenario
(a) Consolidate Function: Combine data from two spreadsheets and return result into another spreadsheet
(b) What-if scenario: Tests what-if questions
(c) Goal Seek: Predict the output while changing the input
(d) Find and replace: Search and replace a word

[8] Which of the following is an example for absolute cell referencing?

(a) C5
(b) $C$5
(c) $C
(d) #C
Ans. (b) $C$5

[9] _____________ analysis tool works in reverse order, finding input based on the output.
(a) Consolidate function
14
(b) Goal seek
(c) What-if analysis
(d) Scenario
Ans. (b)Goal Seek

B. State whether the following statements are True or False

[1] Consolidate function is used to combine information from two or more sheets into one.
Ans. True
[2] Consolidate function cannot be used to view and compare data.
Ans. False
[3] Link to source data is checked updates the target sheet if any changes made in the source data.
Ans. True
[4] Using subtotal in Calc needs to use filter data for sorting.
Ans. False
[5] Subtotal tool can use only one type of summary function for all columns.
Ans. False
[6] Only one scenario can be created for one sheet.
Ans. False
[7] What-if analysis tool uses one array of cells.
Ans. False
[8] Goal seek analysis tool is used while calculating the output depending on the input.
Ans. False
[9] The output of What-if tool is displayed in the same cell.
Ans. False

C. Fill in the blanks

[1] Consolidate function is used to combine information from multiple sheets to ___________ the
information.
Ans. Summarize
[2] Data can be viewed and compared in a single sheet for identifying trends and relationships using
___________ function.
Ans. Consolidate Function
[3] ____________ under Data menu can be used to combine information from multiple sheets into one
sheet To compare data.
Ans. Consolidate
[4] The _____ tool in Calc creates the group automatically and applies functions on the grouped data.
Ans. Subtotal
[5] _______________ scenario is used to explore and compare various alternatives depending on changing
conditions.
Ans. What-if
[6] _____________ is a planning tool for what-if questions.
Ans. What-if tool
[7] What-if analysis tool uses ____________________ array of cells, one array contains input values and
the second uses the _________________.
Ans. Two , formula and display output
[8] __________________ helps in finding out the input for the specific output.
Ans. Goal seek

D. Answer the following questions

[1] Define the terms
15
(a) Consolidate function
(b) What-if analysis
(c) Goal seek
Ans.
(a) Consolidate Function: It is used to combine information from multiple sheets of the spreadsheet into
one place to summarize the information. It is used to view and compare variety of data in a single
spreadsheet for identifying trends and relationships.

(b) What-if analysis: What-if analysis is is planning tool for what-if questions. It is useful to check in the
beginning to understand
From the output for the efficiency.

(c) Goal Seek: Goal seek helps in finding out the input for the specific output. For example, if you want to
know the number of units produced to get the desired output then use Goal seek analysis tool.

[2] Give one point of difference between

(a) Subtotal and What-if
(b) What-if scenario and What-if tool

(a) Subtotal and What-if

Subtotal What-if

Designed to streamline the process of conducting What-If

Used to summarize data within dataset
analysis

Used to obtain aggregated values based on

Changes can be related to variables such as prices,
criteria like categories, regions, or time
quantities, or assumptions.
periods.

Helps to understand how alterations in these variables

Provide insights into the segmented data
can affect outcomes, like sales, profits, or project
without changing the original dataset.
timelines.

(b) Difference between What-if scenario and What-if tool

What-if Scenario What-if Tool

is a hypothetical situation or prediction of

Allows users to simulate different scenarios by changing
potential outcomes based on different variables

16
or conditions. input values and parameters.

It provides dynamic calculations and instant results to

It helps in analyzing the impact of various
help users make informed decisions based on the
factors on a particular situation.
simulated outcomes.

[3] Give any two advantages of data analysis tools:

Ans.: Data Analysis tools helps in the following ways:
Better Decision Making
Improve user understanding about data

[4] Name any two tools for data analysis.

Ans.: Data Analysis tools helps in the following ways:
Goal Seek
Scenarios

[5] What are the criteria for consolidating sheets?

Ans.: Criteria for consolidating sheets are as follows:
• Each sheet in the spreadsheet must match the data types
• Match the labels from all the sheets which are used for consolidating
• Enter the first column as the primary column on the basis of which the data is to be consolidated

[6] Which tool is used to create an outline for the selected data?
Ans.: The subtotal command is used to create an outline for selected data. When subtotal function is use it
provides Group and Outline option to create an outline for selected data. You can click on (+) to expand
and (-) to collapse it.
.

Chapter 5
Using Macros in Spreadsheet

[1] Macro Recordings can be enabled from the ___________________ option in the menu bar.
(a) Sheet
(b) Data
(c) Tools
(d) Window.
Ans. (c) Tools
Sheet, Data and Window are not relevant options.

[2] Which of the following is an invalid Macro Name?

(a) 1formatword
(b) format word
(c) format*word
(d) Format_word.
Ans. (d) Format_word
(a) 1formatword – Starts with a number as macro name must starts with an alphabet

17
(b) format word – Contains a space as macro name should not contain any space
(c) format*word – Contains a special character (*) as macro name should not contain a special characters

[3] Which of the following Libraries contains modules with pre-recorded macros and should not be
changed?
(a) My Macros
(b) LibreOfficeMacros
(c) Untitled1
(d) Test.
Ans. (b) LibreOfficeMacros (Application Macros)
MyMacros and untitled can be edited or changed anytime where is Test is not a library name given in
macros organizer.

[4] Identify which of the following is a programming Language?

(a) Calc
(b) BASIC
(c) Writer
(d) Macro
Ans. (b) BASIC
Calc and Writer are applications of LibreOffce whereas Macro is important feature of LibreOffce Calc.

[5] The Module can be executed from the IDE by pressing _______________.
(a) F3
(b) F4
(c) F5
(d) F6
Ans. (c) F5
F3, F4 and F6 keys are not used in macros.

[6] Which of the following is the default name of the Macro?

(a) Default
(b) Main
(c) Macro1
(d) Main_Macro
Ans. (b) Main

B. Fill in the blanks

[1] ______________ library is automatically loaded when the document is opened.
Ans.: Standard
[2] IDE stands for ___________________.
Ans.: Integrated Development Environment
[3] Macro as a function is capable of accepting _______________ and returning a ________________.
[Link]/values, result/value
[4] Macro ____________ allows us to add, delete a module.
Ans.: Organizer
[6] The code of macro begins with _______followed by the name of the macro and ends
with _____________.
Ans.: Sub, End Sub
[7] By default a macro is saved in the _____________________.
Ans. (b) Main

18
C. State whether the following statements are True or False
[1] Macro is a group of instructions executing a single instruction.
Ans.: False
Macro is a group of instructions executing a multiple instructions.
[2] Once created, Macro can be used any number of times.
Ans.:True
A macros can be used infinite numbers of times after its creation.
[3] By default, the Macro recording feature is turned on.
Ans.: False
No, Macro feature is not enabled by default in LibreOfficeCalc, It can be turned on through Tools >
Options >LibreOfficeCalc> Advanced > Enable Macro Recording (May be limited) option
[4] It is not possible to stop recording of a Macro.
Ans.: False
Macro can be stopped by pressing Stop Recording button.
[5] Every Macro should be given a unique name.
Ans.:True
[6] A macro once created can be edited later.
Ans.: True

D. Answer the following questions

[1] What is a Macro? List any two real life situations where they can be used.
Answer:

 A macro is a single instruction that executes a set of instructions.

 These set of instructions can be a sequence of commands or keystrokes that can be used for any
number of times later.
 A sequence of actions such as keystrokes and clicks can be recorded and then run as per the
requirement.

Macros can be used in the following situations:

1. To apply the specific formatting repeatedly in spreadsheet

2. To use a specific formula repeatedly in spreadsheet

[2] List the actions that are not recorded by a macro.

Answer:
The actions cannot be recorded by Macro:

1. Opening of windows
2. Actions carried out in another window than where the recording was started.
3. Window switching
4. Actions that are not related to the spreadsheet contents
5. Selections are recorded only if they are done by using the keyboard (cursor traveling), but not
when the mouse is used
6. The macro recorder works only in Calc and Writer.

[3] How is LibreOffice Macros Library different from my Macros?

Answer:

19
A Library is a collection of modules which in turn is a collection of macros. A LibreOffice Macros library
contains default macros stored by LibreOffce whereas my Macros contains modules of macros created and
recorded by user.

[4] Differentiate between predefined function in Calc and Macros as a function.

Answer:

Predefined Function Macro as a Function

Predefined Function will be Macro as a function will be

stored in LibreOffice Macros stored in My Macros library
library by default

Predefined function has same Macro as a function has

code length different code length

It can be modified easily

It cannot be modified
anytime

Faster in execution Slower in execution

[5] List the rules that should be kept in mind while naming a macro.
Answer:
The rules that should be kept in mind while naming a macro are as follows:

 Macros should be always starts with a letter

 It doe not contain any space
 It does not contain a special character except for (underscore)

[6] Give any one advantage of macros.

Answer:
Macros are beneficial in many ways as follows:

1. Macro can be used again and again

2. Macro can be copied and distributed to multiple users
3. Macro can serve as a part of a broader solution to a customer requirement that involves both host
applications and workstation applications

Chapter 6
Linking Spreadsheet Data

20
A. Multiple choice questions
[1] Insert Sheet dialog can be invoked from ________________.
(a) sheet
(b) insert
(c) tools
(d) Windows
Ans. (a) Sheet
Insert, tools and windows are not correct options.

[2] _______________ refers to cell G5 of sheet named My Sheet.

(a) $My Sheet.’G5’
(b) $My Sheet_’G5’
(c) $ ‘MySheet’.G5
(d) $ ‘MySheet’_G5
Ans. (c) $’My Sheet’.G5
Insert, tools and windows are not correct options.

[3] The path of a file has ________________ forward slashes.

(a) four
(b) three
(c) two
(d) one
Ans. (b) three

[4] Which of the following feature is used to jump to a different spreadsheet from the current
spreadsheet in LibreOfficeCalc?
(a) Macro
(b) Hyperlink
(c) connect
(d) Copy
Ans. (b) Hyperlink

B. Fill in the blanks

[1] A relative hyperlink stores the location with respect to the _______________ location.
Ans.: current
[2] While inserting tables from a webpage _______________ selects the entire HTML document.
Ans.: HTML_all
[3] The extension of LibreOffice base is _______________.
Ans.: .odb.
[4] ____________ are used to enclose sheet names as there might be a space within sheet names.
Ans.:Single Quotes (”)
[5] The From file option of _________________ Dialog box allows to insert sheet from another file.
Ans.: Insert Sheet

C. State whether the following statements are True or False

[1] A sheet can only be added before the current sheet.
Ans.: False
[2] If ‘sales’ sheet has a reference to ‘cost’ sheet then any changes made to ‘cost’ sheet will be reflected in
the sales sheet as well.
Ans.: True
[3] It is not possible to link a sheet as a reference in another sheet.
21
Ans.: False
[4] We can insert data from a table created on a web page into a spreadsheet.
Ans.: True
[5] A hyperlink once created on a sheet cannot be deleted
Ans.: False

D. Answer the following questions

[1] Name the two ways to link the sheets in a LibreOffice Calc.
Ans.: Two insert sheet in a LibreOfficeCalc are as follows:
1. Sheet > Insert Sheet
2. Click on + symbol on sheet tab

[2] Differentiate between Relative and Absolute Hyperlink.

Relative Hyperlink Absolute Hyperlink

Relative hyperlink accepts file to be linked from Absolute Hyperlink accepts file to be linked from
same directory where the spreadsheet is saved. another directory from where the spreadsheet is saved.

It contains partial file path or only filename. It contains full path or complete address of file.

It will stop working only if the source and target

It will stop working if the target is moved.
locations change relative to each other.

Example: ‘[Link]’ Example: ‘D:\School Work\[Link]’

[3] Write steps to extract a table from a web page in a spreadsheet.

Ans.: To extract table from a web page in a spreadsheet, follow these steps:
1. Open the spreadsheet where table is required.
2. Place the cursor from where table needs to be inserted.
3. Click on Sheet > Link to External Data.
4. The External Data Dialog box appears. Type the URL of source document or select it from Drop Down
list.
5. Press enter.
6. A dialog box appear to choose language.
7. Chose the desired language and click on Import button.

[4] Write steps to register a data source that is in *.odb format.

Ans.: To register a data source, follow these steps:
1. Click on Tools > Options >LibreOffice Base > Databases.
2. The Options – LibreOffice Base-DataBases dialog box appears.
3. Click on the New button.
4. It will open Create Database Link dialog box.

22
5. Enter the location of database file or select from the file browser which is going to be linked.
6. Type name for Registered Database and Click on OK button.

[5] State advantages of extracting data from a web page into spreadsheet.
Ans.: The advantages of extracting data from a web page are as follows:
1. It is useful in Market research, sentiment analysis, data aggregation etc.
2. Gathering data from online sources
3. It provides real time data updation
4. It is also saving time and cost of uses
Watch this video for more understanding with practical explanation

Chapter 7
Share and Review a Spreadsheet

A. Multiple choice questions

[1] Sharing allows to edit the spreadsheet by
(a) single user
(b) different users simultaneously
(c) one by one users
(d) one after other users
Ans. (b) different users simultaneously

[2] Sharing spreadsheet feature allows to save the changes in

(a) multiple sheets
(b) user’s sheet
(c) in a same sheet
(d) in different sheet
Ans. (a) Multiple Sheets

[3] The Recording Changes feature of LibreOfficeCalc provides different ways to record the changes
made by _________ in the spreadsheet.
(a) one user
(b) other user
(c) the user
(d) one or other users
Ans. (d) One or other users

Insert, tools and windows are not correct options.

[4] In Calc, the comments are added
(a) automatically
(b) by author
(c) by reviewer
(d) all of above
Ans. (d) All of abov
Insert, tools and windows are not correct options.

[5] The changes by team members in the spreadsheet can be accepted or rejected by
(a) the team members
(b) any of the user
(c) owner
23
(d) other users
Ans. (c) Owner

B. State whether the following statements are True or False

[1] Spreadsheet cannot be shared to work with more than one user.
Ans.:False
[2] Some of the features becomes unavailable when the spreadsheet is in shared mode.
Ans.:True
[3] You can record changes in the spreadsheet when the spreadsheet is opened in shared mode.
Ans.:False
[4] File menu is used to Record changes for the spreadsheet.
Ans.:False
[5] You can add a note or suggestion in the spreadsheet using Insert Comment.
Ans.:True
[6] Formatting comment can be used to change the font colour of the comment.
Ans.:False

C. Fill in the blanks

[1] The title bar of the document shows __________ along with the filename for the shared mode of the
spreadsheet.
Ans.:shared
[2] The shared mode spreadsheet allows _______________ users to access and edit the spreadsheet at the
same time.
Ans.:many
[3] Recording changes automatically ________________ the shared mode of a spreadsheet.
Ans.:turn off
[4] Click on Edit menu, Track Changes and then select ______________ to record the changes in the
spreadsheet.
Ans.:record
[5] The border color of the changed cell will be ________________.
Ans.:red
[6] ___________ is used to add notes or suggestions to a cell in a spreadsheet.
Ans.:comment
[7] The comment box can be formatted just like formatting the ___________.
Ans.: cell contents

D. Answer the following questions

[1] Define the terms
(a) Sharing Spreadsheet
(b) Record changes
[2] Write the commands to perform
(a) Sharing Spreadsheet
(b) Record changes
Ans.:
1. Sharing Spreadsheet: Tools > Share Spreadsheet
2. Record Changes: Edit > Track Changes > Record

[3] Which menu is used to perform the functions

(a) Track Changes
(b) Saving Spreadsheet
Ans.:

24
1. Track changes: Edit
2. Saving Spreadsheet: File

[4] What do you understand by reviewing the changes in the spreadsheet?

Ans.: In reviewing the changes stage owner will go through the changes made by other users to accept or
reject them.

[5] Differentiate between Merging and Comparing Spreadsheet.

Merging Spreadsheet Comparing Spreadsheet

It merges all the changes It compares the different versions of

done by multiple users in a shared spreadsheets and prompts to
one spreadsheet. accept or reject them.

Compare sheets displays the

Merge sheets keep only one
comparison of formatting changed
set of formatting changes.
by multiple users.

Unit 3: Database Management System using

LibreOffice Base
Chapter 8
Introduction to Database Management System

A. Multiple choice questions

[1] Which of the following can be considered as an example of a database?
(a) Dictionary
(b) Telephone directory
(c) Marks Register
(d) Newspaper
Ans. (b) Telephone Directory
Dictionary, Marks Register and Newspaper are not a database.

[2] Which of the following is NOT a DBMS?

(a) MS Access
(b) LibreOffice Base

25
(c) MS Excel
(d) MySQL
Ans. (c) MS Excel
MS Access, LibreOffice Base and MySQL are DBMS softwares.

[3] DBMS stands for __________.

(a) Data and Books Management System
(b) Database Management System
(c) Duplicate Books Management System
(d) Data Management Multi System Book shelves
Ans. (b) Database Management System

[4] Which of the following data models sets a relation between the two or more tables?
(a) Relational Data Model
(b) Network Data Model
(c) Hierarchical Data Model
(d) Connection Data Model
Ans. (a) Relational Data Model
(b) Network Data Model – has logical association between the segments
(c) Hierarchical Data Model – data are organized like Tree-Structure
(d) Connection Data Model – used to connect related information between entities

[5] The details associated with an entity are called ________________.

(a) Table
(b) Attributes
(c) Records
(d) Primary key
Ans. (b) Attributes
(a) Table – Intersection of row and column
(c) Records – Set of fields represents one entity
(d) Primary Key – identifies rows uniquely

[6] A ______________ is represented as rows in a table.

(a) field
(b) attribute
(c) record
(d) candidate key
Ans. (c) Record
(a) field and (b) attribute- is represented as column in table
(d) Candidate key – The field which can be a candidate for primary key

[7] In which of the following forms can a data value be represented?

(a) Numeric
(b) Character
(c) Alphanumeric
(d) All of the above
Ans. (d) All of the above

[8] Which of the following uniquely identifies a row in a table?

(a) Primary key
(b) Alternate key
26
(c) Foreign key
(d) Candidate key
Ans. (d) All of the above

[9] A ___________is a feature of a database using which we can enter data in a table in an easy and
user friendly manner.
(a) query
(b) report
(c) form
(d) field
Ans. (c) Form
(a) Query – To fetch records from table
(b) report – Represent data from tables in summarized manner
(d) field – Represents a column of a table

[10] A __________________ is a question asked from a database.

(a) query
(b) report
(c) form
(d) field
Ans. (a) Query

B. State whether the following statements are True or False

[1] A database cannot be organize
Ans.: False
A database can be organized in efficient manner.
[2] Data is the collection of raw facts
Ans.: True
[3] A table can be created without a primary key.
Ans.: True
[4] Two tables can be related in a network data model.
Ans.: False
Two tables can be related in a relational data model.
[5] MS Access is an example of a database.
Ans.: False
MS Access is an example of DBMS.

C. Fill in the blanks

[1] The raw facts constitutes _____________.
Ans.: data
[2] An ________________ is a real world object about which information is to be stored in a database.
Ans.: entity
[3] The output of a query may be displayed in the form of ______________.
Ans.: report
[4] The data values for all the fields related to a person or object is called a _____________.
Ans.: report
[5] All the field values that are eligible to be the primary key are the __________ keys for that table
Ans.: candidate

D. Answer the following questions

[1] Define the terms
27
(a) Database
(b) Data redundancy
(c) Report
Ans.:
1. Database: A database is a collection of logically related data items stored in an organised manner. The
information being stored in a database can be added, modified, deleted or displayed according to the
requirements of the user.

2. Data Redundancy: The same data field repeated in different table is known as data redundancy.

3. Report: The output of query stored formal and proper layout is called report. A report represents the
query output in printed form or summarized manner.

[2] Give one point of difference between

(a) Data and Information,
(b) Form and Query
(c) Network and hierarchical data model
Ans.:
(a)

Information
Data

Raw facts are known as data Process data or meaningful data is known as information

Only roll numbers, marks, names are data Report cards along with appropriate data are information

1, ‘Madhav’, 98.5 Rollno – 1, Name – ‘Madhav’, Percentage – 98.5

(b)

Form Query

A form is a way to supply data in an easy and user Query is used to retrieve information from
friendly manner. database table

A form is used to display and input A query is a question asked from database

Form creates an interface for user Query returns a particular dataset

28
(c)

Network Model Hierarchical Model

Multiple records are linked to same master file Data is organized into tree like structure

It is also considered as invert tree Data is stored in form of records

Master is present at the bottom of the tree and branches It forms a hierarchy and all the records are
contains information linked to master linked each other at various levels

[3] Give any four advantages of a DBMS.

Ans.:
Organized Storage – The data in the database is stored in an organised manner, so that retrieval of the
required data is fast and accurate.
Data Analysis – A database helps in analysis of data based on certain criteria. It is easy to find out
maximum or minimum value, average or mean using a database.
Data Sharing – If the same data set is required for different applications then the database can be shared
with other applications. Hence using a database means making once and using it repeatedly for multiple
applications.

Minimal Data Redundancy – In the event of requiring the same data field in several tables the data field might
get repeated in number of tables. This is called as data redundancy. This can be reduced by using DBMS
tools.
Data Consistency – By minimizing data redundancy, chances of inconsistent data being stored is reduced.
For example, it should not happen that the name of the student is changed in one table and not in another.
Such inconsistency is reduced by using a DBMS..
.

Chapter 9
Starting with LibreOffice Base
A. Multiple choice questions
[1] Which of the following is NOT a type of text data type?
(a) Memo
(b) Varchar
(c) Float
(d) Char
Ans. (c) float
Memo, Varchar and char are text data types.

[2] A currency data type can only store monetary data that is in dollars.
(a) True
(b) False
(c) Neither a nor b
(d) Both a and b
Ans. (b) False
Currency data type is not supported in LibreOffice Base.
29
[3] Which of the following data can a date data type store?
(a) Date
(b) Time
(c) Both date and time
(d) Neither date nor time
Ans. (c) Both date and time

[4] Which of the following is true about LibreOffice Base?

(a) It is a spreadsheet software
(b) It is free and open source software
(c) It can store only character data
(d) It is a licensed software.
Ans. (b) It is free and open source software
(a) It is a DBMS software
(c) It can store multi kind data types
(d) It is not a licensed sodtware

[5] Which of the following methods can be used to create a table in Base?
(a) Using a table wizard
(b) Design View
(c) Both a and b
(d) Neither a nor b
Ans. (c) Both a and b

[6] The related objects of a database can be seen in _____________ pane of the Base Database
window.
(a) Database
(b) Task
(c) Title Bar
(d) Menu Bar
Ans. (a) Databse

[7] Which is the shortcut key to open an existing database?

(a) Ctrl+ D
(b) Ctrl+O
(c) Ctrl+E
(d) Ctrl+F
Ans. (b) Ctrl + O

[8] The Design view of Table Creation window in LibreOffice Base is divided into _______ sections or
panes.
(a) 2
(b) 3
(c) 4
(d) 5
Ans. (a) 2

[9] While entering records in a table, we can move to the next field by pressing the ________ key.
(a) Tab
(b) Ctrl
30
(c) Enter
(d) Shift
Ans. (a) tab

[10] Which of the following is true about primary key of a table?

(a) Every table must have a primary key
(b) The data values in primary key field cannot be duplicated.
(c) A primary key field cannot be left blank
(d) All of the above
Ans. (d) All of the above

B. State whether the following statements are True or False

[1] The text data can contain special characters.
Ans. True
[2] Memo data type can be used to store descriptive data.
Ans. True
[3] A Boolean data type can have two or more than two values.
Ans. False
[4] We cannot store audio data in LibreOffice Base.
Ans. False
[5] The properties of a field change according to the data type selected.
Ans. False
[6] Field description may or may not be entered while designing a table.
Ans. True
[7] |< is pressed to move to the last record.
Ans. False
[8]Comprehensive NCERT Solutions Chapter 9 Starting with LibreOffice Base
Appears when the record is being edited.
Ans. True
[9] A table once created in a database cannot be edited.
Ans. False
[10] Sort dialog box can only help to sort data in ascending order.
Ans. False

C. Fill in the blanks

[1] A data type refers to the type of data that will be stored in ___________ that particular field.
Ans. Datatype
The question is not proper.
[2] The _________________ data is a combination of letters, numbers or special characters.
Ans. Text
[3] ____________________ data type can be used to store Aadhar number.
Ans. Text – To store number With space
[4] The ___________ data type used to store digitized images.
Ans. Binary or Varbinary
[5] The shortcut key to save a table is _____________________.
Ans. Ctrl + S
[6] _____________ on the Base Interface Window displays information about the type of view of the
object in the database.
Ans. Tasks Pane
[7] A ____________________ icon appears before the field name indicating that it is a primary key.
Ans. Key
31
[8] The data can be entered in a table only in ______________ view.
Ans.: Datasheet
[9] The black pointing arrow just before the field name in a table is called ______________.
Ans.: Record Pointer
[10] The process of arranging the records in particular order on any filed is called _____________.
Ans.: Sorting

D. Answer the given questions

[1] Differentiate between:
(a) Memo and Varchar data type
(b) Number and Decimal data type
(c) Design View and Datasheet view of a table

Memo Varchar

It is used to store up to maximum length data It is used to store up to the specified length by
indicated by user. user.

It can store the descriptive values having more than

255 characters. It can store data up to 64,000 It can store text values up to 255 characters.
characters.

It can store values like names, cities, locations,

It can store values like remarks, address, description
any other short texts having various length
etc.
characters.

Number Decimal

It can store number as exactly as precise it can It allows higher numbers and can store more digits
defined. than specified

If user has specified Numeric(6,2) that means 6 total If user has specified Decimal(6,2) that means 1-6
digitals with 2 decimal places. No more or no less total digitals with 2 decimal places. Means it can
digits before or after decimals. store 11.56 but not 11.005.

In this data type 0 is automatically ignored and not

It accept 0s in value. For example the 6000.50 will
displayed in the value. For example, the value
be accepted as 6000.50
6000.50 will be accepted as 6000.5

32
Design View Datasheet View

It is not a default view of a database table. It is a default view of database table.

It shows only field names and data types of fields of It shows all the records of tables entered by user
the table but no records. along with fields title.

It allows to change information entered in the

It allows to create or change the table structure only.
table.

Row does not represent any record. As much fields Each row represents a record in the datasheet
are available in the table that much rows are view. If five records are entered in the table, it
displayed in design view. displays five rows.

[2] Name the menu items present on the Base User Interface.
Answer:
Base user interface offers these menu items:

File – New, Open, Recent Documents, Close, Wizards, Save, Save As, Save All, Check out, Cancel Check
out, Check in, Export, Send and Exit LibreOffice
Edit – Undo, Cut, Copy, Paste, Paste Special, Select All, Open Database Object, Edit, Delete, Rename,
Create as View, Edit in SQL view, Form Wizard, Report, Report Wizard, Database – Properties,
Connection Type, Advanced Settings
View – Tables, Queries, Forms, Reports, Toolbars, Status Bar, Sort Ascending, Sort Descending, Refresh
Tables, Preview
Insert – Form, Report, Report Wizard, Query (Design View), Query (SQL View), Table Design, View
Design, View Simple, Folder
Tools – Relationships, User Administration, Table Filter, SQL, Macros, XML Filter Settings, Extensions,
Customize, Options
Window – Close Window, Database
Help – LibreOffice Help, What’s This?, User Guides, Show Tip of the Day, Get Help Online, Send
Feedback, Restart in Safe Mode, Get Involved, Donate to LibreOffce, License Information, Check for
Updates, About LibreOffice
[2] Label the components – Title Bar, Database Pane, Tasks Pane, Status Bar of the LibreOffice Base
User Interface.
Answer:

[3] How can we define a primary key in a table?

Answer:
Follow these steps to define primary key:

To make a particular field as the primary key, place the mouse pointer before the field name, say Event Id
in our above example and right click.
A pop up menu appears. Select the Primary Key option from pop up menu.

33
A key icon appears before the field name indicating that it is a primary key. Click on the key icon.

[4] Write steps to sort the table in descending order of primary key.
Answer:
To sort the table in descending order of primary key follow these steps:

Open database and table in datasheet view.

Select the Primary Key field.
Click on Data > Sort Descending option or Sort Descending icon from toolbar.
The fields and records gets sorted in descending order.

[5] What is the use of navigation box with respect to tables in a database?
Answer:
The navigation box is present at the bottom of datasheet view. It allows to navigate through various records
in a database table. It indicates the current record of a table at any time. It has following components:

Record Selector Box – It is a text box where the currently active record number is displayed. User may
enter the record number to see in this text box.
Navigation Buttons – These are used to scroll vertically in the table.
|<: Used to move to first record
> and <: Used to navigate to Next and Previous record
>|: Used to move last record
+: Used to insert a new record

Chapter 10
Working with multiple tables
A. Multiple choice questions
[1] Which of the following actions can be performed once the tables are created in a database?
(a) Add a field in a table
(b) Rename a table
(c) Delete a table
(d) All of the above
Ans.: (d) All of the above

[2] Which of the following is checked by a DBMS?

(a) Redundancy
(b) Inconsistency
(c) Both (a) and (b)
(d) Neither (a) nor (b)
Ans.: (c) Both (a) and (b)
Redundancy and Inconsistency are two main advantages of DBMS.

34
[3] Which of the following is required to set a relationship between the two tables?
(a) Both the tables must be in different databases
(b) Both the tables must have a common field
(c) Both the tables must have the same name
(d) Both tables must be stored in documents folder only.
Ans.: (b) Both the tables must have a common field

[4] If a record is added in a master table, which of the following is NOT true for transaction table
(a) The record in the master table is called the master record
(b) The corresponding record in transaction table can only be entered once.
(c) The record in the transaction table is called the transaction record.
(d) It is possible to add a record in the master table
Ans.: (b) The corresponding record in transaction table can only be entered once.

[5] Which type of relationship exists between a student and the subjects studied by him/her?
(a) One-to-one
(b) One-to-many
(c) Many-to-many
(d) All of the above
Ans.: (b) One-to-many
A rol number can be used to established a relationship.

[6] Consider the following tables. Which type of relationship can be established between the two
tables?
(a) One-to-one
(b) One-to-many
(c) Many-to-many
(d) None of the above

Ans.: (b) One-to-many

More than one can be used to establish a relationship. Category code and Item code are the fields.

[7] Which of the following menus contains the Relationship option?

(a) Edit
(b) File
(c) Tools
(d) View
Ans.: (c) Tools
Edit, File and View options does not contain the relationship option.

[8] The list of tables to be added is displayed in the ____________ dialog box in the Relationship
Screen.
(a) Add Tables
(b) Add Databases
(c) Both (a) and (b)
(a) Neither (a) nor (b)
Ans.: (a) Add Tables

[9] In the relationship design screen, the relationship between the two tables is done using
_____________ operation.
35
(a) Click
(b) Double Click
(c) Drag and Drop
(d) Right click
Ans.: (c) Drag and Drop

[10] Which of the following is NOT an option that can be used to maintain referential integrity in a
database?
(a) No Action
(b) Set NULL
(c) Set Default
(d) Set Value
Ans.: (d) Set Value
Set default and set null can be used as constraints.

B. State whether the following statements are True or False

[1] Redundancy is preferred in a database.
Ans.:False
No redundancy can be avoided in database.
[2] In a table, a record for a particular entity should not be repeated.
Ans.: True
[3] A single field should always have only one data value.
Ans.: False
A single filed should always have more than one values.
[4] If a table is edited, the records already entered in it are deleted.
Ans.: False
No when table is edited, the records remains as it was.
[5] The record in master table should be entered before the corresponding record is entered in the
transaction table.
Ans.: True
[6] In one-to-many relationship, one specific record of the master table has more than one corresponding
records in the related transaction table.
Ans.: True
[7] The Relationship option is present in the Widows menu.
Ans.: False
The Relationship option is present in the Tools menu.
[8] In a database, the referential integrity is maintained by the user.
Ans.: False
The Relationship option is present in the Tools menu.
[19] A relationship is always set between the tables based on a common field.
Ans.: True
[20] If the master record is deleted, the transaction records will always be deleted.
Ans.: False
No if master record is deleted then it is not necessary that transaction records also deleted.

C. Fill in the blanks

[1]A table to be edited is displayed in _____________ view.
Ans.: Design
[2] The most important prerequisite for setting a relationship between the two tables is that there must be a
________________between them.
Ans.: common field
36
[3] In ________________relationship, one specific record of a master table has one and only one
corresponding record in the transaction table.
Ans.: one-to-one
[4] ___________________is one of the most common types of relationship between the tables in a
database.
Ans.: one-to-many
[5] A record being entered in a ________________ table must always exist in a table.
Ans.: transaction or master or parent or base
[6] The principle of _______________helps prevent missing data by keeping deleted data from getting out
of synch.
Ans.: referential integrity
[7] Creating ________________ between tables restricts the user from entering invalid data in the
referenced fields.
Ans.: relationship
[8] Data integrity is maintained by ______________.
Ans.: DBMS
[9] A relationship between customers and products is an example of ______ relationship.
Ans.: many to many
[10] The ______ window is used to set relationships between the tables.
Ans.: Relation Design

D. Answer the following questions

[1] Give any two advantages of relating a table in a database.
Ans.:
1. Data Redundancy
2. Data Inconsistency

[2] How is redundancy or inconsistency controlled in a database? Explain with an example.

Ans.:
Redundancy: Data redundancy refers to reducing the repeated data field in several tables. It can be
controlled by using primary key or unique key constraints.
Inconsistency: When data redundancy is applied into table it should not happen that the same data changed
in one table should not in another.

[3] Define referential integrity. Who maintains referential integrity in a database?

Ans.:
Referential Integrity refers to establish a relationship between two tables which can help in data redundancy
and prevent missing data by keeping deleted data from getting out of synch. The referential integrity is
maintained by Primary key and Foreign Key.

[4] Differentiate between one to one relationship and one to many relationship. Give suitable
examples to explain your answer.
Answer:

One to one One to many

In one to one relationship, one record In One-to-Many type of relationship, one

of master table has one and only one specific record of the master table has more

37
 corresponding record in the related than one corresponding records in the related
transaction table. transaction table

For example – A table dept has three For example – A table salesman has fields like salesman_id,
fields Deptno, Dname and loc is with salesman_name, city, commission is related with table
with emp table h having fields like customer having customer_id, cname, bill_amt and
Empno, ename, job, sal, comm, salesman_id as well as related with commission table having
hiredate, deptno. fields as com_id, commission_amt, salesman_id.

[5] Explain many to many relationship with an example.

Ans.:
Many to many relationship the multiple records are related with a master table that correspond to multiple
records in the transaction table.
For example – A company store has tables such as Supplier, Product and Customer where all tables are
related with product id and different ids of supplier as well as customer

Chapter 11
Queries in Base
A. Multiple Choice Questions –
[1] Which of the following is refer to asking questions from the database?
(a) Report
(b) Table
(c) Query
(d) Database
Ans.:(c) Query
(a) Reports display the query results in summarized manner
(b) Table is container to store data in tabular form
(d) Database is systematics way to store data in different objects

[2] Which of the following are the ways to design a query?

(a) Wizard
(b) Design View
(c) SQL
(d) All of the above

38
Ans.: (d) All of the above
Query can be created using query wizard, design view and SQL view in Libreoffice base.

[3] Which is a flexible way to create a query?

(a) Wizard
(b) Design View
(c) Both (a) and (b)
(d) Neither (a) nor (b)
Ans.: (b) Design View
Because it is something like drag drop way to create a query

[4] Into how many parts is the query design window divided?
(a) One
(b) Two
(c) Three
(d) Four
Ans.: (b) Two
Tables and Query specification

[5] Which of the following is NOT true about queries?

(a) It can be created using multiple tables
(b) Multiple queries can be created in a database
(c) A query can run multiple times
(d) A query once created cannot be edited
Ans.: (d) A query once created cannot be edited
A query can be edited any time after its creation

[6] Which of the following is the shortcut key to run the query?
(a) F3
(b) F4
(c) F5
(d) F6
Ans.: (c) F5

[7] Which of the following functions can be performed on numerical data while designing a query?
(a) Sum
(b) Minimum
(c) Maximum
(d) All of the above
Ans.: (d) All of the above

[8] In a Query Design wizard, which of the following buttons is clicked to move a field from ‘Available
fields’ list box to ‘Fields in the query‘ list box?
(a) >
(b) < 9
(c) ∨
(d) ∧
Ans.: (a) >
Option b,c and c buttons are not present in query wizard

[9] Which of the following relational operators can be applied to set the criterion while designing a query
in LibreOffice Base?

39
(a) >
(b) =
(c) !=
(d) All of the above
Ans.: (d) All of the above
There is a printing mistake in this question in textbook, as option D is given as Add a form which is not relevant
to question.

[10] Which of the following dialog box is present when the Query Design window is opened for the first
time to design a query?
(a) Add Table
(b) Add Query
(c) Add Table or Query
(d) None of the above
Ans.: (c) Add Table of Query

[11] Which of the following step is not performed if there is no numerical data to be worked upon in a
query?
(a) Selection of fields
(b) Giving Aliases
(c) Summarizing
(d) Selection of tables
Ans.: (c) Summarizing

B. State whether the following statements are True or False

[1] You can run a query only once
Ans.: False
[2] A query cannot be created from multiple tables
Ans.: False
[3] The shortcut key to run a query is F5.
Ans.: True
[4] LibreOffice Base provides us with two ways to create a query.
Ans.: False
[5]vA query with numerical data cannot be saved.
Ans.: False
[6] By default the query result is not sorted.
Ans.: True
[7] A query can be used to display the average value of a numerical field.
Ans.: True
[8] While designing a query, the criterion can be set on only one field.
Ans.: False
[9] Alias is an alternative name for a field in a query.
Ans.: True
[10] In query Design window, the visible check box is selected by default.
Ans.: True
[11] A query once created using a wizard can only be edited in the Design view.
Ans.: True

C. Fill in the blanks

[1] A ________________ is a sort of question asked from a database.
Ans.: query
40
[2] The result of the query is displayed in _____________ form with field names in columns
Ans.: report
[3] A query can be created in ________ways.
Ans.: three (3)
Using Query Design, Query Wizard and SQL View
[4] The Query Design window is divided into ___________ sections.
Ans.: Two
1 Add Table or Query
2 Query Specification
[5] The shortcut key to run the query is ____________.
Ans.: F5
[6] The conditions to filter the records are set in the ____________ row.
Ans.: criterion
[7] When a table is selected in a Query wizard, the corresponding fields are displayed in the
__________________ list box.
Ans.: available fields
[8] The result of the query can be displayed in ____________ or _______________ order of any particular field
of the table.
Ans.: ascending, descending
[9] At the most _____________ search conditions can be given in the query wizard.
Ans.: three (3)
[10] The last step of the Query wizard displays the entire ____________ of the query.
Ans.: overview
[11] The __________________ view is a more flexible method to create a query.
Ans.: design
[12] To edit any query, right click on the _____________ icon of the query that has to be edited.
Ans.: saved query name
[13] In the _____________ row of the Query Design grid, we can type the column heading that will be
displayed instead of field name when we run the query.
Ans.: alias

D. Answer the given questions

[1] Define a query? What is the need of creating a query in a database?
Ans.: A query is a SQL command used to retrieve, manipulate, or manage data in a database. It acts as a tool for
users to interact with the database and access the required information. It is also a general question asked to
database to fetch records from table(s).
Need of query:
1. Data Retrieval
2. Data Manipulation
3. Filtering data
4. Aggregation or Analysis
5. Data Integrity or Consistency

[2] Rearrange the steps given below so as to create a query using a wizard.

1. Give Alias
2. Select the fields
3. Set the criterion
4. Set the sorting order
5. Give query name

41
Answer:

1. Select the fields

2. Set the sorting order
3. Set the criterion
4. Give Alias
5. Give query name

[3] What all information is seen in the overview (last step) of the Query wizard?
Ans.: The overview (last step) of query wizard shows following:
1. Name of query to be assigned
2. creating query by display query or modify query
3. Overview Such as selected fields, Sorting order (ASC or DESC), Search Condition (if any), groups and group
conditions.

[4] What is the use of Alias row in the Design grid of the Query Design window?
Ans.: The alias row in design grid of the query design window shows the alias names for fields selected in the
query. Sometime user don’t want to display the same field name as specified in the table. So other names can be
given using alias row.

[5] Name any four mathematical functions that can be applied to numerical data in a query.
Ans.: The mathematical functions that can be applied to numerical data in query are as follows:
1. sum()
2. max()
3. min()
4. avg()
5. count()

[6] Name the three ways of creating a query in LibreOffice Base?

Ans.: The three ways to create a query are:

1. Using Design View

2. Using Query Wizard
3. Using SQL View

Chapter 12
Forms and Reports

A. Multiple choice questions

[1] Which of the following toolbars contains the Label tool?

(a) Standard Toolbar
(b) Forms Controls Toolbar
(c) Records toolbar
(d) Formatting toolbar
Ans.:(b) Forms Controls Toolbar

42
[2] The Record toolbar has the buttons to move to the
(a) first record
(b) second record
(c) last record
(d) all record
Ans.:(d) all records or All of the above

[3] Which of the following is NOT true about forms?

(a) It is the front end for data entry
(b) It can contain only text fields
(c) Graphics can be inserted on the form
(d) It can contain only fixed number of records
Ans.:(b) It can contain only text fields

[4] Which of the following keys is pressed to select only textbox on the form?
(a) Alt
(b) Shift
(c) Ctrl
(d) Tab
Ans.:(c) Ctrl

[5] Which of the following properties in the Properties: Label, Field, text box is used to insert a tool-
tip on the form?
(a) Tool Text
(b) Help Text
(c) Tool Tip
(d) Help Tip
Ans.:(b) Help Text

[6] Which of the following objects of LibreOffice Base is used to display data retrieved from one or
more tables in a presentable manner?
(a) Query
(b) Form
(c) Report
(d) Panel
Ans.: (c) Report

[7] Which of the following values of Date Format property is selected to view a calendar on the form?
(a) Standard (short)
(b) Standard (long)
(c) Default
(d) Standard (Medium)
Ans.:(b) Standard (long)

[8] Which of the following commands on the Forms Control toolbar is used to toggle between Design
View and Form view?
(a) Design Mode
(b) Toggle Mode
(c) View Mode
(d) Print mode
Ans.: (a) Design Mode

43
[9] Using which of the following objects in a database, can a report be generated?
(a) Tables
(b) Queries
(c) Both a and b
(d) Neither a nor b
Ans.:(c) Both a and b

[10] Which of the following components open along with the Report Wizard?
(a) Report Builder
(b) Add Fields dialog box
(c) Both (a) and (b)
(d) Neither (a) nor (b)
Ans.:(c) Both (a) and (b)

B. State whether the following statements are True or False

[1] Report is an object of a database but form is not.
Ans.: False
Report and Form both are an object of a databse.
[2] We can choose the layout of the form.
Ans.: True
[3] We have to add all fields of the table on the form.
Ans.: False
Not necessarily, we can add the fields on form as per requirements.
[4] There are two ways n which a form can be created.
Ans.: True
[5] A report is generated in a separate window.
Ans.: True
[6] Once a control is added on to the form, it cannot be repositioned.
Ans.: False
A control added on to the form can be repositioned any time.
[7] The Record toolbar has the button to add a new record.
Ans.: True
[8] We can create a report only using a table.
Ans.: False
A report can be created using a query.
[9] By default, the records in a report are sorted in descending order.
Ans.: False
Records in the report are not sorted by default.
[10] We can group data based on a particular field in a report.
Ans.: True
[11] A report can have data only in row and column format.
Ans.: False
A report can have data in any format as per user’s customization.
[12] We can insert both date and time of generation of report.
Ans.: True
[13] A report once created cannot be edited.
Ans.: False

A report once created can be edited anytime.

44
C. Fill in the blanks
[1] A form can be used for ____________ and _________.
Ans.: Enter, View Data
[2] Each field control consists of a ____________and _____________.
Ans.: label, field value
[3] A __________ is a piece of text that specifies the data that should be entered in the field value text box.
Ans.: label
[4] By default the border of the field text value is displayed in ___________.
Ans.: 3D
[5] A __ is a small piece of text that is displayed when the mouse pointer is placed on a particular control
on the form.
Ans.: tooltip
[6] The default orientation option for a report is ___________,
Ans.: landscape
[7] A ______________ is the manner in which the labels, field values, titles etc. will be displayed in the
report.
Ans.:layout
[8] The option to insert date and time in the report is present in _______________ menu.
Ans.: insert
[9] A Report Wizard contains _____________ steps.
Ans.: six (6)
[10] A _______________ type of report changes automatically as the field values in the base table or query
change.
Ans.: dynamic

D. Answer the following questions

[1] Give one difference between a form and a report.
Answer:

Form Report

Form is used to enter and view Report is used to display data

data. in formatted manner.

Forms can be used for input and Reports can be used only as
output both. output.

Forms can have a single record Report can have multiple

each. records on each page.

Forms mostly used for soft copy Reports are mostly used for
only display and data entry. hard copy (printed)

[2] What is a field control with respect to forms?

Ans.: A field control in form represents a label and field text to represent a record on form. A label is a

45
piece of text that specifies the data that should be entered in the field value text box. A field value text box
is linked to the respective field in the table.

[3] Which tool on the Forms Record toolbar is used to insert text on the form?
Ans.: Text Field tool on the Forms Record toolbar is used to insert text on the form.

[4] Name the two ways to create a form in LibreOffice Base.

Ans.: The two ways to create a form in libreoffice base are:
1. Create a form in design vuew
2. Use wizard to create a form

[5] What is the difference between a static and a dynamic report?

Answer:

Static Report Dynamic Report

Display the same data from Updates automatically as data

when they are created. changes in the source.

They are text centric and no They allows users to interact with
interactive features. data and identify the insights.

Used for daily, monthly or Used for data analysis such as

weekly reporting financial analysis, sales funnel etc.

[6] Write the function of Forms Controls toolbar and Records toolbar.
Answer:

Form Controls Records Toolbar

The Form Controls toolbar or The Records toolbar contains the navigation
sub-menu contains tools that you control buttons in the extreme left. With the
need to create an interactive help of these buttons, we can traverse and
form. You can use the toolbar or view the records in the file. As we move from
sub-menu to add controls to a one record to another, the record number in
form in a text, drawing, the record text boxes changes. It also contains
spreadsheet, presentation, or command buttons such as add a new record,
HTML document, for example a save a record, delete a record etc.

46
button that runs a macro.

Unit 4: Maintain Healthy, Safe and Secure Working

Environment

Chapter 13
Health Safety and Security at workplace

A. Multiple choice questions

[1] Workplace safety is essential in organisation _________________.
(a) to avoid the accident and injury
(b) to increase the productivity
(b) to improve the work environment
(d) All of the above
Ans.:(d) All of the above

[2] Which of the following is not mandatory to keep the good health of an employee?
(a) Cleanliness
(b) Food court
(c) Clean and fresh air
(d) Clean washroom
Ans.:(b) Food court

[3] The security department is not responsible for _____________

(a) personal safety
(b) computer system and equipment safety
(c) electrical safety
(d) personal belongings
Ans.:(d) Personal Belongings

[4] The proper security procedures will increase _____________

(a) liabilities
(b) insurance
(c) business revenue
(d) operational charges of the company
Ans.:(c) Business Revenue

[5] Which kind of hazards can occur in IT industry?

(a) Biological
(b) Chemical
(c) Physical
(d) Ergonomic
Ans.:(d) Ergonomic

47
[6] Which of the following can cause hazards while using computers?
(a) Poor sitting postures or excessive duration of sitting in one position
(b) Lifting heavy object
(c) Mishandling of tools and equipment
(d) Improper handling of office equipment
Ans.:(a) Poor sitting postures or excessive duration of sitting in one position

[7] Which of the following statements is likely to result in an injury to the operator?
(a) Selecting the right tool for the job
(b) Wearing safety goggles or glasses
(c) Using a tool with loose handles
(d) Keeping cutting tools sharp
Ans.:(c) Using a tool with loose handles

[8] What are the potential cause of hazards at workplace?

(a) Poor ventilation
(b) Poor lighting
(c) Poor housekeeping
(d) All of the above
Ans.:(d) All of the above

B. Fill in the blanks

[1] Health of an employee is the state of the
physical, _______________ and ______________ well being.
Ans.:mental, social
[2] The work places must be cleaned in the ____________ before the people start working.
Ans.:morning
[3] A proper ________________ provide clean and cool air at the workplace.
Ans.: air conditioning (AC)
[4] A fresh food cafeteria helps to maintain the _____________ of the employee.
Ans.: health
[5] The work environment of the organisation must be _______________ and free from
_______________ and____________________.
Ans.:safe, hazard, risk
[6] The proper security procedures will increase the ________________ and will reduce the
____________________ of the company.
Ans.: business revenue, operational charges
[7] Injuries and illness of the employees is prevented through national policy
on ____________________.
Ans.:occupational health and safety
[8] Physical hazards occurs due to _______________.
Ans.: physical work environment
[9] Electrical hazards mostly caused due to coming in direct contact with _________________, or
indirect contact through a __________________.
Ans.: live wire, conductor
[10] Hazards while using computers occurs due to _______________ or excessive duration of
sitting in______________.
Ans.: poor sitting posture, one position

C. State whether the following statements are True or False

[1] The employer and employees are responsible for workplace safety.
Ans.: True
48
[2] Any injury at work should be reported to the supervisor immediately.
Ans.:True
[3] No matter how big or small the injury; the injured person should receive medical attention.
Ans.:True
[4] While working with machines and equipment, employees must follow the safety guidelines set
by the company.
Ans.:True
[5] Bright light sources behind the display screen can create contrast problems.
Ans.:True
[6] Exposure to bright lights and toxic fumes and vapour could damage the mouth and ears.
Ans.: False
Exposure to bright lights and toxic fumes and vapour could damage the eyes and nose.
[7] The use of personal protective clothing and equipment can control the hazards at workplace.
Ans.:True
[8] Do not throw rubbish daily.
Ans.:True
[9] Proper handling of office equipment can result in injuries.
Ans.: False
Proper handling of office equipment ensures safety.
[10] Stress at workplace can cause hazard in today’s organisation.
Ans.:True

D. Short answer questions

[1] Briefly explain the concept of health, safety and security at workplace.
Ans.:

Health
Health of an employee is the state of the physical, mental and social well being. Every
organisation must provide healthy and safety working environment for their employees at the
workplace. Health of an employee
must be in a good condition so that the employees of the organisation will not suffer from any
diseases.

Safety
The work environment of the organisation must be safe. It must be free from hazards and risk. A
hazard is the something that can cause harm to the people. A risk is a probability of causing harm
to the people. A proper safety guidelines must be prepared by the company and it should be
strictly followed. At regular intervals of time, the safety procedures must be practised by
employees.

Security
Security is a kind of freedom from any potential harm. Security ensures the safety of the people
working
in the organisation. Every organisation must have separate security department. This department
should
be responsible for various security such as personal safety, computer system safety, electrical
safety,
transport safety and other equipment safety. The proper security procedures will reduce liabilities,
insurance and compensation for organisation. This will increase the business revenue and will
reduce the operational charges of the company.

49
[2] State the most important reasons for health, safety and security programs in workplace.
Ans.: The reasons are:
1. It clearly indicates the company’s commitment for their employee’s health and safety
2. It shows the performance of the business and the safety performance are compatible with each
other
3. It clearly state that the company is not only doing the business for profits but it is taking care of
all its stake holders
4. The accountability of every one working for the company is outlined for the workplace health,
safety and security
5. Company can comply national policy on Occupational Health and Safety (OH&S) of
Government of India
6. Injuries and illness of the employees is prevented through such policy

[3] List out the various workplace safety hazards.

Ans.: The various hazards are as follows:
1. Physical hazards
2. Electrical Hazards
3. Fire Hazards
4. Health Hazards

[4] List out the potential sources of hazards in an organisation.

Ans.: Potential sources of hazards are as follows:
1. People at work
2. Unsanitary conditions, labs or environment
3. Exposure to chemical
4. Injuries
5. Mistakes at workplace
6. Fire
7. Electricity
8. Weather Conditions
9. Allergies
10. Workplace diemensions

[5] List some of the IT workplace hazards.

Ans.:Some IT wrokplace hazards are as follows:
1. Poor sitting postures
2. Excessive duration of sitting in one position
3. Similar movements for long hours
4. Looking at computer screen continuously

[6] What are the examples of potential hazards?

Ans.: Some potential hazards are as follows:
1. Poor ventilation
2. Chairs & tables inappropriate height
3. hard furniture
4. poor lighting
5. staff unaware of emergency procedures
6. poor housekeeping
7. Physical or emotional intimidation

[7] Describe information technology workplace hazards.

Ans.: Information Technology hazards includes occupational and physical hazards such as may

50
result in pain and strain, muscle fatigue etc, electronic and technical hazards or infrastructural
hazards.

[8] What are the workplace safety rules?

Ans.: Workplae safety may includes these rules:
1. Always stay alert to help and prevent accidents
2. Follow proper safety rules and regulations
3. Wear proper clothes
4. Handle equipment appropriately
5. Always take safety precautions
6. Keep work area clean and tidy
7. Report unsafe conditions

[9] List out different safety guidelines?

Ans.: Some safety guidelines checklist are as follows:
1. Store all cleaning chemicals in tightly closed containers in separate cupboards.
2. Throw garbage daily.
3. Make sure all areas have proper lighting.
4. Do not wear loose clothing or jewellery when working with machines.
5. Never distract the attention of people who are working near a fire or with some machinery,
tools
or equipment.
6. Where required, wear protective items, such as goggles, safety glasses, masks, gloves, and hair
nets.
7. Shut down all machines before leaving for the workplace.
8. Do not play with electrical controls or switches.
9. Do not operate machines or equipment until you have been properly trained and allowed to do
so by your supervisor.
10. Repair torn wires or broken plugs before using any electrical equipment.
11. Do not use equipment if it smokes, sparks or looks unsafe.
12. Cover all food with a lid, plastic wrap or aluminium foil.
13. Do not smoke in ‘No Smoking’ areas.
14. Report any unsafe condition or acts to your supervisor.

[10] Describe type of emergency with example.

Ans.: Emergency refers to an unexpected situation that needs immediate action.
Emergency also can be defined as a sudden risk of life, property health and that needs intervention
to prevent deteriorating results/hazards. An emergency includes threatens to the employee,
customers or public, shut down operations, causes physical or environmental damages.
The common types of emergencies are as following:
1. Chemical Peels
2. Extreme Heatwaves
3. Droughts
4. Pandemics
5. Terrorists Attack
6. Fire
7. Natural Disaster like Flood, Thunderstorms
8. Leakage of gas or chemical

51
 Chapter 14
Workplace Quality Measures
A Multiple Choice Questions
[1] To provide healthy and safety working environment, every organisation must have
_______.
(a) Cleanliness
(b) Filtered water
(c) Clean wash-room
(d) All of the above
Ans.:(d) All of the above

[2] Air pollution is mostly caused by production of the ______________ in the surrounding
air.
(a) dust
(b) mixture of solid particles
(c) gases
(d) All of above
Ans.:(d) All of the above

[3] Repetitive use of muscle may feel pain in your ____________

(a) neck
(b) shoulder
(c) wrist or fingers
(d) All of the above
Ans.:(d) All of the above

[4] The security department organisation is not responsible for ________________.

(a) other safety
(b) computer system safety
(c) electrical safety
(d) transport safety
Ans.: There is not correct option is given because security department is responsible for all
of them.

[5] For an organisation, the proper security procedures will reduce _____________.
(a) liabilities
(b) insurance
(c) business revenue
(d) operational charges of the company
Ans.: (a) liabilities and (b) insurance both are correct

[6] Do not wear ______________ when working with machines.

(a) jewellery
(b) safety glasses
(c) masks
(d) gloves
Ans.:(a) jewellery

[7] Sore lower back is caused due to _____________

(a) reaching forward frequently

52
(b) no lumbar support
(c) no upper back support from chair
(d) reaching forward for long periods
Ans.:(b) no lumbar support

[8] What should you do with the problem of dry eyes?

(a) Forget to blink
(b) Rest eyes periodically and do simple eye exercises
(c) Do exercise
(d) Blink the eyes
Ans.:(b) Rest eyes periodically and do simple eye exercises

[9] If light is coming directly behind or in front of you then you may suffer from
_____________
(a) eye strain
(b) sore eyes
(c) dry eyes
(d) eye strain and sore eyes
Ans.:(d) Eye strain or sore eyes

B. Fill in the blanks

[1] Air and water pollution can be analysed by using ___________, physical, and
______________ analysis.
Ans.: chemical, biological
[2] The PH value of the water can be measured through ________________ analysis.
Ans.:chemcial
[3] The ______________ indicators are used to monitor the health of the ecosystem.
Ans.:microbial
[4] Ergonomics is the science concerned with __________________ and arranging things.
Ans.:designing
[5] Working with wrists extended too much repetition can cause _____________________.
Ans.:arching wrists
[6] The repetition of a seemingly ___________ task over a period of time can cause an injury.
Ans.:innocuous
[7] If a cord or wire will cross a pathway safety it should be mark it with ___________
Ans.:hazard tape
[8] Loose cords and wires can cause ______________.
Ans.: electrical hazards
[9] Glare and _______________ on the screen should be prevented.
Ans.: reflections
[10] The keyboard should have a matt surface to avoid _______________ glare.
Ans.:reflective

C. State whether the following statements are True or False

[1] The work environment of the organisation must be free from hazards and risk.
Ans.:True
[2] Practice a no vehicle day in every week to avoid air pollution.
Ans.:True
[3] Applying ergonomics can improve performance and productivity.
Ans.: True
[4] Wear rings, watches and necklaces while working on the computer.

53
Ans.: False
[5] Never touch or try repairing any electrical equipment or circuits with wet hands.
Ans.: True
[6] Unplug all power sources and cables from computer while working on computer.
Ans.: False
[7] Occupational overuse syndrome, also known as repetition strain injury.
Ans.:True
[8] The work chair must be stable and allow the user to move easily.
Ans.:True
[9] Artificial lighting from computer screens can cause sleeping problems.
Ans.:True
[10] The keyboard and mouse should not be kept at the same level.
Ans.: False

D. Short answer type questions

[1] What causes the water pollution?
Ans.: The following are few causes water pollution:
1. Most of the human activities such as sewage, farming, construction, chemical dumping in water
etc/
2. Dumping plastics in water
3. Deforestation
4. Global Warming
5. Natural phenomena

[2] What is occupational overuse syndrome?

Ans.: Occupational overuse syndrome, also known as repetition strain injury (RSI), is a collective
term for
A range of conditions, characterised by discomfort or persistent pain in muscles, tendons and
other soft
Tissues, with or without physical manifestations.

[3] What are musculoskeletal problems?

Ans.: This problem include different areas of your body, such as neck, back, chests, arms
shoulders and feet. It occurs because of your wrong posture, uncomfortable chair for sitting that is
not ergonomically correct while working on the computer.

[4] What cautions to be taken while working on the computer?

Ans.: While working on computer these cautions to be taken:
• Position your computer such that the end of the monitor should be at your eye level.
• Keep the neck neutral with monitor directly ahead to prevent to turn your neck.
• Keep your monitor at least arm length distance, or 20 to 30 inch away from you.
• Maximise contact of your back against the backrest of the chair.
• Adjust height of armrests so that your elbows are at a 100–110 degrees open angle.
• Place keyboard at a slight negative tilt if you are sitting upright.
• While typing, keep your hands slightly lower than elbows, with fingers pointing downwards at
the floor.
• Minimise any twisting of your wrists from side to side or up and down.
• Use a keyboard palm rest as needed only when you are not typing. Do not rest your wrists when
typing. It leads to wrist strain.
• Always take small breaks while working on the computer to stretch your muscles, keep your
blood flowing, and to rest your eyes.

54
 [5] Why there is no right way to use a laptop?
Ans.: There is really no right way to use a laptop because if you position the screen at the right
height for your back and neck, it will cause you to have to lift your arms and shoulders too high to
use it and vice versa.

[6] What causes eye strain and how to avoid it?

Ans.:
Cause – Glares from overhead lights or windows eye glasses not correct need vision check
To avoid it Re-orient your desk and computer so light is not directly behind or in front of you.

[7] What type of display screen is suitable to work on computer?

Ans.: Use the modern LED monitors of legible size and with adequate spacing between the
characters and lines. The image on the screen should be stable, with no flickering or other forms
of instability. The screen must be free of reflective glare and reflections liable to cause discomfort
to the user.

[8] What type of keyboard is suitable to work on computer?

Ans.: The keyboard should tilt and separate from the screen to find a comfortable working
position and avoid fatiguein the arms or hands. The space in front of the keyboard must be
sufficient to provide support for the hands and arms of the user. The keyboard should have a matt
surface to avoid reflective glare. The symbols on the keys must be adequately contrasted and
legible from the design working position.

Chapter 15
Prevent Accidents and Emergencies
A. Multiple choice questions
[1] What are the steps necessary for operating a fire extinguisher?
(a) Identify the safety pin of the fire extinguisher which is generally present in its handle
(b) Break the seal and pull the safety pin from the handle
(c) Use the fire extinguisher by squeezing the lever
(d) All of the above
Ans.:(d) All of the above

[2] Which of the following is an examples of ignition sources of open flames?

(a) Gas ovens
(b) Lighters in smoking areas
(c) Welding torches
(d) All of the above
Ans.:(d) All of the above

[3] In fire classification, all liquid, grease, and gas material comes under ______.
(a) Class A material
(b) Class B material
(c) Class C material
(d) Class A material
Ans.:(b) Class B Material

55
[4] In fire classification, material magnesium, potassium, and sodium comes under _________
(a) Class A material
(b) Class B material
(c) Class C material
(d) Class D material
Ans.:(d) Class D Material

[5] In fire classification, material wood, cloth, and paper comes under ______________
(a) Class A material
(b) Class B material
(c) Class C material
(d) Class D material
Ans.:(A) Class A Material

[6] In fire classification, electrical material and equipment comes under ________.
(a) Class A material
(b) Class B material
(c) Class C material
(d) Class D material
Ans.:(C) Class C Material

[7] When do we use a fire extinguisher?

(a) In case of flood
(b) In case of electric shock
(c) In case of fire
(d) In case of burn injury
Ans.:(c) In case of fire

[8] What is the primary fire emergency telephone number is?

(a) 011
(b) 101
(c) 108
(d) 111
Ans.:(a) 101

[9] Which of the following contains everything you need to know about evacuating your facility
safely?
(a) Evacuation Diagram
(b) Emergency Action Plan
(c) Employee Directory
(d) Both (a) and (b)
Ans.:(d) Both (a) and (b)

[10] The best course of action to take during a medical emergency is to ______________.
(a) Begin first aid immediately
(b) Activate the emergency plan for reporting injuries
(c) Notify the person’s family about the situation
(d) Both (a) and (b)
Ans.: (d) Both (a) and (b)

56
B. Fill in the blanks
[1] Emergency is a serious or crisis situation that needs __________ attention and ___________
Ans.: immediate, action
[2] A ______________ sign will warn people to walk carefully on freshly mopped floors.
Ans.: wet floor
[3] ___________________ signs can prevent accidents on a staircase with a sharp bent or warn against
a loose floor tile.
Ans.: wacth your steps
[4] The __________________ should be responsible to handle evacuation process.
Ans.: coordinator or authority
[5] Workplace fires are commonly caused by improper storage of _________________ material
or ___________ dust.
Ans.: flammable, combustible
[6] There should always be an __________________ plan for scheduled electrical maintenance or
work.
Ans.: emergency response
[7] If the victim is breathing and has a heartbeat, give _______________ for injuries and treat for
shock.
Ans.: first aid
[8] A fire extinguisher is a _______________ containing an agent which can be discharged to
extinguish a fire.
Ans.:(A) 101
C. State whether the following statements are True or False
[1] The organisation’s policies and guidelines is the best guide to handle emergency.
Ans.: True
[2] If someone is injured, act as per your impulse or gut feeling.
Ans.: False
[3] Keep water and food items away from electrical equipment.
Ans.: True
[4] Always switch off the electrical circuits.
Ans.: False
[5] Always wear protective equipment, such as gloves and shoes.
Ans.: False
[6] A fire extinguisher is a protection device used to extinguish fires.
Ans.: True
[7] Flammable materials can be placed around an door exit.
Ans.: False
[8] You can determine possible evacuation routes from floor plan diagrams posted in your facility.
Ans.: True

D. Short answer questions

[1] What is a workplace emergency?
Ans.: Emergency is a serious or crisis situation that needs immediate attention and action. For
example, a customer having a heart attack or sudden outbreak of fire in your organisation needs
immediate attention.

[2] How do you protect yourself, your employees, and your business?
Ans.: The following ways can be used to protect people at work:
1. Notice and Correctly Identify Accidents and Emergencies
2. Get help Promptly and in the Most Suitable Way
3. Follow Company Policies and Procedures for Preventing Further Injury While Waiting for Help to

57
Arrive
4. Act within the Limits of your Responsibility and Authority when Accidents and Emergencies Arise
5. Promptly Follow Instructions given by Senior Staff and the Emergency Services

[3] What is an emergency action plan?

Ans.: An emergency action plan (EAP) is a written document that outlines how to respond to an
emergency. It can be used in a variety of settings, in emergencies.

[4] What should your emergency action plan include?

Ans.: An emergency action plan (EAP) includes the following:
1. Evacuation routes, assembly points, and actions to take during an evacuation
2. Instructions for sheltering in place during an emergency
3. Procedures for contacting emergency responders
4. Procedures for notifying and warning people in an emergency
5. Procedures for locating family members in an emergency
6. Who is responsible for what tasks during an emergency
7. Information about threats and hazards that could be encountered in an emergency
8. Information about actions that can be taken to protect people and property during an emergency
9. Procedures for responding to emergencies

[5] How do you develop an evacuation policy and procedures?

Ans.: To develop an evacuation policy and procedures follow these:
1. Assess the emergency situation
2. Develop an appropriate map for exit
3. Identify any hazard or potential accidental situation then reduce them to an acceptable level
4. Follow some protective measures for safety
5. Keep ready some firefighting equipments
6. Closing the doors as soon as exited from the fire or smoke
7. Process and prepare proper documentations for the same
8. Use some public announcements

[6] How do you establish evacuation routes and exits?

Ans.: To establish evacuation routes and exits follow these:
1. Ensure every room has proper exit windows or doors in emergency
2. Clearly mark the exit points in a such a way they are visible
3. The exits should be wide enough to accommodate people in such emergencies
4. Schedule more and more mock drills
5. Provide accurate training to staff for evacuation procedures
6. Conduct risk assessment
7. Communicate this evacuation plan to everyone
8. Prepare a duty roaster and assign some key responsibilities
9. Keep important documents at safe place

[7] What are the various types of fire extinguisher and their extinguishing material?
Ans.: The six main types of fire extinguisher are water, foam, CO2, powder, water mist and wet
chemical. A relatively new type of fire extinguisher has also been developed to tackle lithium-ion
battery fires and uses AVD (Aqueous Vermiculite Dispersion) to cool the fire and prevent re-ignition.
The fire extinguishing material are as follows:
Class A Material: materials such as wood, cloth, and paper, which won’t ignite on their own but will
continue to burn once exposed to a heat source.

58
Class B Material: all liquid, grease, and gas materials that burn when exposed to ignition sources.
Class C Material: electrical materials and equipment. These materials cause fires very quickly and
present a serious risk of arc flash.
Class D Material: any materials that are volatile and able to quickly ignite, such as magnesium,
potassium, and sodium.

[8] What are the steps for operating a fire extinguisher in case of a fire emergency.
Ans.: The steps for operating a fire extinguisher in case of fire emergency are as follows:
Step 1: Identify the safety pin of the fire extinguisher, present in its handle.
Step 2: Break the seal and pull the safety pin from the handle.
Step 3: Use the fire extinguisher by squeezing the lever.
Step 4: Sweep it from side to side.

[9] Compare the different type of fire extinguisher.

Answer:

Dry ABC
Water Carbon Mechanical
Chemical Dry
CO2 Dioxide Foam
Powder Powder

Class Not Not

Suitable Suitable Suitable
A Suitable Suitable

Class Not
Suitable Suitable Suitable Suitable
B Suitable

Class Not Not

Suitable Suitable Suitable
C Suitable Suitable

Class Not Not Not

Suitable Suitable
D Suitable Suitable Suitable

[10] List the different class of fire.

Ans.: There are several classes of fire, including:
Class A: Fires involving ordinary combustibles like paper, wood, and cloth
Class B: Fires involving flammable liquids and gases
Class C: Fires involving electrical equipment, wiring, or appliances, often caused by overloaded
outlets or damaged power cords
Class D: Fires involving combustible metals like magnesium, potassium, and titanium. These fires can
spread quickly to other combustible materials.
Class K: Cooking fires involving the combustion of cooking liquids like animal fat, vegetable fat, oil,
or grease.
Class F: Fires involving cooking oils and fats, which are technically a type of flammable liquid or gas
fire that burns at a very high temperature
Class E: Electrical fires, which are an oddity because electricity is more of an ignition source than a
fuel. However, electricity can be a potential source of ignition and heat, especially during a short
circuit.

59
[11] List out electrical rescue techniques.
Ans.: The electrical rescue techniques are as follows:
1. Approaching the accident
2. Examining the scene
3. Hazards and Solutions
4. High voltage rescue
5. First Aid

[12] What is the first aid for electrical emergencies?

Ans.: The first aid for electrical emergencies are as follows:
1. A victim may require Cardio-Pulmonary Resuscitation (CPR)
2. If the victim is breathing and has a heartbeat, give first aid for injuries and treat for shock.
3. Ensure the victim gets medical care as soon as possible.
4. Physician attending the victim must have detailed information to properly diagnose and care for
thevictim.

60