Page 70 - Computer - 7

WORKSHEET-1
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 number 12 in hexadecimal number system is denoted by the symbol ______.
(a) D (b) C (c) E (d) F

4. The operators that combine two expressions involving relational operators are ______ operators.
(a) Logical (b) String (c) Arithmetic (d) Assignment

5. 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 _________ lets you copy formatting from one cell to another cell.
2. The values on which operators perform tasks are called _________.

3. A compact chart that visualises a row or column of data and fits inside a single cell is _________.
4. The starting of text at a position away from the margin in Python is called _________.

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

C. Write ‘T’ for True and ‘F’ for False statement.
1. A Radar chart represents data in the form of a circle divided into various sectors. _______

2. The Logical operator OR returns the value False if any one of the expressions
evaluates to False. _______
3. The base of a number system is also called its Radix. _______
4. Every if statement must have a corresponding else statement. _______

5. 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. Divide the binary number 101010 by the binary number 111.

5. Subtract the binary number 11001 from the binary number 111010.

68