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