Saturday, September 12, 2026

Class 7 IT worksheet Solutions


WORKSHEET–1 — ANSWERS

A. Select the correct option

An if statement within another if statement is called

(d) Nested if

The Excel feature that recognises a data pattern and fills other cells with the same pattern is

(a) Flash Fill

The number 12 in the hexadecimal number system is denoted by

(b) C

Operators that combine two expressions involving relational operators are

(a) Logical

The area bounded by the two axes in a chart is called

(c) Plot Area

B. Fill in the blanks

The Format Painter lets you copy formatting from one cell to another cell.

The values on which operators perform tasks are called Operands.

A compact chart that visualises a row or column of data and fits inside a single cell is called a Sparkline.

The starting of text at a position away from the margin in Python is called Indentation.

A digital computer represents data and information using the Binary number system.

C. Write T for True and F for False

A Radar chart represents data in the form of a circle divided into various sectors.

F — This description is of a Pie chart.

The Logical operator OR returns False if any one of the expressions evaluates to False.

F — OR returns False only when all expressions are False.

The base of a number system is also called its Radix.

T

Every if statement must have a corresponding else statement.

F — An else statement is optional.

Conditional formatting makes it easy to highlight certain values.

T

D. Perform the following operations

1. Convert decimal 73 into binary

73 = 64 + 8 + 1

Therefore:

73₁₀ = 1001001₂

2. Convert binary 10101110 into decimal

= 128 + 32 + 8 + 4 + 2

= 174

10101110₂ = 174₁₀

3. Add 101101 and 111001

  101101

+ 111001

--------

 1100110

Answer: 1100110₂

4. Divide 101010 by 111

101010₂ = 42₁₀

111₂ = 7₁₀

42 ÷ 7 = 6

6₁₀ = 110₂

Answer: 110₂

5. Subtract 11001 from 111010

111010₂ = 58₁₀

11001₂ = 25₁₀

58 − 25 = 33

33₁₀ = 100001₂

Answer: 100001₂

E. Write the output of the expressions/code in Python

1. String multiplication

The expression involving:

"Ha!" * 4

produces:

Ha!Ha!Ha!Ha!

2. Logical expression

(True and False) or (True and not(False))

Step-by-step:

True and False → False

not(False) → True

True and True → True

False or True → True

Output: True

3. Arithmetic expression

For the expression shown in the image:

11 - (50 - 2) + 40 % 8

50 − 2 = 48

40 % 8 = 0

11 − 48 + 0 = −37

Output: -37

4. If–else program

The program checks whether x > 30. For the value shown (x = 30), the condition is false.

Output:

You have a small number

F. Identify the errors and write the correct code

Correct program

# Program to accept two numbers and display the smaller number


Num1 = int(input("Enter first number: "))

Num2 = int(input("Enter second number: "))


if Num1 > Num2:

    print("Second number is smaller")

else:

    print("First number is smaller")

Main errors in the given program

Num2 = print(...) should be Num2 = input(...).

The inputs should be converted to integers using int().

num2 and Num2 are different variable names in Python.

or: should be else:.

The statements inside if and else need proper indentation.

G. Answer the following questions in brief

1. Explain the working of the if...else statement in Python with an example.

The if...else statement is used to make a decision.

If the condition is True, the if block executes.

If the condition is False, the else block executes.

Example:

age = 18


if age >= 18:

    print("Eligible")

else:

    print("Not eligible")

Output:

Eligible

2. Difference between face value and place value

Face value: The actual value of a digit, regardless of its position.

Place value: The value of a digit according to its position in a number.

Example: In 5,432

Face value of 5 = 5

Place value of 5 = 5,000

3. Difference between division and modulus operators in Python

Operator

Name

Purpose

Example

/

Division

Gives quotient, usually as a decimal

10 / 3 = 3.333...

%

Modulus

Gives remainder

10 % 3 = 1

4. Name any five types of charts available in Excel 2019.

Any five:

Column Chart

Bar Chart

Line Chart

Pie Chart

Scatter Chart

Other examples include Area, Radar, Doughnut and Stock charts.

H. Answer the following questions

1. What are Conditional Statements? Write the syntax of any two Conditional Statements in Python.

Conditional statements are statements used to make decisions in a program based on whether a condition is True or False.

(a) if statement

Syntax:

if condition:

    statement

Example:

marks = 80


if marks >= 40:

    print("Pass")

(b) if...else statement

Syntax:

if condition:

    statement1

else:

    statement2

Example:

marks = 35


if marks >= 40:

    print("Pass")

else:

    print("Fail")

2. What is a data type? Explain common data types available in Python with examples.

A data type specifies the kind of value that a variable stores.

Common Python data types are:

Data Type

Meaning

Example

int

Integer/whole number

age = 15

float

Decimal number

price = 25.50

str

Text/string

name = "Rahul"

bool

True or False

passed = True

list

Collection of values

marks = [80, 75, 90]

For example:

age = 15

height = 5.6

name = "Aman"

passed = True

marks = [80, 75, 90]

3. Write a short note on the Binary Number System.

The binary number system is a number system with base 2. It uses only two digits:

0 and 1

Computers use the binary number system because electronic circuits can conveniently represent two states, such as ON/OFF.

The positions in a binary number have powers of 2.

For example:

1011₂

means:

= 8 + 0 + 2 + 1

= 11₁₀

Thus, 1011₂ = 11₁₀.

4. What do you mean by sorting data? Write the steps to sort data on multiple columns in a worksheet.

Sorting data means arranging data in a particular order, such as:

Ascending order

Descending order

Alphabetical order

Numerical order

Steps to sort data on multiple columns in Excel

Select the entire data range.

Go to the Data tab.

Click Sort.

Select the first column in Sort by.

Select the required order, such as A to Z or Smallest to Largest.

Click Add Level.

Select the second column.

Select its required sorting order.

Add more levels if required.

Click OK.

Excel will arrange the data according to the first column and then use the second/third columns to further arrange records.

Quick Answer Key

A: 1-d, 2-a, 3-b, 4-a, 5-c

B: Format Painter, Operands, Sparkline, Indentation, Binary

C: F, F, T, F, T

D: 1001001, 174, 1100110, 110, 100001

E: Ha!Ha!Ha!Ha!, True, -37, You have a small number

Would you like the answers formatted as a clean school answer sheet or a teacher marking key?

No comments:

Post a Comment