Description

https://brpublisher.com/wp-content/uploads/2025/03/NCERT-CLASS-X-ANSWER-KEYS.docx

 

 

 

CHAPTER-1: INTRODUCTION TO STYLES

1. Multiple choice questions:

 

1. Which of the following features in LibreOffice Writer is/areused to create the given document?

(a) Page borders

(b) Envelope

(c) Picture fromFile

(d) Indexes andTables

 

2. Styles menu (fromsidebar) in Writer provide options towork on

(a) Paragraph Styles

(b) Frame Styles

(c) Page Styles

(d) All of the above

 

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

 

4. Which of the following gives the status of your documentlike page numbers, number of pages?

(a) Status bar

(b) Standard toolbar

(c) Formatting

(d) Title 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

ANSWER KEYS:

1. Option- c
2. Option- b
3. Option- c
4. Option- c
5. Option- b

  

1. Fill in the blanks:

 

1. A __________ is a collection of different formats
2. Styles are especially handy in __________
3. Proper use of styles improves __________ in a document
4. The first five buttons at the top of the Styles window select the category of __________.
5. Using predefined __________ creates Bookmark in the document.
6. On opening a new file _________ Style is used for formatting the document.
7. In page layout documents, you can arrange__________liketext boxes and graphics.
8. Character styles are often integrated in __________ Style.
9. __________ allows to apply style at different places in the document.
10. Predefined Style __________ be updated by Drag and Drop method.

 

ANSWER KEYS:

1. Style
2. LibreOffice
3. Consistency
4. Styles
5. Heading Style
6. Default
7. Objects
8. Paragraph
9. Fill format
10. Cannot

 

1. Short answer questions:

 

1. What do you understand by styles in Libre Office writer document?
2. Write advantages of using Style over manual formatting, for designing a document?
3. What are the different categories of style in Libre Office writer document?
4. Write down the steps to update a style?
5. What do you understand by custom styles in LibreOffice writer?
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.

(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.

7. Give two examples, where instead of Style, using manual formatting will be beneficial.
8. Give one situation, in which you will prefer to use Fill Format for styling your document.
9. Write steps to load style(s) from a template.

ANSWER KEYS:

1. Collection of all formatting information, which you want to save and then apply on the document.
2. It helps us to apply consistent formatting to the documents, easily change the existing format, and makes major formatting changes simple.
3. It provides six Style categories – Page, Paragraph, Character, Frame, List and Table.
4. Click the Styles menu at the top of the LibreOffice window and then click Update Selected Style.
5. It is way to do the same thing for your document. Using styles means that you could stop saying “font size 14pt, Times New Roman, bold, centered” and start saying “title” for describing that particular font usage.
6. Done as mentioned
7. Manual formatting beneficial in writing out text and applying formatting rules manually, such as underlining or bolding specific text, adding margins, spacing, etc.
8. This method is useful when a same style is to be applied at many places scattered in the document. Fill Format can be used to style scattered – pages, frames, tables, lists, paragraphs or characters.
9. Open the “Load Styles from Template” dialog. Select Styles ▸ Load Styles from Template from the menu. Select View ▸ Styles, (F11) from the menu to open the Styles window in the sidebar.

 

 

CHAPTER-2: WORKING WITH IMAGES

 

1. Multiple choice questions

 

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

 

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

 

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

(a) Exit Group

(b) Ungroup

(c) Enter Group

(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

 

5. Image toolbar does not provide a tool for _________________.

(a) filtering

(b) cropping

(c) copying

(d) flipping

 

 

ANSWER KEYS:

1. Option- a
2. Option- a
3. Option- d
4. Option- c
5. Option- c

 

1. Fill in the blanks:

 

1. _________ tool cuts off non-desirable part of the image.
2. To change both brightness and contrast of the image________________ tool can be used.
3. To simulate the effect of time on picture _____________tool is used.
4. _________ place image at the bottom of all objects.
5. An image can be deleted by ____________ it and pressing DELETE key.
6. In drawing tools, basic shapes list provide ____________ shapes.
7. Anchor act as _____________ point for a drawing.
8. There are ________________ options for aligning an image horizontally.
9. The ___________ handles of image are used for rotating it.
10. Changing properties of an object _____________ creation, retain them throughout the session

 

 

ANSWER KEYS:

1. Crop
2. Gamma Correction
3. Ageing
4. Send back
5. Selecting
6. 25
7. Reference
8. Three
9. Corner
10. Before its

 

1. Short answer type questions:

 

1. What is a digital image? How can you create one?
2. Write steps to insert an image from the gallery using Drag and Drop method?
3. How is resizing of image different from cropping it?
4. What are the tools available in drawing toolbar?
5. How is linking of an image different from embedding?
6. Write steps to change properties for drawing objects?
7. What are the benefits and drawbacks of grouping drawing objects?
8. Describe any two tools from Drawing Object Properties toolbar?
9. Write steps to insert an image in a basic drawing shape?
10. Write factors controlling positioning of an image in a document?

 

ANSWER KEYS:

1. In a digital document, a graphic or image is called digital image.A digital image is represented in pixels.
2. A general procedure to insert an image using drag and drop option, is as follows.

Step 1. Open the document to insert an image in Libre Office Writer.

Step 2. Open a file browser window (Win+E) and select the image file to be inserted.

Step 3. Drag the image into the document

Step 4. Drop it, where you want it to appear in the document.

3. Resizing the image its size gets changed, but while cropping the image cuts it.
4. Select, insert line, line & arrow, curve, rectangle, oval, isosceles triangle, arrow, call-out, points, font, flowchart, list etc.
5. Linking an image saves only the link of the image instead of embedding the image. This saves space in case multiple copies of the same image are required.
6. Step 1. From the Drawing Toolbar, select the object you want to draw.

Step 2. From Drawing Object Properties Toolbar, click on the icon of property to be modified.

Step 3. Change the value of parameter.

Step 4. Repeat steps 2 and 3 to change all desired properties.

Step 5. Draw the desired figure by following the steps given in the previous section.

7.Grouping enhances faster and easier way of moving objects than moving one by one. The alignment of the object will not change when you move the objects.

8. Drawing Object Properties toolbar: Select- select an object. Insert line- Insert a line.

 

9.A general procedure to insert an image using Insert Image dialog box, is as follows.

Step 1. Open the document to insert an image in LibreOffice Writer.

Step 2. Place the cursor where you want to insert animage.

Step 3. Select and click on Insert > Image from menubar

Step 4. An Insert Image dialog box will open which willallow to choose the picture file to be inserted.

Step 5. Select the file and click on Open button to insertan image in document.

10. Positioning of an image is controlled byfour settings.

(i) Arrangement(ii) Anchoring(iii) Alignment(iv) Text Wrapping

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

CHAPTER-3: ADVANCED FEATURES OF WRITER

 

1. 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

 

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

 

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

 

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

 

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.

 

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

 

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

 

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

 

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

 

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

 

11. Which of the following menus contains the Track Changes option?

(a) File

(b) Edit

(c) View

(d) Insert

 

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

 

 

 

 

 

 

 

 

ANSWER KEYS:

1. Option- a
2. Option- d
3. Option- c
4. Option- c
5. Option- c
6. Option- b
7. Option- b
8. Option- b
9. Option- b
10. Option- d
11. Option- b
12. Option- a

 

1. Fill in the blanks

 

1. To navigate to the topic from the ToC, press ___________key while clicking the mouse button on that topic.

 

2. To remove the applied paragraph styling in the ToC, select the outline level in the Levels list box, and then click the _______ button.

 

3. If the checkbox for___________________ option is selected, the ToC is protected from any accidental change.

 

4. To update the ToC manually, right click and select ___________ option from the pop up menu.

 

5. The ___________ tab contains options to set the number of columns that we want to have in our ToC.

 

6. A ________________________ is a preset layout that helps us to create professional and formal documents easily.

 

7. The default template in Writer is ____________________.

 

8. To find the template that is being used in the current document, select ___________ option from the File menu.

 

9. The ____________________ button is clicked in Templates dialog box to view online templates.

 

10. The __________________ feature of Writer offers us an alternative method to keep a record of all the changes made in the original document.

 

11. The shortcut key to start recording the changes is_________.

 

12. After the Track Changes feature is ON, the added characters are shown as ____________ text.

 

ANSWER KEYS:

1. Ctrl
2. Default
3. Protected against manual changes
4. Update index
5. Columns
6. Template
7. Blank documents template
8. Properties
9. Browse online template
10. Track Changes
11. Ctrl + Shift + C
12. Coloured

 

1. State whether the given statements are True or False

 

1. The topics in Table of Contents are hyperlinked.

 

2. The Table of Contents in LibreOffice Writer can be updated automatically.

 

3. TABLE of Contents can be inserted even if the section headings are not styled.

 

4. Once a ToC is created, it cannot be edited.

 

5. We cannot add a graphic as a background of ToC.

 

6. A single template can be used for multiple documents.

 

7. A template cannot contain graphics.

 

8. All documents in Writer are based upon templates.

 

9. The online templates cannot be added to the list of templates in the templates dialog box.

 

10. A template once created can be edited again and again.

 

11. The changes recorded have to be accepted by the original author.

 

12. We can delete the comments added in a document by the user.

 

ANSWER KEYS:

1. True
2. False
3. False
4. False
5. False
6. True
7. False
8. True
9. False
10. True
11. False
12. True

 

1. Answer the following questions:

 

1. What is the need of table of contents?
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?
3. Name the five tabs present in the Table of Contents, Index or Bibliography dialog box.
4. What do you mean by customization of ToC?
5. How headings and sub-headings of a document differentiated in ToC?
6. Define a template.
7. Give any one advantage of using a template for your document.
8. What is the difference between importing and exporting a template?
9. Name any two categories of templates.
10. When is exporting of templates useful?
11. What is the difference between Accept Track Change and Accept All Tracked Changes buttons?
12. How do we prepare a document for review?

 

 

 

ANSWER KEYS:

1. Table of Contents, allows to insert an automatedtable of contents in a document. The entries or contentsof this table are automatically taken from the headingsand sub headings of the document.
2. Protected against Manual Changes option isselected. This protects theToC from any accidental Change. If this box isunchecked, then thecontents of ToC can bechanged directly on thedocument page, just like anyother text on the document.
3. Five Tabs – Type, Entries, Styles,Columns and Background.
4. ToC is inserted, we can customize it according to ourrequirements. To do so, right clickanywhere on the ToC and selectEdit Index option
5. Supports up to 10 levels of headings H1to H10. These headings are applied to the headings of the

document.

6. A template is a layout that helps to createprofessional and/or formal documents easily.
7. Templates can be used to create a resume, chapter orproject report. A template can contain all the featuresor objects that a regular document can contain – text,graphics, and styles and can even use any language.
8. Template is downloaded and saved in any file orfolder, it is possible to import it so that it is visible in thelist of templates in the Templates dialog box. Export template featureallows to store the

template file in thedesired folder on yourcomputer. It is differentfrom moving a templatefrom one categoryfolder to another.

9. Category- My Template and Business Correspondence
10. Exporting thetemplate is a usefulfeature for sharing the templates with multiple users.

 

11. Accept/Accept All Track Changes – Once theediting is done, the original author may accept

the change made to the document by clicking, Accept All Track Changes button will accept

all the changes made to the document.

12. Before the document issent for review, the original author should prepare thedocument for review and start recording the changesbeing made. For that, select Edit > Track Changes>Record option. Alternatively, select the Record buttonfrom the Track Changes toolbar.

 

CHAPTER-4: ANALYSE DATA USING SCENARIOS AND GOAL SEEK

 

1. Multiple choice questions

 

1. Which of the following feature is not used for data analysis in spreadsheet?

(b) Consolidating data

(c) Goal Seek

(d) Subtotal

(e) Page layout

 

2. Which of the following office tool is known for data analysis?

(a) Writer

(b) Calc

(c) Impress

(d) Draw

 

3. Which of the following operations cannot be performed using LibreOffice Calc?

(a) Store and manipulate data

(b) Create graphical representation of data

(c) Analysis of data

(d) Mail merge

 

4. What is the extension of spreadsheet file in Calc?

(a) .odb

(b) .odt

(c) .odg

(d) .ods

 

5. The default function while using Consolidate is____________.

(a) Average

(b) Sum

(c) Max

(d) Count

 

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

 

7. Which tool is used to predict the output while changing the input?

(a) Consolidate function

(b) What-if scenario

(c) Goal seek

(d) Fine and Replace

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

(a) C5

(b) $C$5

(c) $C

(d) #C

 

9. _____________ analysis tool works in reverse order, finding input based on the output.

(a) Consolidate function

(b) Goal seek

(c) What-if analysis

(d) Scenario

 

ANSWER KEYS:

1. Option- g
2. Option- b
3. Option- d
4. Option- d
5. Option- b
6. Option- d
7. Option- b
8. Option- b
9. Option- b

 

1. State whether the following statements are True or False

 

1. Consolidate function is used to combine information from two or more sheets into one.

 

2. Consolidate function cannot be used to view and compare data.

 

3. Link to source data is checked updates the target sheet if any changes made in the source data.

 

4. Using subtotal in Calc needs to use filter data for sorting.

 

5. Subtotal tool can use only one type of summary function for all columns.

 

6. Only one scenario can be created for one sheet.

 

7. What-if analysis tool uses one array of cells.

 

8. Goal seek analysis tool is used while calculating the output depending on the input.

 

9. The output of What-if tool is displayed in the same cell

 

 

ANSWER KEYS:

1. True
2. False
3. True
4. False
5. False
6. False
7. False
8. False
9. False

 

1. Fill in the blanks

 

1. Consolidate function is used to combine information from multiple sheets to _______________________ the information.
2. Data can be viewed and compared in a single sheet for identifying trends and relationships using ______________function.
3. ________________ under Data menu can be used to combine information from multiple sheets into one sheet to compare data.
4. The _________________ tool in Calc creates the group automatically and applies functions on the grouped data.
5. _______________ scenario is used to explore and compare various alternatives depending on changing conditions.
6. ______________ is a planning tool for what-if questions.
7. What-if analysis tool uses ____________ array of cells, one array contains input values and the second uses the_____________.
8. _____________ helps in finding out the input for the specific output.

 

ANSWER KEYS:

1. Summarize
2. Consolidate
3. Sub Total
4. Sub Total
5. What if
6. What if
7. Two, formula and display output
8. Goal seek

 

1. Answer the following questions:
2. Define the terms (a) Consolidate function (b) What-if analysis (c) Goal seek
3. Give one point of difference between (a) Subtotal and What-if (b) What-if scenario and What-if tool
4. Give any two advantages of data analysis tools.
5. Name any two tools for data analysis.
6. What are the criteria for consolidating sheets?
7. Which tool is used to create an outline for the selected data?

 

ANSWER KEYS:

1. a) Consolidate is a function used to combine information from multiple sheets of the spreadsheet into one place to summarize the information.
2. b) What-if scenario is a set of values that can be usedwithin the calculations in the spreadsheet.
3. c) Goal Seek is in general we fill in the values in the cells and thencreate formula on these values to get the requiredresult.
4. a) The Subtotal tool in Calc createsthe group automatically and appliescommon functions like sum, average on the grouped data and What-if scenario is a set of values that can be used

within the calculations in the spreadsheet.

1. b) What-if tool uses Data > Multiple Operations andis a planning tool for what-if questions. In this, theoutput is not shown in the same cells, whereas it uses adrop-down list to display the output depending upon theinput.
2. Analyzing data is the process to extract useful informationfor making effective decisions. The spreadsheet is one ofthe best software used for data analysis. It is used to retrieve, correlate, explore and visualize data to identifypatterns, trends and relationships.
3. Scenarios and Goal Seek
4. The consolidated sheet will have all the consolidated data along with the original data. You can view the original data of both the sheets and by clicking on the ‘+’ sign in front of the consolidated row.
5. Sub-Total.

 

 

 

 

CHAPTER-5: USING MACROS IN SPREADSHEET

 

1. Multiple choice questions

 

1. Macro Recordings can be enabled from the ________ option in the menu bar.

(a) Sheet

(b) Data

(c) Tools

(d) Window.

 

2. Which of the following is an invalid Macro Name?

(a) 1formatword

(b) format word

(c) format*word

(d) Format_word.

 

3. Which of the following Libraries contains modules with prerecorded macros and should not be changed?

(a) My Macros

(b) Libre Office Macros

(c) Untitled1

(d) Test.

 

4. Identify which of the following is a programming Language?

(a) Calc

(b) BASIC

(c) Writer

(d) Macro.

 

5. The Module can be executed from the IDE by pressing _________________.

(a) F3

(b) F4

(c) F5

(d) F6

 

6. Which of the following is the default name of the Macro_______________.

(a) Default

(b) Main

(c) Macro1

(d) Main_Macro

 

 

 

 

ANSWER KEYS:

1. Option- c
2. Option- d
3. Option- b
4. Option- b
5. Option- c
6. Option- b

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1. Fill in the blanks

 

1. ________ library is automatically loaded when the document is opened.

 

2. IDE stands for _______________________________.

 

3. Macro as a function is capable of accepting ___________ and returning a ____________.

 

4. Macro ________________ allows us to add, delete a module.

 

5. The code of macro begins with __________ followed by the name of the macro and ends with __________.

 

6. By default a macro is saved in the _____________ .

 

 

ANSWER KEYS:

1. Standard
2. Integrated Development Environment
3. Augment, Result
4. Organizer
5. Sub, End Sub
6. Standard Library

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1. State whether the following statements are True or False

 

1. Macro is a group of instructions executing a single instruction.

 

2. Once created, Macro can be used any number of times.

 

3. By default, the Macro recording feature is turned on.

 

4. It is not possible to stop recording of a Macro.

 

5. Every Macro should be given a unique name.

 

6. A macro once created can be edited later.

 

ANSWER KEYS:

1. False
2. True
3. False
4. False
5. True
6. True

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1. Answer the following questions:

 

1. What is a Macro?
2. List the actions that are not recorded by a macro?
3. How is Libre Office Macros Library different from my Macros?
4. Differentiate between predefined function in Calc and Macros as a function?
5. List the rules that should be kept in mind while naming a macro?
6. Give any one advantage of macros?

 

ANSWER KEYS:

1.A macro is a single instruction that executes a set ofinstructions. These set of instructions can be a sequenceof commands or keystrokes that can be used for anynumber of times later. A sequence of actions such askeystrokes and clicks can be recorded and then run asper the requirement.

2. The Macro records all the keyboard andmouse actions but the following actions are not recorded:

• Opening of windows.
• Actions carried out in anotherwindow than where the recordingwas started.
• Window switching
• Actions that are not related to the spreadsheet contents.
• Selections are recorded only if they are done byusing the keyboard (cursor traveling), but notwhen the mouse is used.
• The macro recorder works only in Calcand Writer.

3.Follow the steps given below to record a macro.

Step 1. Click on Tools > Macros and then click onthe Record Macro option.

Step 2. Now start taking actions that willbe recorded.

Step 3. Once you click on Record Macro option,recording of actions starts and a small

Alert Clicking on “Stop Recording” button willstop the recording of actions.

Step 4. This will open the Basic Macros dialogwindow to save and run the created macro

Step 5. To save the macro, first select the objectwhere you want the macro to be saved in

the Save Macro to list box.

Step 6. The name of the macro by default is Mainand is saved in the Standard Library in

Module1. You can change the name ofthe macro.

Step 7. Click on Save button.

4. Consider a situation wherein you need to performcalculations that are repetitive in nature. Assume thatthe same formula needs to be applied to different data indifferent sheets and there is no predefined function for it.In such a situation will it not be convenient if we couldcreate a macro that performs the calculations? It will saveus the effort of remembering and typing the formulas. Itis possible to do so if we use Macro as a function. Insteadof writing instructions in between Sub and End Sub, wecan write instructions in between Function and EndFunction. A function is capable of accepting argumentsor values. It can perform operations on the arguments,perform calculations and return the result.
5. Rules for naming a Macro, Module or a Library: noteswhile naming a Macro, Module or a Library the nameshould:

• Begin with a letter
• Not contain spaces
• Not contain special characters except for _(underscore).

6. Macros perform repeated tasks suchas typing school name, address, contact numbers witha specific formatting or apply the same formula at aparticular cell for different sheets in a workbook.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

CHAPTER-6: LINKING SPREADSHEET DATA

 

1. Multiple choice questions:
2. Insert Sheet dialog can be invoked from _______________.

(a) sheet

(b) insert

(c) tools

(d) Windows

2. ______________ refers to cell G5 of sheet named My Sheet.

(a) $My Sheet.’G5’

(b) $My Sheet_’G5’

(c) $ ‘MySheet’.G5

(d) $ ‘MySheet’_G5

3. The path of a file has ____________ forward slashes.

(a) four

(b) three

(c) two

(d) one

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

 

 

ANSWER KEYS:

1. Option- a
2. Option- c
3. Option- b
4. Option- c

 

 

 

 

 

 

1. Fill in the blanks:

 

1. A relative hyperlink stores the location with respect to the___________ location.
2. While inserting tables from a webpage _____________selects the entire HTML document.
3. The extension of LibreOffice base is ______________.
4. __________ are used to enclose sheet names as there might be a space within sheet names.
5. The From file option of ___________ Dialog box allows to insert sheet from another file.

 

ANSWER KEYS:

1. Current
2. HTML_all
3. .obd
4. Single Quote (‘ ‘)
5. Insert Sheet

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1. State whether the following statements are True or False

 

1. A sheet can only be added before the current sheet.
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.
3. It is not possible to link a sheet as a reference in another sheet.
4. We can insert data from a table created on a web page into a spreadsheet.
5. A hyperlink once created on a sheet cannot be deleted.

 

ANSWER KEYS:

1. False
2. True
3. False
4. True
5. False

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1. Answer the following questions:
2. Name the two ways to link the sheets in a Libre Office Calc?
3. Differentiate between Relative and Absolute Hyperlink?
4. Write steps to extract a table from a web page in a spreadsheet?
5. Write steps to register a data source that is in *.odb format?
6. State advantages of extracting data from a web page into spreadsheet?

 

ANSWER KEYS:

1. Two ways are: create a reference and Link external data.
2. A hyperlink can be either absolute or relative. An absolute hyperlink stores the complete location wherethe file is stored. A relative hyperlink stores the location with respect tothe current location.
3. The web pages are written inHTML documents. Data on a web page can be stored in

the form of tables.The versatility of a spreadsheet allows us to inserttables from HTML documents into Calc. To insert thetables from a HTML document, we can use the ExternalData Dialog box. The steps for the same are given below.

Step 1. Open the spreadsheet where external data is tobe inserted.

Step 2. Select the cell to store the first cell of the tablein the external data.

Step 3. Select Sheet > Link to External Data.

4. To register a data source that is in *.odb format, follow the stepsgiven below.

Step 1. Select Tools > Options >LibreOffice Base > Databases.The Options – LibreOffice

Base-Databases dialog boxappears.

Step 2. Click the New button toopen the Create Database Link

Step 3. Enter the location of the database file, or clickBrowse to open a file browser and select the

database file.

Step 4. Type a name to use as the registered name forthe database and click OK. The database is

added to the list of registered databases.

5. The versatility of a spreadsheet allows us to insert tables from HTML documents into Calc. To insert the tables from a HTML document, we can use the ExternalData Dialog box. The steps for the same are given below.

Step 1. Open the spreadsheet where external data is tobe inserted.

Step 2. Select the cell to store the first cell of the tablein the external data.

Step 3. Select Sheet > Link to External Data.

Step 4. The External Data dialog box is displayed as shown. Type the URL of the sourcedocument or select it from the drop-down list ifit is listed and press enter.

Step 5. A dialog box is displayed to select the languagefor import as shown in Fig. 6.18. Selecting

Automatic shows data in the same language asin the webpage.

 

 

CHAPTER-7: SHARE AND REVIEW SPREADSHEET

1. Multiple choice questions
2. Sharing allows to edit the spredshheet by

(a) single user

(b) different users simultaneously

(c) one by one users

(d) one after other users

 

 

2. Sharing spredsheet feature allows to save the changes in

(a) multiple sheets

(b) user’s sheet

(c) in a same sheet

(d) in different sheet

 

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

 

4. In Calc, the comments are added

(a) automatically

(b) by author

(c) by reviewer

(d) all of above

 

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

(d) other users

 

ANSWER KEYS:

1. Option- b
2. Option- a
3. Option- d
4. Option- d
5. Option- c

 

1. State whether the following statements are True or False

 

1. Spreadsheet cannot be shared to work with more than oneuser?
2. Some of the features becomes unavailable when thespreadsheet is in shared mode.
3. You can record changes in the spreadsheet when thespreadsheet is opened in shared mode.
4. File menu is used to Record changes for the spreadsheet.
5. You can add a note or suggestion in the spreadsheet usingInsert Comment.
6. Formatting comment can be used to change the fontcolour of the comment.

 

ANSWER KEYS:

1. False
2. True
3. False
4. False
5. False
6. True

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1. Fill in the blanks:

 

1. The title bar of the document shows __________________along with the filename for the shared mode of the spreadsheet.
2. The shared mode spreadsheet allows __________ users to access and edit the spreadsheet at the same time.
3. Recording changes automatically ____________ the shared mode of a spreadsheet.
4. Click on Edit menu, Track Changes and then select____________ to record the changes in the spreadsheet.
5. The border color of the changed cell will be ______________.
6. ____________ is used to add notes or suggestions to a celling a spreadsheet.
7. The comment box can be formatted just like formatting the __________ (cell contents).

 

ANSWER KEYS:

1. Shared
2. Many
3. Turn off
4. Record
5. Red
6. Comments
7. Cell contents

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1. 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
3. Which menu is used to perform the functions (a) Track Changes (b) Saving Spreadsheet?
4. What do you understand by reviewing the changes in the spreadsheet?
5. Differentiate between Merging and Comparing Spreadsheet?

 

ANSWER KEYS:

1. a) Sharing a spreadsheet is just like a teamwork to work in collaboration with other users.
2. b) Record Changes provides different ways to record the changes made by one or other users in

the spreadsheet. While recording the changes, thespreadsheet will turn off its shared feature.

2. a) The following are the stepsto share the spreadsheet.

Step 1. Open a new spreadsheet and save it with some name.

Step 2. Select and click on Tools >Share Spreadsheet from main menubar. This will open the Share Documentwhich can be used to enable or disablesharing option.

Step 3. Click on the checkbox “Sharethis spreadsheet with other users” toshare the spreadsheet and click on OKbutton.

Step 4. Click on Yes to continue.

Step 5. Once the spreadsheet is saved, the name of thespreadsheet in the title bar will display (shared)along with the name of the spreadsheet.

1. b) Follow thefollowing steps for recording changes:

Step 1. To enable the Record changes, first disable theshared mode of spreadsheet.

Step 2. To disable the shared mode, open thespreadsheet “Test.ods”.

Step 3. Select and click on Tools > Share Spreadsheetfrom main menu bar. This will open the

Share Document dialog window. Remove the check-mark on the checkbox, “Share thisspreadsheetwith other users”, and clickon OK button.

3. Share Spreadsheet.
4. Reviewing the changes in the spreadsheet, In thisstage, we will go through the changesto accept or reject to prepare the finalspreadsheet after looking at all the changesmade by the team members.
5. Merging Spreadsheet- If the same spreadsheet is reviewed by different team members and you have two different versions of thesame spreadsheet file.

Comparing Spreadsheet- Instead of merging two spreadsheets, one cancompare the two spreadsheets by comparing thedocuments

 

 

 

 

 

 

CHAPTER-8: INTRODUCTION TO DATABASE MANAGEMENT SYSTEM

1. Multiple choice questions
2. Which of the following can be considered as an example of a database?

(a) Dictionary

(b) Telephone directory

(c) Marks Register

(d) Newspaper

2. Which of the following is NOT a DBMS?

(a) MS Access

(b) Open Office Base

(c) MS Excel

(d) MySQL

3. DBMS stands for ______________________.

(a) Data and Books Management System

(b) Database Management System

(c) Duplicate Books Management System

(d) Data Management Multi 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

5. The details associated with an entity are called____________.

(a) Table

(b) Attributes

(c) Records

(d) Primary key

6. A __________ is represented as rows in a table.

(a) field

(b) attribute

(c) record

(d) candidate 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

 

 

 

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

(a) Primary key

(b) Alternate key

(c) Foreign key

(d) Candidate key

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

10. A _____________ is a question asked from a database.

(a) query

(b) report

(c) form

(d) field

 

ANSWER KEYS:

1. Option- d
2. Option- c
3. Option- a
4. Option- b
5. Option- b
6. Option- d
7. Option- d
8. Option- a
9. Option- c
10. Option- a

 

 

 

 

 

 

 

 

1. State whether the following statements are True or False:

 

1. A database cannot be organised.
2. Data is the collection of raw facts.
3. A table can be created without a primary key.
4. Two tables can be related in a network data model.
5. MS Access is an example of a database.

 

ANSWER KEYS:

1. False
2. False
3. True
4. False
5. True

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1. Fill in the blanks

 

1. The raw facts constitutes _____________.
2. An _____________ is a real world object about which information is to be stored in a database
3. The output of a query may be displayed in the form of________.
4. The data values for all the fields related to a person or object is called a _________.
5. All the field values that are eligible to be the primary key are the ___________ keys for that table

 

 

ANSWER KEYS:

1. Data
2. Entity
3. Report
4. Record
5. Candidate

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1. Answer the following questions:
2. Define the terms (a) Database (b) Data redundancy (c) Report
3. Give one point of difference between (a) Data and Information, (b) Form and Query, (c) Network and hierarchical data model
4. Give any four advantages of a DBMS.

 

ANSWER KEYS:

1. a) A database is a collection of logically related data itemsstored in an organized manner. The information beingstored in a database can be added, modified, deletedor displayed according to the requirements of the user.
2. b) In the event ofrequiring the same data field in several tables thedata field might get repeated in number of tables.This is called as data redundancy.
3. c) The output of a query may be displayedin the form of reports. The usual result of thequery is in the form of rows and columns.
4. a) Data: The raw facts constitutes data. The facts may be relatedto any person, place, activity or things. It may be storedin the form of text, graphics, audio or video. This datamust be processed by any computing machine in aproper way to generate the useful and meaningfulinformation.

Information:It is the processed or organized form ofdata. If data is not correct or accurate, the informationobtained by processing such data may not be correct.

1. b) Forms – A form is a feature of a database usingwhich we can enter data in a table in an easy

and user friendly manner. A form consists of textboxes, labels, radio buttons, list boxes, check

boxes etc. that give a user friendly interface forentering data. The data entered through the forms

is stored in tables.

Queries – A query is used to retrieve the desiredinformation from the database. In simple terms,

it is a question asked from the database. Forexample, if we want to view the names of onlythose students who have scored more than50 marks, then we post a query. The data setmatching the given criterion is retrieved from thetable and displayed on the screen.

1. c) Network Data Model- In this model, multiple records are linked to samemaster file. It is also considered as an inverted treewhere master is present in the bottom of the tree andthe branches contain information linked to the master.

Hierarchical data model- In this model the data is organized into a tree likestructure. The data is stored in the form of records.A record is a collection of fields and its data values.

3.The software that is used to create, update and retrievedata is known as database management system(DBMS). It facilitates planning and maintenance of thedatabase for the user. Some of the common examplesof DBMS are MS Access, Open Office or LibreOfficeBase, Oracle, Ingress, MySQL. In this book, we will useLibreOffice Base version 6.4 to learn various aspectsof DBMS.

 

 

 

 

CHAPTER-9: STARTING WITH LIBRE OFFICE BASE

1. Multiple choice questions
2. Which of the following is NOT a type of text data type?

(a) Memo

(b) Varchar

(c) Float

(d) Char

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

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

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.

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

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

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

(a) Ctrl+ D

(b) Ctrl+O

(c) Ctrl+E

(d) Ctrl+F

 

 

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

9. While entering records in a table, we can move to the next field by pressing the _________ key.

(a) Tab

(b) Ctrl

(c) Enter

(d) Shift

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

 

ANSWER KEYS:

1. Option- c
2. Option- b
3. Option- c
4. Option- a
5. Option- c
6. Option- a
7. Option- b
8. Option- a
9. Option- a
10. Option- b

 

 

 

 

 

 

 

 

1. State whether the following statements are True or False:

 

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

 

 

ANSWER KEYS:

1. True
2. True
3. False
4. False
5. True
6. True
7. False
8. True
9. False
10. True

 

 

 

 

 

 

 

 

 

 

 

1. Fill in the blanks

 

1. A data type refers to the type of data that will be stored in that particular field.
2. The _____________ data is a combination of letters, numbers or special characters.
3. ________ data type can be used to store Aadhar number.
4. The __________ data type used to store digitized images.
5. The shortcut key to save a table is _______________.
6. ______________ on the Base Interface Window displays information about the type of view of the object in the database.
7. A __________ icon appears before the field name indicating that it is a primary key.
8. The data can be entered in a table only in __________ view.
9. The black pointing arrow just before the field name in a table is called ____________.
10. The process of arranging the records in particular order on any filed is called _______________.

 

ANSWER KEYS:

1. Data Type
2. Text
3. Text
4. Binary
5. Ctrl+S
6. Tasks Pane
7. Key
8. Datasheet
9. Record Pointer
10. Sorting

 

 

 

 

 

 

 

 

 

 

1. Answer the given questions:
2. Differentiate between: (a) Memo and Varchar data type (b) Number and Decimal data type

(c) Design View and Datasheet view of a table

2. Name the menu items present on the Base User Interface,
3. Label the components – Title Bar, Database Pane, Tasks Pane, Status Bar of the LibreOffice Base User Interface.
4. How can we define a primary key in a table?
5. Write steps to sort the table in descending order of primary key.
6. What is the use of navigation box with respect to tables in a database?

 

ANSWER KEYS:

1. a) Memo- Stores up to the maximum length indicated by user. It is used to store some descriptive data having more than 255 characters. Memo data type allows to store text data up to 64,000 characters.

Varchar Data type- Stores upto the specified length. The number of bytes allocated depends on the number of characters entered by the user. For example, the address is defined as varchar (50), and if the address entered by the user is of 20 characters then only 20 bytes will be occupied in the database.

1. b) Number Data Type- Numeric data typesconsists of numbers. The numbers can be integeror real numbers on which any type of arithmeticcalculations can be performed.

Decimal Data Type- – Decimal data typesconsists of numbers with decimal. The numbers can be integeror real numbers on which any type of arithmeticcalculations can be performed.

1. c) Design View- To create table using Design View, inmain Database window, click on the

option Create Table in Design Viewin the Tasks Pane and Table DesignWindow.

Datasheet View- The datasheet viewof the table will displays the fieldnames in the top row. These fieldsare displayed in the same orderas they were added while creatingthe table.

2. Base User Interface- Title Bar, Menu Bar, Standard toolbar and status bar.
3. Base User Interface- Title Bar, Menu Bar, Standard toolbar and status bar.
4. Every table must have a primarykey that uniquely identifies a record in the table. To

make a particular field as the primary key, place themouse 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 popup menu andA key iconappears before the field name indicatingthat it is a primary key.

5. Data in a table can be arranged in ascending or descending order. This process of arranging the recordsin particular order on any filed is called as sorting.

Follow the following steps to sort the table.

Step 1. Open the Event table in datasheet view and select the field on which you want to sort.

The field “Points” is selectedto sort the records in ascending order.

Step 2. Select SortDescending icon if the table has to be sortedin descending order of selected field.

6. The black pointing arrow just before the field name is the record pointer. To navigate through various records of the table, we use the navigation box present at the bottom of the datasheet window which indicates a current record of the table at any given time.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

CHAPTER-10: WORKING WITH MULTIPLE TABLES

1. Multiple choice questions
2. 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

2. Which of the following is checked by a DBMS?

(a) Redundancy

(b) Inconsistency

(c) Both (a) and (b)

(d) Neither (a) nor (b)

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.

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

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

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

Table 1: Item                                    Table 2: Item_Category

Item_CodeCategory_Code

Item_NameCat_Name

Price                                               Item_Code

QtyCat_Disc

Category_Code

 

 

7. Which of the following menus contains the Relationship option?

(a) Edit

(b) File

(c) Tools

(d) View

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)

(d) Neither (a) nor (b)

9. In the relationship design screen, the relationship between the two tables is done using __________ operation.

(a) Click

(b) Double Click

(c) Drag and Drop

(d) Right click

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

 

ANSWER KEYS:

1. Option- d
2. Option- c
3. Option- b
4. Option- b
5. Option- b
6. Option- b
7. Option- c
8. Option- a
9. Option- c
10. Option- d

 

 

 

1. State whether the following statements are True or False:

 

1. Redundancy is preferred in a database.
2. In a table, a record for a particular entity should not be repeated.
3. A single field should always have only one data value.
4. If a table is edited, the records already entered in it are deleted.
5. The record in master table should be entered before the corresponding record is entered in the transaction table.
6. In one-to-many relationship, one specific record of the master table has more than one corresponding records in the related transaction table.
7. The Relationship option is present in the Widows menu.
8. In a database, the referential integrity is maintained by the user.
9. A relationship is always set between the tables based on a common field.
10. If the master record is deleted, the transaction records will always be deleted.

 

ANSWER KEYS:

1. False
2. True
3. False
4. False
5. True
6. True
7. False
8. False
9. True
10. False

 

 

 

 

 

 

 

 

 

1. Fill in the blanks:

 

1. A table to be edited is displayed in ___________ view.
2. The most important prerequisite for setting a relationship between the two tables is that there must be a ________________between them.
3. In ________________relationship, one specific record of a master table has one and only one corresponding record in the transaction table.
4. ___________________is one of the most common types of relationship between the tables in a database.
5. A record being entered in a _________ table must always exist in a ________ table.
6. The principle of _______________helps prevent missing data by keeping deleted data from getting out of synch.
7. Creating ____________ between tables restricts the user from entering invalid data in the referenced fields.
8. Data integrity is maintained by ______________.
9. A relationship between customers and products is an example of __________________ relationship.

 

ANSWER KEYS:

1. Design
2. Common field
3. One-to-one
4. One-to-many
5. Transaction, master
6. Referential Integrity
7. Relationship
8. DBMS
9. Many-to-many

 

 

 

 

 

 

 

 

 

1. Answer the following questions:

 

1. Give any two advantages of relating a table in a database?
2. How is redundancy or inconsistency controlled in a database?
3. Define referential integrity. Who maintains referential integrity in a database?
4. Differentiate between one to one relationship and one to many relationship?
5. Explain many to many relationship?

ANSWER KEYS:

1. There are various advantages of relating tables in adatabase. Few of them are as given below.

• A relationship can help prevent data redundancy.
• It helps prevent missing data by keepingdeleted data from getting out of synch. This iscalled referential integrity. We will study in detailabout referential integrity.

2. While working with multiple tables, you need to check the redundancy and inconsistency of data. The record for a particular entity should neither be repeated nor different data values should appear for a single entity in the database. This is done by setting relationship between the tables of a database. The most important prerequisite for setting a relationship is that there must be a common field(s) between the two tables to create a relationship.
3. Referential Integrity helps prevent missing data by keeping deleted data from getting out of synch. According to the principle of referential integrity, no unmatched foreign key values should exist in the database.
4. One to One relationship- In this type of relationship, one specific record of a master table has one and only one corresponding record in the transaction table.

One to Many relationship- Inthis type of relationship, one specific record of the mastertable has more than one corresponding records in the related transaction table.

5. Many to Many Relationship- In this type of relationship, there will be multiple records in the master table that correspond to multiplerecords in the transaction table as well.

Generally thistype of relationship is set when certain records haveto be saved more than once in both the related tables.

 

 

 

 

 

 

 

 

 

CHAPTER-11: QUERIES IN BASE

1. Multiple choice questions
2. Which of the following is refer to asking questions from the database?

(a) Report

(b) Table

(c) Query

(d) Database

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

(a) Wizard

(b) Design View

(c) SQL

(d) All of the above

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)

4. Into how many parts is the query design window divided?

(a) One

(b) Two

(c) Three

(d) Four

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

6. Which of the following is the shortcut key to run the query?

(a) F3

(b) F4

(c) F5

(d) F6

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

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) ∧

9. Which of the following relational operators can be applied to set the criterion while designing a query in LibreOfficeBase?

(a) >

(b) =

(c) !=

(d) Add Form

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

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

 

ANSWER KEYS:

1. Option- c
2. Option- d
3. Option- b
4. Option- b
5. Option- d
6. Option- c
7. Option- d
8. Option- a
9. Option- d
10. Option- c
11. Option- c

 

 

 

1. State whether the following statements are True or False

 

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

 

ANSWER KEYS:

1. False
2. False
3. True
4. False
5. False
6. True
7. True
8. False
9. True
10. True
11. True

 

 

 

 

 

 

 

 

 

 

1. Fill in the blanks

 

1. A ____________ is a sort of question asked from a database.
2. The result of the query is displayed in ____________ form with field names in columns
3. A query can be created in ________ways.
4. The Query Design window is divided into __________ sections.
5. The shortcut key to run the query is ______________.
6. The conditions to filter the records are set in the _________ row.
7. When a table is selected in a Query wizard, the corresponding fields are displayed in the__________________list box.
8. The result of the query can be displayed in __________ or _____________ order of any particular field of the table.
9. At the most __________ search conditions can be given in the query wizard.
10. The last step of the Query wizard displays the entire ____________ of the query.
11. The _____________ view is a more flexible method to create a query.
12. To edit any query, right click on the ________ icon of the query that has to be edited.
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.

 

ANSWER KEYS:

1. Query
2. Report
3. Three
4. Two
5. F5
6. Criterion
7. Available fields
8. Ascending, Descending
9. Three
10. Overview
11. Design
12. Query
13. Alias

 

 

 

 

 

1. Answer the given questions
2. Define a query? What is the need of creating a query in a database?
3. Rearrange the steps given below so as to create a query using a wizard.

Give Alias, Select the fields, Set the criterion, Set the sorting order, and Give table name.

3. What is the use of Alias row in the Design grid of the Query Design window?
4. Name any four mathematical functions that can be applied to numerical data in a query.
5. Name the three ways of creating a query in Libre Office Base?

 

ANSWER KEYS:

1. A query is one of the most important feature of any DBMS. Using a query, we can retrieve and display data from one or more tables in a database. This is done by giving specific search criteria to the DBMS so that we are able to view the exact information that we want.
2. Select the Field, Give Alias, Set the criterion, give the table name, set the sorting order.
3. Alias row in the Design grid of the Query Design window can be used to displaymeaningful names in the output.
4. Mathematical functions to find the count,sum, minimum, maximum or average of data values.
5. A query can be created in three ways.

(i) Using a Wizard

(ii) In Design View

(iii) In SQL view

 

 

 

CHAPTER-12: FORMS AND REPORTS

1. 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

2. The Record toolbar has the buttons to move to the

(a) first record

(b) second record

(c) last record

(d) all records

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

4. Which of the following keys is pressed to select only textbox on the form?

(a) Alt

(b) Shift

(c) Ctrl

(d) Tab

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

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

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)

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

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

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)

 

ANSWER KEYS:

1. Option- b
2. Option- d
3. Option- c
4. Option- b
5. Option- c
6. Option- b
7. Option- a
8. Option- a
9. Option- c
10. Option- c

 

 

 

 

 

 

 

 

1. State whether the following statements are True or False:

 

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

ANSWER KEYS:

1. False
2. True
3. False
4. True
5. True
6. False
7. True
8. False
9. False
10. True
11. False
12. False
13. True

 

 

 

 

 

 

 

1. Fill in the blanks:

 

1. A form can be used for ____________ and _____________.
2. Each field control consists of a ____________and________________
3. A ________________ is a piece of text that specifies the data that should be entered in the field value text box.
4. By default the border of the field text value is displayed in_________.
5. A ____________ is a small piece of text that is displayed when the mouse pointer is placed on a particular control on the form.
6. The default orientation option for a report is _______________.
7. A ____________ is the manner in which the labels, field values, titles etc. will be displayed in the report.
8. The option to insert date and time in the report is present in ___________ menu.
9. A Report Wizard contains _____________ steps.
10. A _______ type of report changes automatically as the field values in the base table or query change.

 

ANSWER KEYS:

1. Enter, view data
2. Label, field value
3. Label
4. 3D
5. Tool Tip
6. Landscape
7. Layout
8. Insert
9. Six
10. Dynamic

 

 

 

 

 

 

 

 

 

1. Answer the following questions:
2. Give one difference between a form and a report.
3. What is a field control with respect to forms?
4. Which tool on the Forms Record toolbar is used to insert text on the form?
5. Name the two ways to create a form in LibreOffice Base.
6. What is the difference between a static and a dynamic report?
7. Write the function of Forms Controls toolbar and Records toolbar.

 

ANSWER KEYS:

1. A form is an object of the database that has a userfriendly interface where data can be entered and seen inan attractive and easy-to-read format.

A report is another useful feature of a databasemanagement system. We have seen that the recordsthat have been extracted using a query are displayedin a simple row and column format.

2. A form contains field controls arrangedin a presentable and user friendly manner.Inaddition to field controls, it may contain some additionaltext like titles, headings and names, graphics like logos,list boxes and radio buttons.
3. Label Field
4. There are two ways to create a form:

• Using a wizard
• Using the Design View

5. Dynamic report means as the field values in the base table or query change,the report will also change automatically.

Static report means as the field values in the base table or query change, the report will not change automatically.

6. Forms control toolbar contains various tools to add or edit controls on the form.

The Records toolbar contains the navigation controlbuttons in the extreme left. With the help of thesebuttons, we can traverse and view the records inthe file.

 

 

 

 

 

 

 

 

 

CHAPTER-13: HEALTH, SAFETY AND SECURITY AT WORKPLACE

1. Multiple choice questions

 

1. Workplace safety is essential in organisation ____________.

(a) toavoide the accident and injury

(b) to increase the productivity

(b) to improve the work environment

(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

3. The security department is not responsible for __________.

(a) personal safety

(b) computer system and equipment safety

(c) electrical safety

(d) personal belongings

4. The proper security procedures will increase ____________.

(a) liabilities

(b) insurance

(c) business revenue

(d) operational charges of the company

5. Which kind of hazards can occur in IT industry?

(a) Biological

(b) Chemical

(c) Physical

(d) Ergonomic

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

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

 

 

8. What are the potential cause of hazards at workplace?

(a) Poor ventilation

(b) Poor lighting

(c) Poor housekeeping

(d) All of the above

 

ANSWER KEYS:

1. Option- d
2. Option- b
3. Option- d
4. Option- c
5. Option- d
6. Option- a
7. Option- c
8. Option- d

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1. Fill in the blanks:

 

1. Health of an employee is the state of the physical,_________________ and _________________ well being.
2. The work places must be cleaned in the _________________before the people start working.
3. A proper _________________ provide clean and cool air atthe workplace.
4. A fresh food cafeteria helps to maintain the ______________of the employee.
5. The work environment of the organisation must be_________________ and free from _________________ and_________________.
6. The proper security procedures will increase the____________ and will reduce the _______________ of the company.
7. Injuries and illness of the employees is prevented through national policy on ____________________.
8. Physical hazards occurs due to _______________.
9. Electrical hazards mostly caused due to coming in direct contact with _________________, or indirect contact through a _________________.
10. Hazards while using computers occurs due to_________________ or excessive duration of sitting in_________________.

 

ANSWER KEYS:

1. Mental, Social
2. Morning
3. Air Conditioning
4. Health
5. Safe, Hazard and Risk
6. Business revenue, operational charges
7. Occupational Health and safety
8. Physical work environment
9. Live wires, conductor
10. Poor sitting postures, one position

 

 

 

 

 

 

 

 

 

 

1. State whether the following statements are True or False:

 

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

 

ANSWER KEYS:

1. True
2. True
3. True
4. False
5. True
6. False
7. True
8. True
9. False
10. True

 

 

 

 

 

 

 

 

 

 

1. Short answer questions:
2. Briefly explain the concept of health, safety and security at workplace.
3. State the most important reasons for health, safety and security programs in workplace
4. List out the various workplace safety hazards.
5. List out the potential sources of hazards in an organization.
6. List some of the IT workplace hazards.
7. What are the examples of potential hazards?
8. Describe information technology workplace hazards.
9. What are the workplace safety rules?
10. List out different safety guidelines?

 

ANSWER KEYS:

1. Health- Health of an employee is the state of the physical,mental and social well being. Every organisation mustprovide healthy and safety working environment fortheir employees at the workplace.

Safety- The work environment of the organisation must be safe.It must be free from hazards and risk. A hazard is thesomething that can cause harm to the people.

Security- Every employee working in an organisation mustfeel that they are secured in the company campus.Security is a kind of freedom from any potential harm.

2. There are several reasons that can be specified for safetypolicy as given below.

• It clearly indicates the company’s commitment for their employee’s health and safety;
• It shows the performance of the business and the safety performance are compatible with each

Other.

• It clearly state that the company is not only doing the business for profits but it is taking care of all its stake holders.

3.Safety Hazard at workplace:

Physical, Electrical, Fire Hazard.

4. Potential sources of hazards in an organization:

Hazard using computers, handling office equipment, stress at work.

5. IT workplace hazard: Computer heating, battery bursting, mishandling of computer items.
6. Potential sources of hazards in an organization:

Hazard using computers, handling office equipment, stress at work.

7. IT workplace hazard: Computer heating, battery bursting, mishandling of computer items.
8. Safety rules:

• Provide adequate resources to ensure continualimprovement in its OH&S performance,
• Comply with relevant OH&S legal and otherrequirements applicable to the organisationanddrive for ‘beyond compliance’ leadership.
• Set appropriate OH&S objectives & targets andconduct periodic performance reviews againstthese targets.

 

9. Safety Guidelines Checklist
10. Store all cleaning chemicals in tightly closed containers in separate cupboards.
11. Throw garbage daily.
12. Make sure all areas have proper lighting.
13. Do not wear loose clothing or jewellery when working with machines.
14. Never distract the attention of people who areworking near a fire or with some machinery, tools

or equipment.

 

 

 

 

 

CHAPTER-14: WORKPLACE QUALITY MEASURES

 

1. 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

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

3. Repetitive use of muscle may feel pain in your ___________.

(a) neck

(b) shoulder

(c) wrist or fingers

(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

5. For an organisation, the proper security procedures will reduce ________________.

(a) liabilities

(b) insurance

(c) business revenue

(d) operational charges of the company

6. Do not wear ________ when working with machines.

(a) jewellery

(b) safety glasses

(c) masks

(d) gloves

7. Sore lower back is caused due to _________________.

(a) reaching forward frequently

(b) no lumbar support

(c) no upper back support from chair

(d) reaching forward for long periods

 

 

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

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

 

ANSWER KEYS:

1. Option- b
2. Option- d
3. Option- b
4. Option- c
5. Option- b
6. Option- c
7. Option- b
8. Option- a
9. Option- c

 

 

 

 

 

 

 

 

 

 

 

 

1. Fill in the blanks:

 

1. Air and water pollution can be analysed by using – physical, _________ and ____________ analysis.
2. The PH value of the water can be measured through_________ analysis.
3. The _________ indicators are used to monitor the health of the ecosystem.
4. Ergonomics is the science concerned with _________ and arranging things.
5. Working with wrists extended too much repetition can cause ___________.
6. The repetition of a seemingly _________ task over a period of time can cause an injury.
7. If a cord or wire will cross a pathway safety it should be mark it with ___________.
8. Loose cords and wires can cause _____________.
9. Glare and __________ on the screen should be prevented.
10. The keyboard should have a matt surface to avoid ____________ glare.

 

ANSWER KEYS:

1. biological
2. Chemical
3. Microbial
4. Designing
5. Arching wrists
6. Innocuous
7. Hazard tape
8. Electrical hazards
9. Reflections
10. Reflective

 

 

 

 

 

 

 

 

 

 

 

1. State whether the following statements are True or False:

 

1. The work environment of the organization must be free from hazards and risk.
2. Practice a no vehicle day in every week to avoid air pollution.
3. Applying ergonomics can improve performance and productivity.
4. Wear rings, watches and necklaces while working on the computer.
5. Never touch or try repairing any electrical equipment or circuits with wet hands.
6. Unplug all power sources and cables from computer while working on computer.
7. Occupational overuse syndrome, also known as repetition strain injury.
8. The work chair must be stable and allow the user to move easily.
9. Artificial lighting from computer screens can cause sleeping problems.
10. The keyboard and mouse should not be kept at the same level.

 

ANSWER KEYS:

1. True
2. True
3. False
4. True
5. True
6. False
7. True
8. True
9. True
10. False

 

 

 

 

 

 

 

 

 

 

 

1. Short answer type questions:
2. What causes the water pollution?
3. What is occupational overuse syndrome?
4. What are musculoskeletal problems?
5. What cautions to be taken while working on the computer?
6. Why there is no right way to use a laptop?
7. What causes eye strain and how to avoid it?
8. What type of display screen is suitable to work on computer?
9. What type of keyboard is suitable to work on computer?

ANSWER KEYS:

1. The main water pollutants include bacteria, viruses, parasites, fertilisers, pesticides, pharmaceutical products, nitrates, phosphates, plastics, faecal waste and even radioactive substances.
2. Occupational Overuse Syndrome, is a condition of the muscles in the wrist, forearm, arm and neck that is caused by their overuse (or misuse) at work.
3. Musculoskeletal disorders (MSDs) are injuries or pain in the human musculoskeletal system, which includes the joints, ligaments, muscles, nerves, tendons, and structures that support limbs, neck, and back.
4. It is important to rest the eyes while working on the computer. Regularly look at more distant objects, e.g. use thinking time to look out of the window, and take frequent breaks from computer work. Visit the optician for regular eye check-ups and make sure you tell them if you are a frequent computer user.
5. Using a laptop is a tradeoff between poor neck/head posture and poor hand/wrist posture. Occasional users will have less risk of problems than full-time users. Because the neck/head position is determined by the actions of large muscles, you are better off sacrificing neck posture rather than wrist posture.
6. Eye strain is a common condition caused by intense use of your eyes, such as by reading, using digital devices or driving long distances. Other names for eye strain are eye fatigue and asthenopia. Eye strain can cause discomfort, but it’s usually not a serious condition.
7. The best display type for a monitor largely depends on your needs, but IPS (In-Plane Switching) panels are generally the top choice for work. IPS displays offer superior color accuracy and consistency, wide viewing angles, and better overall image quality compared to TN (Twisted Nematic) panels.
8. The QWERTY keyboard layout is comfortable, familiar and time-tested, ideal for everyday typing needs.

 

 

 

 

 

CHAPTER-15: PREVENT ACCIDENTS AND EMERGENCIES

1. 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

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

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

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

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

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

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

 

 

 

8. What is the primary fire emergency telephone number is?

(a) 011

(b) 101

(c) 108

(d) 111

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)

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)

 

ANSWER KEYS:

1. Option- d
2. Option- d
3. Option- b
4. Option- d
5. Option- a
6. Option- c
7. Option- c
8. Option- b
9. Option- d
10. Option- d

 

 

 

 

 

 

 

 

1. Fill in the blanks:

 

1. Emergency is a serious or crisis situation that needs__________attention and ________.
2. A ___________ sign will warn people to walk carefully on freshly mopped floors.
3. ____________ signs can prevent accidents on a staircase with a sharp bent or warn against a loose floor tile.
4. The ___________ should be responsible to handle evacuation process.
5. Workplace fires are commonly caused by improper storage of ______________ material or _________ dust.
6. There should always be an _________________ plan for scheduled electrical maintenance or work.
7. If the victim is breathing and has a heartbeat, give ________ for injuries and treat for shock.
8. A fire extinguisher is a _________________ containing an agent which can be discharged to extinguish a fire.

 

ANSWER KEYS:

1. Immediate, action
2. Wet floor
3. Watch your steps
4. Coordinator
5. Flammable, combustible
6. Emergency response
7. First aid
8. Cylindrical pressure vessel

 

 

 

 

 

 

 

 

 

 

 

 

 

1. State whether the following statements are True or False:

 

1. The organization’s policies and guidelines is the best guide to handle emergency.
2. If someone is injured, act as per your impulse or gut feeling.
3. Keep water and food items away from electrical equipment.
4. Always switch off the electrical circuits.
5. Always wear protective equipment, such as gloves and shoes.
6. A fire extinguisher is a protection device used to extinguish fires.
7. Flammable materials can be placed around an door exit.
8. You can determine possible evacuation routes from floor plan diagrams posted in your facility.

 

ANSWER KEYS:

1. True
2. False
3. True
4. False
5. False
6. True
7. False
8. True

 

 

 

 

 

 

 

 

 

 

 

 

 

1. Short answer questions:
2. What is a workplace emergency?
3. How do you protect yourself, your employees, and your business?
4. What is an emergency action plan?
5. What should your emergency action plan include?
6. How do you develop an evacuation policy and procedures?
7. How do you establish evacuation routes and exits?
8. What are the various types of fire extinguisher and their extinguishing material?
9. What are the steps for operating a fire extinguisher in case of a fire emergency?
10. Compare the different type of fire extinguisher.
11. List the different class of fire.
12. List out electrical rescue techniques.
13. What is the first aid for electrical emergencies?

ANSWER KEYS:

1. Workplace Emergency is a serious orcrisis situation that needs immediate attention andaction. For example, a customer having a heart attackor sudden outbreak of fire in your organisation needsimmediate attention.
2. Limit access to sensitive company data to only those with a need to know. Make sure your employees utilize and take their allotted vacation/PTO time each year. Not only is it healthy for your employee, but it will likely expose any fraudulent activities should they exist in your business.
3. An Emergency Action Plan (EAP) is a written document that outlines how to respond to various types of emergencies. It’s a key part of an organization’s safety procedures and can help reduce injuries, property damage, and ensure visitor safety.
4. An emergency action plan should include details on how to respond to a major incident, such as an active shooter, fire, or natural disaster. It should outline how employees should behave, where to report emergencies, and how to evacuate safely. The plan should also include information on safety areas, security and law enforcement, local hospitals, and how to notify others.
5. Steps you can take to develop an evacuation policy and procedures:
6. Evaluate the emergency: Consider how fires break out and their leading causes.
7. Determine exit routes: Mark clear exit routes that are free of furniture and other objects.
8. Identify safe areas: Choose an assembly point outside the building where people can gather after evacuating. Make sure the area is clearly marked with signage.
9. Develop evacuation procedures: Include things like closing doors behind you to contain smoke or fire, and staying low to the ground if there’s smoke.

 

 

 

6. Exit routes should be:
7. Clearly marked and well lit.
8. Wide enough to accommodate the number of evacuating personnel.
9. Unobstructed and clear of debris at all times.
10. Unlikely to expose evacuating personnel to additional hazards.
11. There are many types of fire extinguishers, including water, foam, dry powder, carbon dioxide (CO2), and wet chemical.
12. The steps for operating a fire extinguisher are easy to remember with the acronym PASS, which stands for Pull, Aim, Squeeze, and Sweep.
13. AFFF (aqueous film-forming foam) and FFFP (film-forming fluoroprotein) fire extinguishers are rated for use on both Class A and Class B fires. As the name implies, they discharge a foam material rather than a liquid or powder. They are not suitable for use in freezing temperatures.
14. Classes of Fire: Class-A, Class-B, Class-K, Flammable gases, CO2 fire extinguisher, electrical fire.
15. Electrical rescue techniques- Turn-off power, remove the person and call emergency services.
16. First aid for electrical emergencies can include- Turning off the power, checking the sign of life, covering burns, keeping the victim warm and providing emotional support.