Page 54 - Code & Click - 7

Worksheet-1

(Based on Chapters 1 – 5)

A. Select the correct option for each of the following statements.

1. An if statement within another if statement is called ______.
(a) Blocked if (b) Stored if (c) Joined if (d) Nested if

2. The feature in Excel that recognises the data pattern in a cell and fills other cells in a range
using the same pattern is ______.

(a) Flash Fill (b) Filter Data (c) Sort Data (d) AutoComplete

3. The operators that combine two expressions involving relational operators are ______
operators.

(a) Logical (b) String (c) Arithmetic (d) Assignment
4. The area bounded by the two axes in a chart is called ______.

(a) Axes Area (b) Joint Area (c) Plot Area (d) Chart area

B. Fill in the blanks with the correct answer.

1. The values on which operators perform tasks are called _________.

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

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

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

C. Write ‘T’ for True and ‘F’ for False statement.

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

2. The base of a number system is also called its Radix. _______
3. Every if statement must have a corresponding else statement. _______

4. Conditional formatting makes it easy to highlight certain values. _______

D. Perform the following operations as indicated.

1. Convert the decimal number 73 into its equivalent binary number.

2. Convert the binary number 10101110 into its equivalent decimal number.

3. Add the binary numbers 101101 and 111001.
4. Subtract the binary number 11001 from the binary number 111010.

52