SRI SRI RAVISHANKAR VIDYA MANDIR, BONGAIGAON
HALF YEARLYEXAMINATION ,2024-25
SUBJECT: COMPUTER
CLASS :VII
DURATION :1 Hr 30 min MAX. MARKS :40
1. Fill in the Blanks:- 1 X 5=5
a) To filter data in Excel, click the _______ tab.
b) In Binary addition, 1 + 0 equals _________.
c) The base of Octal number system is _________.
d) _______ is a tool for summarising and presenting the data.
e) Consolidate function is available in the _______ tab.
2. Calculate and write the results:- 2.5 X 2=5
a) (1100101)2 + ( 101010)2
b) (101011)2 – (101)2
3. Explain the number system and write its uses. 3
4. Convert (10010)2 to decimal number system. 3
5.In how many ways can you sort data? 3
6. Define data consolidation. 3
7. Define custom filter in MS Excel. 2
8.Write the steps to convert a binary number to decimal number. 3
9. Write True or False:- 1 X 5=5
a) The decimal number system consists of 10 digits.
b) 1 X 0 =0 in binary number system.
c) The Hexadecimal number system has base 16.
d) You can apply filters to only one range on a worksheet at a time.
e) To sort data , we use data tab.
10. What is the difference between sorting and filtering data? 4
11. State the use of grouping worksheets in Excel. 4
XXXXXXXXX
