BLOSSOMPUBLICSCHOOL

SAMPLEPAPER- 4

Section A
Objective Type Questions

Question 1.
Answer any 4 out of the given 6 questions based on Employability Skills. (4 × 1 = 4)
(i) Which one of the following is not a symptom of stress? (1)
(a) Increased sweating
(b) Dry mouth
(c) Cold hands or feet
(d) None of the above
Answer:
(d) None of the above

(ii) Which term refers to our knowledge and understanding of ourselves? (1)
(a) Self-awareness
(b) Motivation
(c) Both (a) and (b)
(d) None of these
Answer:
(a) Self-awareness

(iii) Which of the following is an example of effective written communication? (1)

(a) Using excessive jargon and technical terms
(b) Writing lengthy paragraphs without any breaks or bullet points
(c) Using concise and clear language
(d) Including personal opinions and biases
Answer:
(c) Using concise and clear language

(iv) __________ provides process and memory management services that allow two or
more tasks, jobs or programs to run simultaneously. (1)
(a) Multi-tasking
(b) Multi-threading
(c) Multi-processing
(d) Multi-computing
Answer:
(a) Multi-tasking

(v) Which of the following is an example of a green skill? (1)

(a) Traditional farming techniques
(b) Renewable energy installation and maintenance
(c) Conventional manufacturing processes
(d) Non-recyclable waste disposal methods
Answer:
(b) Renewable energy installation and maintenance

(vi) In which situation an entrepreneur will not be able to convince his fellow beings to
achieve his goals? (1)
(a) Low self-confidence
(b) Innovativeness
(c) Risk-taking
(d) None of the above
Answer:
(a) Low self-confidence

Question 2.
Answer any 5 out of the given 6 questions. (5 × 1 = 5)
(i) A __________ is a temporary connection that uses the Public Switched Telephone
Network (PSTN) to connect to the Internet. (1)
(a) broadband connection
(b) wireless connection
(c) dial-up connection
(d) None of the above
Answer:
(c) dial-up connection

(ii) The small area network created around a Bluetooth device is called __________ (1)
(a) LAN
(b) PAN
(c) WAN
(d) MAN
Answer:
(b) PAN

(iii) The __________ SQL statement is used to make a query or retrieve data from a table
in a database. (1)
(a) INSERT
(b) UPDATE
(c) SELECT
(d) REVIEW
Answer:
(c) SELECT
(iv) Which of the following allows you to reorder data? (1)
(a) Sorting
(b) Filtering
(c) Scenario
(d) Custom sorting
Answer:
(a) Sorting

(v) Which of the following is not an AutoShape? (1)

(a) Line
(b) Circle
(c) Curve
(d) ClipArt
Answer:
(d) ClipArt

(vi) Neeta is planning to take a car loan to buy a new car. But she is not sure about the
payback time, i.e. whether to pay it back in 5 or 6 years considering that her monthly
fuel cost will also increase. In such cases, which of the following features of the
spreadsheet can she use to get an idea about it? (1)
(a) Consolidation
(b) Macros
(c) Templates
(d) What-if analysis
Answer:
(d) What-if analysis

Question 3.
Answer any 5 out of the given 6 questions
(A)_______is specifically designed to minimize the results according to a set of rules
that we define in a spreadsheet. [1]
(a) Goal Seek
(b) Scenario
(c) Solver
(d) Subtotal
Answer:
(c) Solver

Explanation:
In CaLc, the Solver is an optimization tool that allows users to find the optimal solution
to a complex problem by adjusting the values of specific cells based on given rules. It is
particularly useful for problems involving maximizing or minimizing a target value
depending on certain restrictions or conditions.

(B) Sahil and his partners have created a list of their company employees in one of the
spreadsheets in the office. Now the rest of the task they want to complete from home.
Which option they should use to access the same Spreadsheet from home? [1]
(a) Consolidate Worksheet
(b) Link Worksheet
(c) Merge Worksheet
(d) Lock Worksheet
Answer:
(b) Link Worksheet

Explanation:
They can create a Link of that worksheet This will help them in opening the same
worksheet from home by clicking on that link.

(C)______ can help to clarify the relation between cells while using “Multiple Operations”.
[1]
(a) Detective
(b) Solver
(c) Navigation
(d) Hyperlink
Answer:
(a) Detective

Explanation:
The “Detective” option refers to a set of tools and features designed to help users
analyze and trace relationships between cells, formulas, and precedents in a
spreadsheet. These tools are useful for understanding the dependencies and
relationships within a complex spreadsheet, especially when dealing with large datasets
or intricate formulas.

(D) Identify the part of a Spreadsheet using which a user can manage multiple sheets.
[1]
(a) Status Bar
(b) Sheet Tab
(c) Formula Bar
(d) Worksheet Area
Answer:
(b) Sheet Tab
Explanation:
In Calc, the sheet tab refers to the tabs at the bottom of the Calc window that represent
individual sheets within a spreadsheet document. Each sheet tab typically has a default
name (like Sheetl, Sheet2, etc.) but can be renamed to reflect the content or purpose of
the sheet.

(E) Spreadsheet software can find the changes by sheets. [1]

(a) Changing
(b) Comparing
(c) Renaming
(d) Editing
Answer:
(b) Comparing

Explanation:
Comparing sheets in Calc involves analyzing the differences between two or more
sheets within the same spreadsheet document This can be useful when working with
multiple versions of a sheet or when trying to identify changes made to a sheet over
time.

(F) At the bottom of each worksheet, left tab indicates the of the worksheet in a
workbook. [1]
(a) Size
(b) 3 Type
(c) Name
(d) Color
Answer:
(c) Name

Explanation:
The leftmost tab at the bottom of each worksheet is typically called the “Sheet Tab” or
simply the “Sheet Name Tab.” This tab displays the name of the current worksheet and
provides a way to navigate between different sheets in the same spreadsheet
document.

Question 4.
Answer any 5 out of the given 6 questions. (5 × 1 = 5)
(i) Which of the following is an application program that is stored on a remote server
and delivered over the Internet? (1)
(a) Web application
(b) System application
(c) Internet application
(d) None of these
Answer:
(a) Web application

(ii) A __________ is a document model that you use to create other documents. (1)
(a) Anchoring
(b) Alignment
(c) Template
(d) None of these
Answer:
(c) Template

(iii) 1 : 1, 1 : n, and n : 1 are examples of different types of __________ (1)

(a) Relations
(b) Databases
(c) Data
(d) Query
Answer:
(a) Relations

(iv) In packet-based networks, the message gets broken into small __________ (1)
(a) data packets
(b) data frame
(c) chunk
(d) None of these
Answer:
(a) data packets

(v) This is a type of hyperlink available in the Hyperlink dialog box, which creates a new
worksheet. (1)
(a) New document
(b) New file
(c) New worksheet
(d) New data
Answer:
(a) New document

(vi) Which of the following allows you to display the specific data?
(a) Arranging
(b) Filtering
(c) Scenario
(d) Custom sorting
Answer:
(b) Filtering
Question 5.
Answer any 5 out of the given 6 questions. (5 × 1 = 5)
(i) A __________ refers to a cell or a range of cells on a Worksheet and can be used to
find the values or data that you want the formula to calculate. (1)
(a) cell reference
(b) block
(c) sheet reference
(d) autofill
Answer:
(a) cell reference

(ii) URL is the __________ for a website or a web page. (1)

(a) web address
(b) website
(c) web page
(d) Both (a) and (c)
Answer:
(a) web address

(iii) Rajiv has created an employee table and made Emp_No, the primary key so that it
can accept unique values for each record. At the same time, he wants to have one more
field that can behave like a primary key. Which of the following types of key can serve
the purpose? (1)
(a) Foreign key
(b) Composite key
(c) Unique key
(d) None of these
Answer:
(b) Composite key

(iv) __________ is used to define the structure of your tables and other objects in the
database. (1)
(a) DDL
(b) DML
(c) DCL
(d) None of these
Answer:
(a) DDL

(v) Suraj wants to know the sequence of steps used to open the Templates dialog.
Answer to his query. (1)
(a) File → New → ext Document
(b) File → New → Templates
(c) Format → Group → Group
(d) None of the above
Answer:
(b) File → New → Templates

(vi) Two other toolbars can be opened from the Picture Toolbar: the __________ and
__________ (1)
(a) Edit picture, Color picture
(b) Format, drawing
(c) Graphic Filter toolbar, Color toolbar
(d) Floating toolbar, Color toolbar
Answer:
(b) Format, drawing

Section B
Subjective Type Questions

Answer any 3 out of the given 5 questions on Employability skills. Answer each question
in 20-30 words. (3 × 2 = 6)

Question 6.
Explain any two principles of effective communication.
Answer:
Two principles of effective communication are as follows:
(i) Consistency: The communication should always be planned and consistent with a
clear objective of the message being conveyed.
(ii) Feedback: The feedback confirms the recipient whether the message is understood
in the same sense as it was delivered or not

Question 7.
How do green skills contribute to sustainable development? (2)
Answer:
Green skills enable the transition to a more sustainable society by promoting
responsible resource management, reducing pollution, and fostering social and
economic well-being.

Question 8.
What is the difference between moving and copying a folder? (2)
Answer:
Differences between moving and copying a folder are as follows.
 Copying a Folder Moving a Folder

Moving a folder means

Copying a folder means
transferring a folder
making a duplicate
from one location to
copy of a folder.
another.

It uses the Copy and It uses the cut-and-paste

Paste option. option.

The original folder The original folder is

remains at the source moved to the

locations. destination location.

Question 9.
How we can prevent computer against attack by viruses. [2]
Answer:
We can prevent the computer against attack of viruses by installing proper antivirus,
enabling the firewall, scan external devices before using on other computer, by avoiding
emails that are suspicious or not known to us, should be very carefijl while downloading
files or any programs from the internet etc

Question 10.
Can you explain what it means to encode a message? (2)
Answer:
Encoding a message means to change the message into a form suitable for sending.
The factors that must be considered when encoding messages are language, cultural
differences, etc.

Answer any 4 out of the given 6 questions in 20-30 words each. (4 × 2 = 8)

Question 11.
What is the use of grouping objects in a word processor application? (2)
Answer:
Grouping drawing objects makes it easier to handle several objects as a single entity
while preserving their relative sizes and positions. When objects are grouped, any
editing operations carried out on that group are applied to all members of the group. If
you click on one member of the group, the whole group is selected.

Question 12.
Differentiate between field and record in a table.
Answer:

Field Record

A record is a
A field contains only one
combination of
type of informations.
related fields.

It contains information It represents a

about one aspect of a complete unit of

complete record. information.

Question 13.
What is the use of the Scenario tool? (2)
Answer:
A Scenario is a set of values that Calc saves for a group of cells. Whenever we run a
scenario, Calc automatically substitutes the saved cell values into a connected formula
to give us an output. By having different scenarios for the same group of cells we can
get different results from the formula and compare these results to know which is the
most suitable set of values for us.

Question 14.
Define data, the major component of a database. (2)
Answer:
Data is raw numbers, characters, or facts represented by a value. Most organizations
generate, store, and process large amounts of data. The data acts as a bridge between
the hardware and the software. Data may be of different types such as User data,
Metadata, and Application Metadata.

Question 15.
Differentiate between a Primary key and a Foreign key. [2]
Answer:
A primary key is a unique value that identifies a row in a table, whereas a foreign key
identifies a column or set of columns in one (referencing) table that refers to a column
or set of columns in another referenced table. A table can have only a Primary Key but a
table can have multiple foreign keys.

Question 16.
What are the benefits of online shopping? (2)
Answer:
Some benefits of online shopping are as follows:

• Online shopping is very convenient. You can get products at home.

• Online shopping websites provide millions of choices of products.
• They offer huge discounts on goods and sen/ice.
• Online shops allow us to shop 24 × 7 and also reward us with cashback.
• Sending gifts to relatives and friends is easy by online shop.

Answer any 3 out of the given 5 questions in 50-80 words each. (3 × 4 = 12)

Question 17.
What is sorting? How to use ascending or descending sort which depends on one
column? (4)
Answer:
Sorting is a common spreadsheet task that allows users to easily re-order the data. The
most common type of sorting is alphabetical ordering which you can do in ascending or
descending order.
To use ascending or descending sort which depends on one column, follow the given
steps:
Highlight the cells to be sorted, then select Data → Sort to open the Sort dialog, or click
the Sort Ascending or Sort Descending toolbar buttons. Using the dialog, you can sort
the selected cells using up to three columns, in either ascending (A-Z, 1-9) or
descending (Z-A, 9-1) order.

Question 18.
Suhana is creating a brochure for a school fair. She added picture in the brochure which
contains some unwanted part.
(A) What can be done to remove that part from the picture?
(B) There are few drawing objects on that brochure on which she wants to perform
some common actions. How can she do it easily and quickly?
(C) How can she keep the image between the text?
(D) What is anchor point?
Answer:
(A) She can use Crop feature of word processor to remove that unwanted part from the
image.
(B) The drawing objects can be combined by grouping. This feature will treat all the
separate objects as one and whatever functions are performed will be applied on all of
them.
(C) Text Wrap feature can be used to keep the image between the text. The text is
placed around the image.
(D) An anchor is a symbol that appears when image or any other object is inserted in the
document. It is a reference point for the vertical and horizontal placement of images.

Question 19.
Consider the following table: Employee (4)

(a) How many fields and records are there in the table Employee?
(b) Write the SQL queries for the following:
(i) Display E name and Salary of those employees whose Salary is greater than or equal
to 22000.
(ii) Display details of employees who are not getting commission.
(iii) Display all the details of the employee profile ‘SALESMAN’.
Answer:
(a) There are 8 fields and 6 records in the table Employee.
(b) (i) SELECT E name, Salary FROM Employee WHERE Salary> = 22000;
(ii) SELECT* FROM Employee WHERE Commission IS NULL;
(iii) SELECT *FROM EMPLOYEE WHERE Profile=’’SALESMAN’;

Question 20.
Define the following types of integrity: (4)
(i) Entity integrity
(ii) Domain integrity
(iii) Referential integrity
(iv) User-defined integrity
Answer:
(i) Entity Integrity: It defines the primary key of a table. Entity integrity rule on a column
does not allow duplicate and null values.
(ii) Domain Integrity: It defines the type, range, and format of data allowed in a column.
Domain integrity states that all values in a column must be of the same type.
(iii) Referential Integrity: It defines the foreign key concepts. Referential integrity
ensures that data in related tables remains accurate and consistent before and after
changes.
(iv) User-Defined Integrity: If some business requirements do not fit any above data
integrity then the user can create their integrity, which is called user-defined integrity.

Question 21.
Consider the following Vendor table and write the queries for the following: [4]

Sub_
Sub_

Date of Exam Days

Name
code

E001 English 11-03-2023 Monday

 H002 Hindi 15-03-2023 Friday

S003 Social 18-03-2023 Monday

S004 Science 21-03-2023 Thursday

(A) Write a SQL command to display the records in ascending order by date of exam.
(B) Write a query to display the above date sheet.
(Q Write a query to display the subject name and date of the exam held on ‘Monday’
(D) Write an SQL command to display the date of the exam and Sub. Name of Science
subject.
Answers:
(A) Select*from Datesheet order by Date of Exam
(B) Select*from Datesheet
(C) Select Sub_Name, Date of Exam from Datasheet where Days= ‘Monday’
(D) Select Sub_Name, Date of Exam from Datasheet where Sub_Name = ‘Scienc

()