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________.

    1. Row, Column    B. Row, Cell Address   C. Column, Formula Bar              D. None

    13. Fill handle in MS Excel can be used for ___________.

    1. 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.

    1. 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.

    1. 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

    1. _____ 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:

    1. SUM( ) Function
    2. COUNT( ) Function
    3. AVERAGE( ) Function
    4. MIN( ) Function
    5. 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:

    1. Portrait Orientation: This orientation defines the document in vertical direction.
    2. 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:

      1. Application Programmers
      2. 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:

    1. Software (Operating System, DBMS)
    2. Hardware
    3. Procedures
    4. Data
    5. 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:

      1. Good governance is answerable to the community for its decisions.
      2. Good governance is transparent.
      3. Good governance follows the rule of law.
      4. Good governance is responsive which means that government always tries to serve the needs of the entire community timely and appropriately.
      5. Good governance is effective and efficient in implementing decisions that make the best use of the available resources.
      6. 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:

    1. 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.
    2. 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.
    3. 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.
    4. 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:

      1. Banking Services
      2. Aadhar services
      3. Passport Services
      4. Immigration & Visa Services
      5. Filing of Income Tax Returns
      6. Payment of various types of Taxes
      7. Central Excise and Custom Services
      8. Digital Land Management Systems
      9. Voter card services
      10. 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:

    1. House Tax Assessment
    2. Billing and Collection
    3. Maintaining records of Land & property
    4. Issue of Passport Verification Certificate
    5. Issue of Birth or Death Certificates
    6. Registration of Properties
    7. Provide services such as old age pension, widow pension, freedom fighter pension etc.