Q1
mcq
1 mark
The school is organizing a Career Counselling Workshop. Which of the following will be the most effective method of communication to inform all students of the school?
- A. Face-to-face informal communication
- B. Notice/Poster
- C. Phone call
- D. Meet everyone in person
Solution hidden
Log in to view solution →
Q2
mcq
1 mark
Which of the following is the most suitable term for the ability to regulate one’s own emotions and help others also to do the same ?
- A. Managing emotions
- B. Harnessing emotions
- C. Knowing emotions
- D. Supressing emotions
Solution hidden
Log in to view solution →
Q3
mcq
1 mark
Roshin studies in class X and is practising hard with a lot of sample papers to get good marks in her exams. She gets up early in the morning to study and completes her revision work. This is an example of ___________ .
- A. Self-awareness
- B. Self-motivation
- C. Influential motivation
- D. Emotional intelligence
Solution hidden
Log in to view solution →
Q4
mcq
1 mark
A _____________ is a location where a group of files can be stored in the computer.
- A. Folder
- B. SMPS
- C. CMOS
- D. UPS
Solution hidden
Log in to view solution →
Q5
mcq
1 mark
Which of the following is a myth about entrepreneurs ?
- A. An entrepreneur should be confident and should be able to take decisions.
- B. Every business idea must be unique or special.
- C. An entrepreneur should keep trying new ideas.
- D. An entrepreneur should be creative and should have different solutions to the problem.
Solution hidden
Log in to view solution →
Q6
mcq
1 mark
Which one of the following is the most important factor for sustainable development and helps us become aware of our role as a responsible citizen ?
- A. Sports
- B. Education
- C. Business
- D. Illiteracy
Solution hidden
Log in to view solution →
Q6
short answer
2 marks
Briefly explain the meaning of any 2 C’s out of the 7 C’s of effective communication.
Solution hidden
Log in to view solution →
Q7
mcq
1 mark
Ravi has to prepare a project report. He wants to save certain formatting features and then apply them on the project report. He can use the _____________ feature of OpenOffice Writer.
- A. Styles
- B. Image
- C. Mail Merge
- D. Preview
Solution hidden
Log in to view solution →
Q8
mcq
1 mark
During a recent excursion, Roshni has taken some pictures for making a report in Writer. She wants to increase the contrast of the images. Which one of the following image filters should she use in Writer ?
- A. Aging
- B. Mosaic
- C. Sharpen
- D. Smooth
Solution hidden
Log in to view solution →
Q8
short answer
2 marks
Give any four tips to keep the computer in perfect working condition.
Solution hidden
Log in to view solution →
Q9
mcq
1 mark
Which one of the following image arrangement options in Writer sends the drawing object behind the text ?
- A. To background
- B. To foreground
- C. Behind the text
- D. Back one
Solution hidden
Log in to view solution →
Q9
short answer
2 marks
Mention any four main functions of an entrepreneur.
Solution hidden
Log in to view solution →
Q10
mcq
1 mark
__________ feature of Writer is based on different types of heading styles and is used to give the listing of the contents of the document.
- A. Table of Heading
- B. Index
- C. Label of Contents
- D. Table of Contents
Solution hidden
Log in to view solution →
Q10
short answer
2 marks
Explain any two problems related to sustainable development.
Solution hidden
Log in to view solution →
Q11
mcq
1 mark
__________ is the default template for the files being created in Writer.
- A. Resume template
- B. Project Report
- C. Blank document
- D. Chapter
Solution hidden
Log in to view solution →
Q11
short answer
2 marks
Out of various style categories provided by Writer, briefly explain Frame style category in brief.
Solution hidden
Log in to view solution →
Q12
mcq
1 mark
Shanta is creating a project report in Writer and wants to apply the same style on headings / titles in the entire document as she has done at the beginning of the document. She can use the __________ feature of Writer to apply the same format on each line / word, wherever needed.
- A. Fill Style
- B. Fill Format
- C. Apply Feature
- D. Apply Character
Solution hidden
Log in to view solution →
Q12
short answer
2 marks
What is a Macro ? Give any two rules that should be followed while naming a Macro or module in Calc.
Solution hidden
Log in to view solution →
Q13
mcq
1 mark
To add your own comments in Calc, select __________ → Track changes → Comment.
- A. File
- B. Edit
- C. Insert
- D. Data
Solution hidden
Log in to view solution →
Q13
short answer
2 marks
What is the main purpose of Goal Seek in Calc ? Give an example to support your answer.
Solution hidden
Log in to view solution →
Q14
mcq
1 mark
To add a new sheet in the spreadsheet, click on the __________ sign located at the left bottom of the spreadsheet.
- A. *
- B. /
- C. %
- D. +
Solution hidden
Log in to view solution →
Q14
short answer
2 marks
What are the important prerequisites for setting a relationship between two tables in LibreOffice Base ? Mention any two.
Solution hidden
Log in to view solution →
Q15
mcq
1 mark
__________ is a set of values that can be used within the calculations in the spreadsheet to explore and compare various alternatives depending on changing conditions.
- A. Sort
- B. Filter
- C. What-if Scenarios
- D. Comments
Solution hidden
Log in to view solution →
Q15
short answer
2 marks
For a computer workplace, give any two health and safety requirements while using a keyboard.
Solution hidden
Log in to view solution →
Q16
mcq
1 mark
The recorded macros are actually stored as __________.
- A. a set of instructions in a programming language.
- B. a sequence of data cells
- C. a document
- D. a list of values
Solution hidden
Log in to view solution →
Q16
short answer
2 marks
Excessive use of computers might have a bad impact on your vision. Give any two eye-related problems.
Solution hidden
Log in to view solution →
Q16
short answer
2 marks
Excessive use of computers might have a bad impact on your vision. Give any two eye-related problems that might arise due to long hours spent on a computer.
Solution hidden
Log in to view solution →
Q17
mcq
1 mark
Which creating a hyperlink in calc, if the complete path along with filename is given then it is an example of _________.
- A. Relative hyperlink
- B. Mixed hyperlink
- C. Absolute hyperlink
- D. Folder hyperlink
Solution hidden
Log in to view solution →
Q18
mcq
1 mark
This tool in Calc allows you to create a group of cells automatically and apply common functions like sum, average on the grouped data. It is known as __________ tool.
- A. Sum
- B. Subtotal
- C. Function
- D. Common
Solution hidden
Log in to view solution →
Q19
mcq
1 mark
__________ is the database software that is used to create, manipulate and manage data.
- A. Ingress
- B. Writer
- C. Paint
- D. Windows
Solution hidden
Log in to view solution →
Q20
mcq
1 mark
The process of arranging data in ascending or descending order is known as __________ .
- A. Filtering
- B. Tracking
- C. Purification
- D. Sorting
Solution hidden
Log in to view solution →
Q21
mcq
1 mark
With reference to LibreOffice Base, which of the following is a valid data type to indicate the monetary values ?
- A. Money
- B. Currency
- C. Rupee
- D. Dollar
Solution hidden
Log in to view solution →
Q22
mcq
1 mark
Data can be retrieved and displayed from one or more tables in a DBMS using a __________ .
- A. Referential integrity
- B. Domain
- C. Query
- D. Field
Solution hidden
Log in to view solution →
Q23
mcq
1 mark
While designing a form, it is suggested to get the date input by adding the __________ to the date field to prevent entering invalid dates.
- A. Calendar
- B. Text input
- C. Timer
- D. Number input
Solution hidden
Log in to view solution →
Q24
mcq
1 mark
While designing a form, titles, headings or sub-headings may be added using __________ tool available on the Form Controls tool box.
- A. Textbox
- B. Label
- C. Title
- D. Heading
Solution hidden
Log in to view solution →
Q25
mcq
1 mark
__________ is a state of physical, mental and social well-being.
- A. Richness
- B. Popularity
- C. Health
- D. Activity
Solution hidden
Log in to view solution →
Q26
mcq
1 mark
Which one of the following is a class B ignition material?
- A. Paper
- B. Gas
- C. Electrical equipment
- D. Potassium
Solution hidden
Log in to view solution →
Q27
mcq
1 mark
The __________ has prepared the policy to provide employees with a healthy and safe work environment.
- A. GoIT
- B. DoIT
- C. ToIT
- D. SoIT
Solution hidden
Log in to view solution →
Q28
mcq
1 mark
RSI stands for:
- A. Recurring Syndrome Injury
- B. Repetition Symptom Injury
- C. Recessive Stress Injury
- D. Repetitive Strain Injury
Solution hidden
Log in to view solution →
Q29
mcq
1 mark
__________ is the science that deals with designing and arranging the things at workplace so that people can use them easily and safely.
- A. Health science
- B. Ergonomics
- C. Fixture science
- D. Work Economics
Solution hidden
Log in to view solution →
Q30
mcq
1 mark
Which one of the following is a wrong safety guideline?
- A. Store all cleaning chemicals in tightly closed containers in separate cupboards.
- B. Never distract the attention of people who are working near a fire or with some machinery, tools or equipment.
- C. Wear loose clothing or jewellery while working with machines.
- D. Make sure all areas have proper lighting.
Solution hidden
Log in to view solution →
Q43
long answer
4 marks
(a) What is the benefit of grouping drawing objects in Writer ?
Solution hidden
Log in to view solution →
Q44
long answer
4 marks
(b) Differentiate between text wrapping and image alignment feature in Writer.
Solution hidden
Log in to view solution →Reading Passage
Mr. Amit, Sales Manager of ABC Sales Corporation has created a spreadsheet in LibreOffice Calc that lists Sales for different years in different regions in different worksheets. He wants to summarize and make certain decisions based on it. Help him by answering the following questions :
Q45
long answer
4 marks
(a) Which tool in Calc can be used to combine the sales data from multiple sheets into a single summary sheet ?
Solution hidden
Log in to view solution →
Q46
long answer
4 marks
(b) Name the Menu Option and Sub-Menu Option that can be used to generate combined summary of all the worksheets.
Solution hidden
Log in to view solution →
Q47
long answer
4 marks
(c) Name the function that can be used to display total of all sales.
Solution hidden
Log in to view solution →
Q48
long answer
4 marks
(d) He wants to open a summary document stored at a different location from within the sheet by clicking on a text stored in a cell. How can it be done ?
Solution hidden
Log in to view solution →Reading Passage
Imagine that you have been signed a contract of handling fire safety and emergency in a company. You need to spread awareness on fire safety and emergency handling to the employees. Answer the following questions :
Q49
long answer
4 marks
(a) Give any two fire prevention measures at the workplace.
Solution hidden
Log in to view solution →
Q50
long answer
4 marks
(b) Give any two basic emergency handling procedures at the workplace.
Solution hidden
Log in to view solution →
Q51
long answer
4 marks
(a) Give any two advantages of relating two tables in a database.
Solution hidden
Log in to view solution →
Q52
long answer
4 marks
(b) Explain many-to-many relationship between the tables in a database.
Solution hidden
Log in to view solution →
Q53
short answer
Imagine that you have been signed a contract of handling fire safety and emergency in a company. You need to spread awareness on fire safety and emergency handling to the employees. Give any two fire prevention measures at the workplace.
Solution hidden
Log in to view solution →Reading Passage
Table : Student Student_ID Name Age Phone_Number S001 Amit 15 9876543210 S002 Priya 16 8765432109 S003 Priya 15 7654321098
Q54
short answer
Consider the following table : Student_ID, Name, Age, Phone_Number. You are given the task to design the student database for your school in LibreOffice Base. Based on the given table structure, suggest the datatype of student_id and age field that would be suitable to store student’s-id and age respectively.
Solution hidden
Log in to view solution →
Q55
short answer
As a database administrator, you need to ensure each student has a unique identifier. Which field in the table would you choose as the primary key and why ?
Solution hidden
Log in to view solution →
Q56
short answer
Identify the field that can serve as an alternate key. Justify your answer.
Solution hidden
Log in to view solution →
Q57
short answer
How many attributes and records are present in the above shown table ?
Solution hidden
Log in to view solution →