CLASS 7 COMPUTER WORK SHEET

Date: 06.09.2025

Subject: Practical Test for Class VII-B

This is to inform all parents that the Practical Test of Class VII-B will be held on 10th September 2025 (Wednesday). You are kindly requested to ensure that your ward is present on the scheduled date without fail.

Principal
Carmel School, Bhadrak

Practical of Computer

1. Insert 5 Names in Excel and Delete Any One Name

  • Open MS Excel.

  • Enter 5 names in column A (A1–A5).

  • Select one name → Right-click → Choose Delete → Shift cells up.

2. Change Content of a Cell and Add Color

  • In any cell, write Carmel.

  • Replace it with Carmel School.

  • Select the cell → Click on Fill Color → Choose Red.

3. Write Your Name 5 Times in MS Excel

  • In cells (A1–A5), type your name.

  • Example:

    Kiran  
Kiran  
Kiran  
Kiran  
Kiran

4. Write a Series in Excel Using AutoFill Feature

  • Type 1 in cell A1 and 2 in A2.

  • Select both cells → Drag the fill handle down.

  • Excel will automatically continue the series 3, 4, 5….

5. Create Worksheet, Rename and Delete a Sheet

  • Open a new workbook → A sheet named Sheet1 appears.

  • Right-click on the sheet tab → Choose Rename → Type your desired name.

  • To delete → Right-click on the sheet tab → Click Delete.

WORKSHEET 1

A. Uses of devices

  1. OMR → Used for checking and scoring multiple-choice exam answer sheets.

  2. Biometric → Used for fingerprint/iris/face recognition to verify identity.

  3. Plotter → Used to print large drawings like maps, charts, or blueprints.

B. Categorise into Decimal and Hexadecimal number system

Hexadecimal Number System:

  • F(12BD)₁₆

Decimal Number System:

  • (546)₁₀

  • A(398)₁₀

  • (867)₁₀

  • C(425)₁₀

C. Brief note on ASCII

ASCII (American Standard Code for Information Interchange) is a character encoding system that represents letters, numbers, punctuation, and control characters using numbers from 0 to 127.
👉 Example: A = 65, B = 66, a = 97.

D. Crossword Puzzle – Final Answers

  1. ROUTER (device used for connecting)

  2. PROTOCOL (pre-agreed signals)

  3. WORM (replicates itself)

  4. HACKER (one who breaks into a system)

  5. TOPOLOGY (various elements in a network)

  6. MODEM (digital to analog)

WORK SHEET 2

Section A: Write the name of

  1. The latest antivirus software available
    Answer: Norton 360 – Complete security suite with antivirus, VPN, dark web monitoring, password manager, and cloud backup.

  2. The latest type of virus present
    Answer: Ransomware
    Explanation: Ransomware is the latest and most dangerous virus type that locks files and demands payment for unlocking.

  3. Two ways to prevent the computer from any kind of malware
    Answer:

    • Install and update antivirus software.

    • Avoid downloading files from untrusted sources.
      Explanation: Antivirus helps detect and remove threats, while safe browsing prevents malware from entering the system.

Section B: Match the following

Column A | Column B | Answer

  1. Cell references | d. Addresses of the cells

  2. Operators | a. Specify the type of operation

  3. Functions | e. Built-in formulas

  4. Constant | c. Numbers or text values

  5. Enter | b. Display the results

Explanation:

  • A cell reference tells the address (like A1, B2).

  • Operators (+, -, ×, ÷) specify the type of calculation.

  • Functions (SUM, AVERAGE) are built-in formulas.

  • Constants are fixed values like numbers/text.

  • Enter key displays the result in Excel.

Section C: Crossword Puzzle

Down

  1. A grid of rows and columns used in spreadsheets → Worksheet

  2. Software mainly used for budgeting and calculations → Excel

  3. A bar located at the edge of the window for navigation → Scrollbar

  4. Pressing this key takes pointer to first cell → Home

  5. The meeting point of a row and column → Cell

  6. A vertical line of cells → Column

Across

  1. A horizontal line of cells → Row

  2. This always starts with equal sign in spreadsheets → Formula

  3. Microsoft software used for managing spreadsheets → Excel

  4. Ctrl + S is shortcut for save action → Save

  5. Pressing this key moves cell pointer down → Enter

  6. Ctrl + P is shortcut for printing action → Print

Explanation:
These answers are based on basic spreadsheet (Excel) concepts. Rows are horizontal, columns are vertical, formulas start with "=", Excel is the software, and shortcuts (Ctrl + S, Ctrl + P) are commonly used.

TESTSHEET 1

Tick (✔) the correct option:

1. Which of the following is a type of impact printer?
a. Dot-matrix ✔
b. Laser
c. Thermal
d. Inkjet
👉 Answer: Dot-matrix

2. To convert a number from decimal to binary number system, divide it by
a. 9
b. 2 ✔
c. 3
d. 0
👉 Answer: 2

3. Which virus infects program files like having an .exe extension?
a. Program Virus ✔
b. Trojan Horse
c. Spyware
d. Malware
👉 Answer: Program Virus

4. To copy data, use
a. cut + paste
b. copy + paste ✔
c. insert + paste
d. delete + paste
👉 Answer: copy + paste

5. ______ refers to rotating text at different angles inside a cell.
a. Indentation
b. Alignment
c. Orientation ✔
d. Merge Cells
👉 Answer: Orientation

Fill in the blanks:

  1. In Excel, to format date and time, use Format Cells option.

  2. The act of taking someone’s work and passing it as their own work is known as Plagiarism.

  3. Two examples of non-impact printers are Inkjet printer and Laser printer.

  4. All formulas must begin with = sign.

  5. Scareware are programs or apps that simply display a false virus alert and scare you to install an antivirus into the system.

Write T for True and F for False statements:

  1. ROM is a type of primary memory. → T

  2. Row is the vertical space up and down the worksheet. → F (Row is horizontal, Column is vertical)

True / False

3. Spamming is cheating by using email to get a person to reveal their personal data.
👉 False (That is Phishing. Spamming means sending unwanted bulk emails.)

4. Number system is a set of different values that are used to represent different quantities.
👉 True

5. Antivirus software is a utility software that has the counter logic for scanning, detection, identification and treatment of viruses.
👉 True

Answer these questions

1. Differentiate between different types of hardware components.

  • Input Devices: Used to enter data into the computer (e.g., keyboard, mouse, scanner).

  • Output Devices: Used to display results (e.g., monitor, printer, speakers).

  • Storage Devices: Store data permanently or temporarily (e.g., hard disk, pen drive, RAM).

  • Processing Device: CPU processes data and instructions.

2. Define the following terms:
a) Face Value – The actual value of a digit in a number (e.g., in 456, face value of 5 is 5).
b) Position Value – The value of a digit depending on its place (e.g., in 456, position value of 5 is 50).

3. Define malware. Explain different types of malware.

  • Malware: Malicious software designed to harm a computer or steal information.

  • Types:

    • Virus: Attaches to files and spreads.

    • Worm: Self-replicating program spreading through networks.

    • Trojan Horse: Appears harmless but contains harmful code.

    • Spyware: Collects personal information secretly.

    • Ransomware: Locks system/data and demands payment.

4. What do you understand by firewall?
A firewall is a security system that monitors and controls incoming and outgoing network traffic. It protects a computer from unauthorized access.

5. Discuss the preventive measures that need to be taken while using the Internet.

  • Install and update antivirus software.

  • Use strong and unique passwords.

  • Avoid clicking on suspicious links/emails.

  • Do not share personal information online.

  • Use firewalls and secure websites (HTTPS).

  • Regularly update operating systems and software.

6. What are the advantages of using Microsoft Excel 2019?

  • Easy data entry and organization.

  • Powerful tools for calculations and formulas.

  • Graphs and charts for data visualization.

  • Data analysis using filters, sorting, PivotTables.

  • Functions like AutoSum, AutoFill, and conditional formatting.

  • Supports large amounts of data.

7. What is the purpose of the AutoFit row height?
AutoFit row height automatically adjusts the row’s height to fit the text or data inside the cell completely without cutting off any content.


Comments

Post a Comment

Popular posts from this blog

class 8 computer chapter 5

1. Java Keyword 👉 Definition: Keywords are reserved words in Java that have special meaning to the compiler. They cannot be used as identifiers (like variable names). 👉 Example: class , public , static , void , int , if , else public class Example { public static void main(String[] args) { int number = 10; // 'int' is a keyword if(number > 5) { // 'if' is a keyword System.out.println("Number is greater than 5"); } } } 2. Java Token 👉 Definition: A token is the smallest unit in a Java program. 👉 Types of Tokens: Keywords Identifiers Literals (numbers, characters, strings) Operators ( + , - , * , / ) Separators ( ; , {} , () ) 👉 Example: int a = 10; // Tokens: int, a, =, 10, ; 3. Java Data Types 👉 Definition: Data types define the type of data a variable can store. Two categories: Primitive Data Types (8 types) byte → 1 byte (e.g. byte b = 100; ) short → 2 bytes (e.g...
Read more

CLASS 8 COMPUTER

  Questions & Answers 1. A step-by-step procedure to solve a particular problem. Answer: b. Algorithm Explanation: An algorithm is a set of ordered steps or instructions designed to perform a specific task or solve a problem. Flowcharts and programs are based on algorithms. 2. Pictorial representation of steps to solve a specific problem. Answer: d. Flowchart Explanation: A flowchart uses symbols and arrows to represent the sequence of steps visually, making it easier to understand the process. 3. A shape used to connect different shapes in a flowchart. Answer: a. Arrow Explanation: Arrows indicate the flow of control or sequence between steps in a flowchart. 4. A rounded shape in a flowchart is used to show the: Answer: d. Start and Stop Explanation: Ovals (or terminals) in flowcharts represent the starting and ending points of the process. Part A: MCQ Q5. Which of the following is true about pseudocode? Options: a. It...
Read more

Class 5 computer chapter 4

   A. Multiple Choice Questions Which of the following actions cannot be performed on the shapes? Answer: d. Crop ✅ Rajan wants to rotate an image, which handle should he use after selecting the image? Answer: a. Rounded arrow shaped handle ✅ Which of the following is not an example of Illustration? Answer: b. Image ✅ Which of the following is not a video playback setting? Answer: b. Video Border ✅ ___ creates a graphical illustration while ___ is artistic text. Answer: a. SmartArt, WordArt ✅ Table can be inserted in the slide using Answer: d. All of these ✅ B. Fill in the blanks (Options: Chart, Eyedropper, Trimming, Layout, SmartArt) Inserting/deleting rows/columns in a table can be done using Layout. ✅ To insert Chart you need to enter the data. ✅ Trimming removes unwanted starting and ending part of an audio or a video. ✅ List, Process, Cycle – these are the categories of SmartArt. ✅ Eyedropper picks a colour from another part of the slide. ✅ C. Answer the following How wi...
Read more