SECTION A: OBIECTIVE TYPE QUESTIONS
Q.1 Answer any 4 out of the given 6 questions on Employability Skills (1x 4 =4marks) 1
i. operating system enables multiple users to work on the same
computer at different times or simultaneously.
a. multiprogramming.
b. multiprocessors.
c. multi-user.
d. multi-tasking.
1
ii. is a series of postures and breathing exercises practiced to achieve
control of body and mind.
a. Meditation b. Nature Walk c. Yoga d. Physical Exercise
iii. From the following statements, which one is not correct about the Qualities of an
entrepreneur
Successful entrepreneurs adapt the habit of hard work from a very
early stage.
a.
should not think optimistically about the future of the business.
b. Entrepreneur
too early in case
c. Confident entrepreneur must not deviate from his/her decisions
success is delayed.
d. Entrepreneurs like to function at their own will and rules.
1
iv. To remove the files of temporary folder, we type
in Run dialog box
after pressing "Windows button + R" on the keyboard.
a. #temp# b. %temp% C. e Stemp% d. &temp&
V. is not the quality of self-confident people.
c. Positive Attitude
a. Dependent
b. Hard Working d. Commitment
1
vi. Fromthe following statements, which one is not the positiveimpact
of Entrepreneurship on society:
a. Stimulates Innovation and Efficiency
b.Creates Jobs and Employment Opportunities
c.Solves the problems of the society
d. Discourages welfare ofthe society
Q.2 Answerany 5 out of the given 6 questions (1 x5=5 marks)
key is used to reduce repetitive strain.
1
a. Sticky b. Serial c. Mouse Toggle
d.
means that the query uses criteria you provide to hide some data and
display only required data.
a. Filtering
c. Report
b. Sorting
d. Forms
Page 3of 7
iii.
Which ofthe following application is not appropriate to store data about ABC Bank 1
customers?
a. Open Office Base c. Open Office Writer
b. MS Access d. MS Excel
iv. When you open a new spreadsheet, by default, has a sheet named it which 1
ismanaged using tabs at the bottom of the spreadsheet.
a. Sheetl c. Worksheetl
b.Untitledl d. New Sheet
V. In a word processor, selected for a scaled resizing of an 1
option is
image.
a. Original Size c. Image Size
b. Keep ratio d. Relative
vi. Multiple copies of the same file leads to
a. Data Inconsistency c. Data Redundancy
b. Data Consistency d. Foreign Key
Q.3 Answer any 5 out of the given 6 questions (1 x 5=5 marks)
1
It is areference point for the graphics which is created while positioning any image.
This point could be the page, or frame where the object is either a paragraph, or
even a character in a word processor.
Wrap Text
a. c. Anchoring
Alignment
b. d. BookMark
ii.
Identify the property which help to set the number of characters in text/ varchar type 1
field of a table in DBMS.
a. Entry Required c. Size
b. Default Value d. Length
iii. 1
is designed to help users with auditory impairments.
a. Sound Sentry c. Serial key
b. High Contrast d. Show Sounds
iv. State whether True or False: 1
"It isnot possible to create a default template in a Word processor".
a. True b. False
V. Reviewers and authors canadd their 1
to explain their changes in the cell of
Spreadsheet.
a. Comments c. Worksheet
b.Hyperlink d. Macros
vi.
In Calc, Arguments passed to a macro from Calc are always 1
a. Cell Reference
c. Both a and b
b. Value
d. Sheet Reference
Page 4 of 7
Q.4 Answer any 5 out of the given 6 questions (1x5=5 marks)
i.
Identify the website that offers offline blog service for free.
c. WordPress d. both a and b
a. Blogdesk b. Qumana 1
wanted to make the index
He
ii. John has written a book consisting of fifteen chapters.
create the index automatically in a word
of the book. Suggesthim the option used to
processor.
c. Columns
a. Tables
d. Table of Content
b. Mail Merge by default in
1
oftext data type is characters
iii. The length of the field value
DBMS.
20 d. 50
a. 10 b. 25 c. 1
people's health and well-being. It
keep and improve
iv. A healthy lifestyle helps to
does not include:
c. physical activities
a. healthy eating habits d. less sleep 1
b. stress management FTP or Telnet, click on the
to a web
V. using to create a hyperlink
In a spreadsheet box.
dialog
icon available in Hyperlink
c. Internet
a. browser d. mail & news
and can be used to
b. hyperlink
toa cell or arange ofcells on a worksheet
vi. A refers
to calculate.
or data that you want formula
find the values
c. Sheet Reference
a. Cell reference
d. Autofill
b. Block
(1 x5=5 marks)
Answer any 5out
of thegiven 6
questions
Q.5 the structure of table?
where we can modify in
i. Identify the mode,
c. Design view
a. Datasheet view
d. All of the above
b. Structure view
ii. BSNL stands for
a. SancharNigam Limited
Bihar
b. Bharat Samachar
Nigam Limited
c. Bharat SancharNigam Limited
1
d. None of the above or workbooks and
from a series ofworksheets
ii. function takes data
that you can update easily.
summariesit into a single worksheet
c. Data Consolidation
a.Data Combination
d. Data Concatenation
b. Data Merging to store less amount of
table which is suitable
iv. store data in a single
Data.
Mini File d. Single File
b. Relational c.
a. Flat File
Page 5of 7
V. In a word processor, by default, evaluates levels of headings when it
builds the table ofcontents.
a. 3 c. 10
b. 7 d. 12
In
vi. Networks, all computers have an equal status andeach 1
terminal has an equally competent CPU.
a. MAN b. WAN c. Client Server d. P2P
SECTION SUBJECTIVE TYPE QUESTIONS
B:
Answer any 3 out of the given 5questions on Employability Skills (2x3 =6 marks)
Answer each question in 20 30 words. -
Q.6 What are the advantages of the ability to Work lIndependently?
Q.7 Name the Stress causal agents.
Q.8 What do you mean by Disk Defragmentation? 2
Q.9 Explain anytwo Myths about Entrepreneurship. 2
Q. 10 Write any fourroles of Entrepreneurs. 2
Answer any 4 out ofthegiven 6 questions in 20-30 words each (2 x4=8 marks)
2
Q. 11 State any two purposes of using Templates in a word document.
Q. 12 Mention anytwo operations that can be performed using Macros in a spreadsheet.
Spreadsheets? Give the two different types of
2
Q. 13 What do you mean by Hyperlinks in
Hyperlinks that can be used in Spreadsheets.
Q. 14 List Numeric and Alphanumeric Datatypes in OpenOffice Base.
Windows.
2
Q. 15 Differentiate betweenFilter keys and Toggle keys in Microsoft
2
Q. 16 In which situations Online shopping could be useful? Write any two popular e
commerce websites.
Answer any 3 out of the given 5questions 50- 80 words each (4 x 3
in =12 marks)
4
notes for her Term Exam. Help her to write short note
Q. 17 Anshita is preparing spreadsheet
on the following:
i. Scenarios
ii. Goal Seek
iii. Solver
iv. Subtotal
4
Word Processor
ClassX student. He has learnt Mail Merge
option of a
Q. 18 Tanmay is a
with few terms used to merge documents.
in his computer period.
But he is confused
Tanmay better understand the Mail
Explain the following briefly,which
will help
Merge options.
1. Merge Field
2. Data Source
3. Main Document
4. Mention two types of data on which mail merge can be applied.
Page 6 of 7
Q. 19 Considerthe following table: Sales
Sale Id Prod Name Price Discount
1101 65000 2500
Laptop
1103 Pen tab 29500 1000
1105 Desktop 50000 1550
1106 Printer 12000 2000
and records are there in Sales table?
1. How many fields
2. Write SQL commands for the following:
and price of products whose discount is more than
i. Display Sales ID all
1000.
ii. Display the details alphabetically
by product name.
after deducting the discount from the
iii. Display product name and sales price
price.
as (price-discount)
Note: Sales price can be calculated
their
keep records of the medicines with
Q. 20 Your friend ownsa chemist shop, he needs to
But he does not
price, etc. in a database program.
id's, date of purchase, expiry date, a better
the following to get
have any knowledge about the database. Explain to him
understanding of the DBMS concepts.
1. What is DBMS? Explain in brief.
used create a table and store
any two database programs which can be
to
2. Name
the data as per the requirement.
3. Which field can be set as a Primary Key?
Is possible to make more than one field as a primary key in your table?
4. it
(Yes/No). Justify your answer.
student of class X. He used to get the work based on internet surfing, But
Q.21 Vicky is a
a friend of Vicky, help him
he is not aware of the internet and its terminology. Being
in finding the answers of the following questions.
a. What doyou mean by Internet Service Provider?
b. Expand the following terms:
WAP
ii. W3
c. Mention any two advantages of Networking.
d. What is a Blog? Name any two Online Blogs.
For Visually Impaired Students
4
Q.21 Define the following:
1. Sorting (with respect to DBMS)
2. Referential Integrity
3. Many-to-Many Relationship(with respect to DBMS)
4. Foreign key
