Page 122 - TP_V5.1_C7_fb
P. 122
Assignments
Chapter 1: Number System
1. Given are the steps for converting a decimal number to a binary number in an incorrect sequence.
Determine and rewrite the correct sequence.
(i) Divide the quotient obtained again by 2 and note down the resulting quotient and remainder.
(ii) Note down the quotient and the remainder.
(iii) Divide the decimal number by 2 (the base of the binary number system).
(iv) List the last quotient and all the remainder (moving from bottom to top). You have your
binary number.
(v) Repeat the procedure till you reach a quotient less than 2.
2. Rihan asks his Aunt Mira her age. Mira told him “101011” and a clue binary. What is Mira’s age in
Decimal number system.
3. Guess my birthdate. I was born in the 9th month of the year; my date of birth is “10111” in binary.
4. Riya is trying to convert her age from a decimal number to a binary number. If Riya is 12 years
old, how can she express her age in binary? Explain the steps you would take to convert 12 from
decimal to binary.
5. Two robots in a factory communicate using binary numbers. If Robot A sends the message (1101)2
and Robot B responds with (1010)2, what is the result of adding both messages in binary? Show
how binary addition works and provide the result in both binary and decimal form.
Chapter 2: Advanced Features of Excel
1. Sorting a Student Data Table
Roll No. Name Class Marks
101 Arun VII 85
102 Sneha VII 92
103 Ravi VII 78
104 Ria VII 88
Write steps to sort the names of students based on their marks in descending order in Excel.
2. Javisha has prepared her class marksheet in Excel for different subjects, how would she filter the
data to display only the students who scored above 90 marks in Math?
3. Nimisha has sorted a list of students’ roll numbers in ascending order. Now, she wants to sort
them by their last names without changing the roll number order. Which Excel feature should
she use?
120 Premium Edition-VII

