ARMY PUBLIC SCHOOL RANIKHET

MOCK TEST-I, CLASS-X-C (2024-25)

SUB-I.T(402)

Time: 2 Hours M.M: 50

SECTION A: OBJECTIVE TYPE QUESTIONS

Q. 1 Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 = 4 marks)

i. Which of the following is not a form of written communication? 1

a. Circulars c.Discussion
b. Reports d.SMS
ii.

iii.

iv.

v.

vi. Which of the following sentences is in passive voice? 1

a. By whom was the mess cleaned?

b. Uncle Rakesh teaches my brother.
c. The birds were being fed by my sister.
d. Both a & c.
Q. 2 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. Which one is not the tab of the insert/index Table window of Writer Document? 1

a. Entries b. Background c. Style d. Row

ii. Solver and Goal Seek commands are located in__________menu. 1

a. View c. Insert
b. Sheet d. Tools
iii. With every new change in headings of a document ………………. should be done 1
immediately.

(a) Create a new TOC (b) Update TOC (c) Delete old TOC (d) None of these

iv. ………………. represents data in formatted way. 1

(a) Forms (b) Queries (c) Wizards (d) Reports

v. Anubhav has written a SQL query in SQL view. But he doesn’t know how to execute the 1
query using keyboard keys. Suggest him the shortcut key to complete the task.

a. Enter b. Space bar c. Crtl+E d. F5

vi. A(n)_____is an unexpected event with negative consequences occurring without the 1
intention.
a. Accident b. Emergency c. Fall d. Hazard
Q. 3 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. You can use___________feature for editing and formatting changes. 1

a. Macro b. Sorting c. Track changes d. Comment

ii. What is one way to mitigate hazards associated with prolonged computer use? 1

(a) Increasing screen brightness (b) Stretching at regular intervals or doing simple yoga
(c) Using a smaller screen (d) Sitting in a fixed position
iii. To delete a particular column in a relation ,the command will use. 1

a. Update b. Delete c. Drop d. Alter

iv. If you see #### in place of data in a cell, it means you need to_______the cell width. 1

a. Increase c. Both a & b

b. Decrease d. None of these
v. The default numbers of levels of headings in a Writer TOC is__________ 1

a. 2 b. 3 c. 4 d.10

vi. ______________ is a text editor that allows you to create and edit macros. 1

(a) IDE (b) Notepad (c) Open Office Writer (d) MS Word

Q.4 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)

i. Mihen is an alert girl and enthusiastically participates in various workshops conducted in 1
the school. Recently she attended a workshop about what to do in emergency situations.
What could she have learnt there?

a. One should keep quiet in emergencies.

b. One should keep first aid ready.
c. One should call the police.
d. One should be alert and they should know how the alarm is to be raised; contact
emergency services while reaching to a place of safety.

ii. In a document,_____is used to apply a style to many different area quickly without 1
having to go back to the style and Formatting window and double click every time.

a. Painter mode b. Text wrapping c. Formatting window d. Fill format mode

iii. What does referential integrity in a database ensure? 1

(a) All primary keys are unique across the database.

(b) All records in a table must have a value in every column.
(c) Every foreign key value must match a primary key in the referenced table or be null.
(d) Data can be freely deleted from any table without constraints.

iv. A ______________ hyperlink stores the location with respect to the current location in 1
LibreOffice Calc.

(a) Absolute (b) Relative (c) Mixed (d) Reference

v. __________represents the end of a hyperlink under the Entries tab of table of content, 1
Index or Bibliography box.

(a) T (b) E# (c) LE (d) LS

vi. _________are descriptions about the changes made in cells during record changes 1
mode.

a. Tips b. Messages c.Comments d. None of these

Q. 5 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. How much space does the DATE/TIME data type hold in Base? 1

a. 2 Bytes b. 8 Bytes c.4 Bytes d. 10 Bytes

ii. Which of the following statements are true about primary key in a database? 1

(a) It is a field that can have duplicate values.

(b) It uniquely identifies each record in a table. (c) It can have null values
(d) It is an optional field in a database table.
iii. Which tab is used to create Table of Content in a writer documents? 1

a .File Tab b. Format Tab c. Insert Tab d. Style Tab

iv. A____________________is a collection of tables. 1

a. Fields b. Data c. Records d. Database

v. In a situation where a small fire breaks out in the office, what should you use to address 1
the emergency?

(a) A Blanket (b) A Fire Extinguisher (c) A Towel (d) Baking Soda

vi. The _____________shortcut key is used to open a hyperlink dialog box. 1

(a) Ctrl+H (b) Ctrl+K (c) Ctrl+K (d) Ctrl+O

SECTION B: SUBJECTIVE TYPE QUESTIONS

Answer any 3 out of the given 5 questions on Employability Skills (2 x 3 = 6 marks)

Answer each question in 20 – 30 words.

Q. 6 Why do we say that an entrepreneur should be open-minded? 2

Q. 7 What is operating system? Explain CLI and GUI 2

Q. 8 Riya, a Class X student, feels stressed with her exam preparation, extracurricular 2
activities, and family commitments. How can tracking time help her?

Q. 9 Explain the Parts of speech. 2

Q. 10 Why is communication important? What are its types? How can you deal with it? 2

Answer any 4 out of the given 6 questions in 20 – 30 words each (2 x 4 = 8 marks)

Q. 11 What are the difference between Wrap Off and Page Wrap in writer? 2

Q. 12 Differentiate between Where clause and Order By clause of SQL statements. 2

Q. 13 What is meant by referencing sheets in Calc? 2

Q. 14 What are common causes of slips, trips and falls in office? 2

Q. 15 Explain the following terms- 2

a. Sorting b. Filtering
b.
Q. 16 What is SQL? What are the different categories of commands available in SQL? 2
Answer any 3 out of the given 5 questions in 50– 80 words each (4 x 3 = 12 marks)

Q. 17 Your cousin runs a small bookstore and wants to maintain an inventory of books. He 4
needs to record information such as book titles, authors, ISBNs, publication dates,
prices, and stock levels. However, he is not familiar with database management
systems. Explain the following concepts to help him understand DBMS:

a) What is DBMS?
b) What are the advantages of using DBMS?
c) Name any two database programs that can be used to create a table and store the
data according to his requirements.
d) Which field can be set as a Primary Key?

Q. 18 Anu is a student of class X. She has scored very low marks in her I.T exam ,so 4
she requested her teacher to show the paper. She had a mistake in the following
questions. Being a friend of Anu, explain her the following questions.

1.What is the need for macros?

2. Differentiate between Consolidate and Data validation rules.
3. What is wrap text around images?
4. Write steps to create a TOC in writer.

Q. 19 Write steps to create or apply subtotals and Scenarios in a worksheet. 4

Q. 20 Explain the following style categories of Writer. 4

a. Paragraph styles
b. Frame style
c. Character style
d. Table styles

Q. 21 What is the first aid procedure for these? 4

i. Burns
ii. Fractures
iii. Bleeding
iv. Choking
4