Computer
science
Class : 9th
Term 2 revision of March Exam 2025
1-1 marks, 3-3 marks and 6-6 marks questions
Multiple choice questions(1-1 Marks)
1. ______________ is a group of two or more computers that
are linked in order to share resources such as printers, files, and other resource.
a. Network b.
Internet c.
Wireless d.
Topology
2. Which of the following is the smallest type of network?
a. MAN b.
WAN c. LAN d.
None of these
3. _____________ is a device that allow you to connect
multiple computers to a single network.
a. Hub b.
Bus c.
Ring d.
Star
4. In ____network topology, a single backbone cable is
shared by all the devices.
a. Bus b.
Tree c.
Mesh d. Star
5. ____________ prepares information and sends it.
a. Protocol
b. Receiver c. Sender d. Hub
6. 'Gmail' is a free email service provided by_________.
a. Yahoo b.
Google c. Rediff
mail d. Hotmail
7. A ________ is a type of test used in computing to
determine whether or not the user is human.
a. CAPTCHA b. DERTSA c. HEPTCHA d. NEPHCA
8. ______is a type of malware designed to provide
unauthorized, remote access to a user’s computer.
a. Spyware b.
Trojan c.
Malware d. Horse
9. _______ is a computer program that replicates itself into
other computer programs.
a. Spyware b.
Virus c.
Phishing d. Malware
10. _______ is an Indian digitization online service
provided by the Ministry of Electronics and Information Technology (MeitY),
Government of India under its Digital India initiative.
a.
DigiLocker b. DigiProgram c. DigiHacker d.
DigiBanker.
11. A workbook is a collection of the____________.
A. Cell B.
Row C. Column D. Worksheets
12. A cell is an intersection of a ______and a________.
- Row,
Column B. Row, Cell Address C. Column, Formula Bar D. None
13. Fill handle in MS Excel can be used for ___________.
- Copying
the contents of a Cell B.
Entering Number Series
C. Entering Custom Series D. All of the
above.
14. The Extension of MS Excel file is_______________.
A.
.docx/.doc B. .xlsx/.xls C. .pptx/.ppt D. .txt
15. Which one of the following is not a view of MS Excel?
A. Page Layout B. Page
Break Preview C. Normal D. None of these
16. By default, each new workbook in MS Excel 2010 contains
______ number of worksheets.
A. 5 B. 2 C.
255 D. 3
17. Which objects can be added in a worksheet?
A. Cells B.
Charts C. Rows D.
All of these
18. Which are the valid types of Charts in MS Excel.
- Bar,
Column, Pie, Line B.
Area, Doughnut, Scatter
C. Surface, Radar, Bar D.
All of the above
19. Which function is used to find minimum number from the
given range.
A. Average B. Min C. Max D. Rank
20. _____is a powerful tool of MS Excel used to have
graphical representation of our data in MS Excel.
- Data
Validation B.
Conditional Formatting C.
Charts D. None
21. Each function or
formula must start with symbol in MS Excel.
A. + B. = C. & D. ^
22. Which function of MS
Excel can be used to find minimum no from given range?
a) Minimum B. Mid C. Min D. None of
these
23. Ampersand (&)
symbol is an alternate of____function in MS Excel.
a) Sum B. And C. Concatenate D. Power
24. Which data tool can be used to have only distinct values
in a particular column?
A. Data Validation B.
Text to Columns C. Formula D. Remove duplicates
25. Which one is an example of Arithmetic Operator?
A. + B.
% C.
^ D.
All of these
26. Which
option belongs to Page Layout Tab?
A. Page Orientation B.
Paper Size C.
Print Area D. All of these
27. Which one is not a view in MS Excel?
A. Formula View B.
Normal View C. Page Layout
View D. Page Break Preview
28. is
the empty space between the worksheet data and the edges of the printed page.
A. Paper Size B.
Print Area C. Margin D. Print Preview
29. appears
on the top of each page in print preview and printed sheets.
A. Footer B.
Header C. Bottom
Margin D. None of
These
30. We can lock our cells from being accidently changed with
the help of ___ Option.
A. Save As B.
Save C.
Print Area D. Protect
Sheet
31. Which is/are the levels of E-Governance?
A. National Level b.
State Level c. Local Level d. All of the above
32. Which of the following is not a pillar of E-Governance
a. Capital b.
Knowledge c. Delay in Work d. Connectivity
33. E-Governance Services can be shared between Government
and
a. Citizens b.
Government c. Businessman d. All of these
34. model
of e-governance refers to the government services which are shared by citizens.
a. G2B b.
G2E c.
G2G d. G2C
35. E-governance services at National level are provided by
______ Government of India.
a. Local b.
State c.
National d. All of these
- _____
is a raw and unorganized fact that requires processing to make it
meaningful.
a. Data b.
Information c. Database d. DBMS
37. A Record is also known as a ______.
a. Column b.
Attribute c. Field d. Tuple
38. A person who manages and controls the overall DBMS is
called a
a. DBA b.
End User c. Database
Designer d. Programmer
39. DBMS is a software layer that provides an interface
between and
the .
a. Data, Information b.
DBA, End User c. User, Database d. Data, Database
40. refer
to general rules and instructions that help to design the database and to use a
database management system
a. Information b.
Procedures c. Application Programs d. System Programs
Write the shortcut for the following(1-1Marks)
1. To Open an existing file in MS Excel : Ctrl + O
2. To Save a file in MS Excel : Ctrl
+ S
3. To Create a new file in MS Excel : Ctrl + N
4. To Fill Down in MS Excel :
Ctrl + D
5. To Fill Right in MS Excel :
Ctrl + R
6. To Copy contents in MS Excel : Ctrl + C
7. To Paste contents in MS Excel : Ctrl + V
Write full forms(1-1marks)
1. LAN : Local
Area Network
2. MAN : Metropolitan
Area Network
3. WAN : Wide Area Network
4. PAN : Personal
Area Network
5. NIC : Network
Interface Card
6. G2C : Government to
Citizen
7. G2G : Government to
Government
8. G2E : Government to
Employee
9. G2B : Government to Businessmen
10. IRCTC : Indian Railway Catering and
Tourism Cooperation
11. DBMS : Database Management System
12. DBA : Database Administrator
13. SQL : Structured Query Language
Write True or False(1-1marks)
1. We cannot Share hardware or Software among network
devices.(False)
2. LAN covers a large geographic area. (False)
3. In full duplex, information can be transmitted in both
directions.(True)
4. Protocols are set of rules by which data transmission
takes place between nodes. (True)
5. Spyware is an e-mail fraud method in which the wrongdoer
sends out legitimate-looking email in an attempt to gather personal and
financial information from recipients. (False)
6. Google Drive does not allow us to store and share files
online.(False)
7. The best way to deal with the threat of a computer virus
is to use antivirus software. (True)
8. The Web threat is any threat that uses the World Wide Web
to facilitate cybercrime. (True)
9. Google Meet is a video conferencing service by Google. (True)
10. Address of Active Cell always displays in Name Box. (True)
11. All Columns of MS Excel are represented by numbers
starting with 1. (False)
12. Cell containing formula displays the result of the
formula, whereas the formula itself displayed in Formula Bar. (True)
13. MS Excel is a widely used word Processor. (False)
14. We can insert Number Series in MS Excel using Fill
Handle. (True)
15. New cell, row or column can be added by using Ctrl and +
keys from keyboard. (True)
16. SUM and MIN are examples of Chart Types in MS Excel. (False)
17. Cell Borders, change cell width or height, Merge cells,
Align Texts, Change Orientation of text, Wrap Text etc. are examples of cell
styles. (True)
18. Conditional Formatting is a tool in MS Excel that allows
applying formats to a cell or range of cells depending on the value. (True)
19. Formatting options effectively represents the
information from facts of data. (True)
20. We cannot count blank cells in MS Excel. (False)
21. Formula is an expression of operators and operands to
perform calculations. (True)
22. SUM function can be used to perform addition of values
in a particular range. (True)
23. Text to columns option can be used to split our contents
in multiple cells. (True)
24. NOW function returns current date and time in MS Excel. (True)
25. Workbook cannot be protected in MS Excel. (False)
26. We cannot remove Page Break once inserted. (False)
27. Page Orientations are of two types: Portrait and
Landscape. (True)
28. Margins can be on top, bottom, left, right header and
footer of a page. (True)
29. We can use Print Area option to print a specific part of
a Worksheet. (True)
Short answer type questions(3-3marks)
Question:1 Write the names of any four Network
Topologies?
Ans: Name of Network Topologies are given below:
a. Bus
Topology
b. Star
Topology
c. Ring
Topology
d. Mesh
Topology
e. Tree
Topology
f. Hybrid
Topology
Question:2 Define Network Interface Card (NIC)?
Ans: A Network Interface Card (NIC) is a Printed Circuit
Board (PCB). It is installed on the motherboard inside a system-unit so that a
computer can be connected to a network. It should be fitted in each client and
server computer. There are two types of network cards:
a. Ethernet
Card
b. Wireless
Card
Question:3 Write the names of components of Data
Communication?
Ans: Name of components of data communication are given below:
a. Sender
b. Medium
c. Receiver
d. Protocol
Question:4 Write a short note on HUB?
Ans: A Hub is a hardware device. This device is used in
computer networks. It is used in Star Topology to connect multiple computers in
a network. The hub typically receives data at one port, then it duplicates this
data and makes it available on all other ports. In this way, the hub provides
data sharing facility between computers connected in a network.
Question:5 What are the two types of Ring Topologies?
Ans: In Ring topology, all computers are connected like a
ring. Each node is connected with its two neighboring nodes.
Ring topology is of two types:
1. Single Ring: In this topology, computers are
connected with each other using a single cable and flow of data is unidirectional.
2. Dual Ring: In this topology, computers are
connected with each other using a dual ring cable and flow of data is bidirectional.
Question:6
Define MS Excel?
Ans: Microsoft Excel is a spreadsheet program developed by
Microsoft. It is part of MS Office Suite. We can use it to organize our data
into rows and columns and to perform mathematical calculations. We can also
represent our data in the graphical way in Excel using charts and graphs. Files
created in Excel are called Workbooks and they are saved with extension .xls or .xlsx
Question:7 What are the uses of MS Excel?
Ans: Following are some of the common uses of MS Excel:
1) Excel can be used for mathematical calculations.
2) Data can be represented in a graphical form using Charts.
3) We can also prepare school Timetable.
4) Salaries of employees can be calculated.
5) Results of students can also be prepared in Excel.
Question:9 Explain Ribbon in MS Excel?
Ans: Microsoft Excel ribbon is the panel of tabs and icons
at the top of the Excel window. Excel ribbon contains almost all commands and
features that we use during working in Excel. All these commands are organized
into different tabs based on their functionality. Tab commands are logically
subdivided into Groups. There are seven tabs in Excel ribbon: Home, Insert,
Page Layout, Formulas, Data, Review, and View.
Question:10 What is Name Box?
Ans: Name Box is a part of formula bar in Excel. It appears
at the left side of the formula bar. It is an input box. Normally, it shows the
address of active cell. For example, if we have selected the cell B3, this name
box will show the active cell address as B3. We can also input the cell address
in the Name Box to navigate quickly in a worksheet.
Question:11 Explain Rows and Columns in MS Excel?
Ans: Rows and Columns are important part of a worksheet in
Excel. These are explained below:
1. Row: Rows are the horizontal lines of cells in the
worksheet. Each row is identified by row number. Rows are named as 1,2,3,4, . .
.so on. There are total 1048576 rows in the Excel 2010 worksheet.
2. Column: Columns are the vertical lines of cells in
the worksheet. Each column is identified by column header. Columns are named as
A, B, C, D, . . . . . , AA, AB, . . . so on. XFD is the name of last column in
Excel 2010. There are total
16384 columns in Excel 2010.
Question:12 What do you mean by Formatting?
Ans: Formatting refers to change in the appearance of
contents. We can format the data in many ways. Formatting makes our data more
readable. There are many tools in MS Excel which can be used to format text and
cells. It includes: changing the color and style of text and cells, aligning
texts, formatting numbers and dates etc.
Question:13 Which type of formatting can be used as Cell
Styles?
Ans: There are several options for changing the styles of
cells, some are given below:
1. Cell
Borders
2. Aligning
Text
3. Changing Orientation of Text
4. Wrapping
Text
5. Applying
Number Formats
Question:14 What do you mean by Merging Cells?
Ans: Merging Cells means combining two or more adjacent
cells to make them a single cell. We can merge any number of cells in Excel. To
merge selected adjacent cells, we can use ‘Merge and Center’ option available
in the Home tab of Excel.
Question:15 Define alignment and its types?
Ans: Alignment is a formatting style for cells. It is used
to describe how text is placed in the cell. Text of cell can be aligned
horizontally and vertically. Alignment options are available in the Home tab of
Excel. For Horizontal Alignment of contents in a cell, we can Left align,
Center align and Right align options, while For Vertical Alignment, we can use
Top align, Middle align and Bottom align options in Excel.
Question:16 What are Charts?
Ans: Chart is an important feature of Excel. It is used to
represent data in the graphical form. Charts are useful in better understanding
of information. Chart is the best way to compare values or to show trends in
the data. We can create many types of charts in Excel, such as: Pie Chart,
Column chart, Line Chart, Bar Chart,
Area Chart etc.
Question:17 Write arithmetic operators being used in MS
Excel.
Ans: Arithmetic operators are used to perform basic
mathematical operations. The list of these operators is as under:
Symbol |
Description |
Example |
Result |
+ |
Used for Addition |
=3+3 |
6 |
- |
Used for Subtraction |
=3–3 |
0 |
* |
Used for Multiplication |
=3*3 |
9 |
/ |
Used for Division |
=3/3 |
1 |
% |
Percent |
=30% |
0.3 |
^ |
Used for Exponentiation |
=3^3 |
27 |
Question:18 What do you mean by Data validation?
Ans: Data Validation is one of the most important tools of
Excel. Using this tool, we can define the rules for data to be allowed in the
cell. If entered data in the cell does not follow the specified rules, it will
display an Error Message. This tool is available in the Data Tab.
Question:19 Give the name of any three mathematical
functions.
Ans: Following are the commonly used mathematical functions:
- SUM(
) Function
- COUNT(
) Function
- AVERAGE(
) Function
- MIN(
) Function
- MAX(
) Function
Question:20 What is
Sorting in MS Excel?
Ans: Arranging data in a
sequence is called Sorting. Data can be arranged in ascending or descending
order. To sort data in excel sheets, Home or Data tabs can be used. To arrange
data in Ascending Order, we use
option and for descending order we will use Option.
Question:21 Define formula?
Ans: A formula is an expression that operates on values. These
expressions may include constant values, cell addresses and operators. In Excel,
formulas are used to perform calculations on numerical data. Each formula
begins with equals to (=) sign. Standard operators (+, -, *, /, ^ etc.) can be used
in formulas to perform different types of calculations
Question:22 Give the name of conditional functions used in
MS Excel?
Ans: Commonly used conditional functions used in MS Excel
are given below:
1. IF( ) Function
2. SUMIF( ) Function
3. COUNTIF( ) Function
Question:23 What do you mean by Margin?
Ans: A margin is the space between the main content of a page
and its edges. We can set margin in all four directions of a page, i.e. Top
Margin, Bottom Margin, Left Margin and Right Margin. The margin helps to define
where a line of text begins and ends. Commonly, document’s margin-size is set
to one inch. Margin size can also be adjusted as per our requirement
Question:24 Write a short note on Page Orientation.
Ans: Page orientation refers to the direction of document
in which it is displayed or printed. We can use our page either in horizontal
or vertical direction. We can change the orientation of document using Page
Layout tab. Therefore, there are two basic types of page orientation:
- Portrait
Orientation: This orientation defines the document in vertical direction.
- Landscape
Orientation: This orientation defines the document in horizontal
direction.
Question:25 What do you
mean by Scaling?
Ans: Scaling is the process of compressing or expending
the contents of a page so that it can be adjusted on a specific page/pages. This
option is very useful when we have to work on a large worksheet. Using this option,
we can adjust all the contents of a worksheet on a single page. Similarly, a
small content can also be expanded over multiple pages. Scaling options are
available on the Page Layout tab in Excel.
Question:26 Give names of views in MS Excel.
Ans: There are five different types of views available
in MS excel.
1. Normal View (Default View)
2. Page Layout View
3. Page Break Preview
4. Custom Views
5. Full Screen View
Question:27 What is the use of Page Break?
Ans: Page break is an important option of Excel. It is
a special marker that will end the current page and start a new one. This is
very useful option if we want our contents to be printed among different pages.
This option is available on the Page Layout Tab. Page break is always inserted at
top left corner of active cell.
Question:28 What is record?
Ans: A record is an important element of a database. It a
collection of named data-items. It represents a complete unit of information in
the table. A Record is also known as a Tuple. Following table shows the example
of four student records.
Question:29 Define Database.
Ans: A database can be defined as the organized collection
of interrelated data. Databases are used to store the vast amount of data in
various organizations. A database provides organized structure to store data
electronically. Generally, data in the database is organized into rows,
columns, and tables. A database may have one or more tables.
Question:30 Write the name of different types of users of
database.
Ans: Following are the different types of users of database:
- Application
Programmers
- Database
Administrators
3. End-Users
Question:31 What do you know about DBMS?
Ans: DBMS stands for Database Management System. To overcome
all drawbacks of file processing system, a new system called Database
Management System (DBMS) was developed. DBMS is a system software. It provides
us the facility to create, retrieve, update and manage data of the database. In
simple terms, we can say that DBMS is a software layer that provides an
interface between user and the database.
Question:32 Write the name of various components of
Database environment.
Ans: Following are the various components of Database
Environment:
- Software
(Operating System, DBMS)
- Hardware
- Procedures
- Data
- Users
Long answer type questions(6-6marks)
Question:1 What are Google Apps? Explain any two Google
Apps?
Ans: A set of web-based applications provided by Google are
called Google Apps. We must have a Google account to use these apps. Gmail,
Calendar, Maps, and Docs etc. are some of important google apps:
1. Gmail: This Google app is used to send and receive
emails. Using this app, we can send a message from mobile or computer to any
person.
2. Google Drive: This Google app allows us to store
and share files online. Google provides 15 GB storage space to every Google
account for storing data.
Question:2 What is Google Drive? Write various benefits
of Google Drive?
Ans: Google Drive is a service offered by Google. This
Google app allows us to store and share files online. Google provides 15 GB
storage space to every Google account for storing data. We must have a Google
account to use this app.
Benefits
of Google Drive:
1. We can store our data at the online drive
2. We can share files stored on Google drive with other
persons
3. We can view our files stored on the Google drive from
anywhere
4. Google drive provides a built-in search engine to find
files easily.
5. We can open many types of files (docx, xlsx, psd, jpg
etc.) on the Google drive.
6. All these facilities are provided free of cost by Google.
Question:3 Write about various methods of Internet
Security?
Ans: Internet Security is a branch of Computer Security. It
protects our computer from various internet threats.
Following are some of the common methods used for
Internet Security:
1. Anti-virus: Antivirus software helps us to protect
our computer system from viruses. Antivirus software scans our online activity
to make sure we are not downloading infected files. Norton, Kaspersky, Avira,
Avast, Mcafee etc are the examples of commonly used anti-viruses.
2. Anti-Spyware: Anti-spyware software helps us to
detect and remove unwanted spyware programs.
3. Prevention from Trojan Horse: We should never
download or install software from untrusted sources. Never open an attachment
or run a program received via email from untrusted sources. Make sure a Trojan
antivirus is installed on our
computer.
4. Prevention from Phishing Scam: Don’t follow the
link received through SMS or emails, and login only from the official website.
Question:4 What is Cyber Crime? Write various preventive
measures against Cyber Crimes.
Ans: Cybercrime is a crime that involves a computer and a
network. Cyber Crimes can involve criminal activities that are traditional in
nature, such as theft, fraud, forgery, defamation and mischief.
Preventive measures against Cyber Crime:
1. The user must use a full internet security suite.
2. The user must use strong passwords for various online
websites.
3. Keep your software updated.
4. Keep your personal and private information locked down.
5. Keep yourself up to date on major security breaches.
6. If you believe that you’ve become a victim of cybercrime,
you need to alert the local police.
Question:5 Write the main characteristics of Good
Governance.
Ans: Following are some of the important characteristics of
a Good Governance:
- Good
governance is answerable to the community for its decisions.
- Good
governance is transparent.
- Good
governance follows the rule of law.
- Good
governance is responsive which means that government always tries to
serve the needs of the entire community timely and appropriately.
- Good
governance is effective and efficient in implementing decisions that make
the best use of the available resources.
- Good
governance is participatory. Anyone has the opportunity to participate in
the process of decision making.
Question:6 What is E-Governance? Explain the four models
of E-Governance.
Ans: E-Governance stands for Electronic Governance. It
refers to the use of ICT to improve the range and quality of information and
services delivered to the public. E-Governance has made the working of
government more transparent. Models of E-Governance:
- Government
to Citizens (G2C): This model refers to the government services which
are shared by citizens. For Example: Payment of online bills, Online
passport registration etc.
- Government
to Business (G2B): This model refers to the government services which
are shared by businessmen. For Example: Collection of taxes, Payment of
bills etc.
- Government
to Employees (G2E): This model refers to the government services which
are shared by its employees. For Examples: Employees can access any kind
of rule-regulation, Employees can check their payment and records etc.
- Government
to Government (G2G): This model refers to the government services
which are shared between the governments. For Example: Sharing of
information between police department of various state etc.
Question:7 Make a list of various Services provided at
National level of E-Governance.
Ans: Some of the important E-governance services at national
level are given below:
- Banking
Services
- Aadhar
services
- Passport
Services
- Immigration
& Visa Services
- Filing
of Income Tax Returns
- Payment
of various types of Taxes
- Central
Excise and Custom Services
- Digital
Land Management Systems
- Voter
card services
- PAN
Card services
IRCTC, UMANG, DigiLocker, e-Pramaan etc. are the examples of
various projects that provides services at National level.
Question:8 What are the E-Governance Services in the
Urban Areas?
Ans: Following are the E-Governance Services that are
provided in Urban Areas:
- House
Tax Assessment
- Billing
and Collection
- Maintaining
records of Land & property
- Issue
of Passport Verification Certificate
- Issue
of Birth or Death Certificates
- Registration
of Properties
- Provide
services such as old age pension, widow pension, freedom fighter pension
etc.
0 Comments
Post a Comment
Please don't post any spam link in this box.