EVENTS
CONVENT HIGH SCHOOL
70,LALA LAJPAT RAI COLONY,
BAGH DILKUSHA
SLOT 1 COMPUTER REVISION QUESTIONS
CLASS-7
1.
__________Introduced
the concept of zero.
a. Aryabhat( √) b.Charles babbage
2. For
converting decimal numbers into binary number ,divide the number by ________.
a. 10 b.2(
√)
3. In Binary
multiplication, 1*1= ?
a. 1( √) b.0
4. A computer
understands ___________language,
a. Human b.Binary(
√)
5. ________Function
finds the largest number in a range.
a. MIN b.MAX(
√)
6. ______referene
is the combination of relative and absolute referece.
a. Hybrid b.Combined(
√)
7. _____
returns the remainder when the number is divided by the divisor
a. Power( √) b.EXP
8. _____
Function returns square root of a number.
a. SQRT ( √) b.Square
9. _____ is a
row in the data base that contains data about one object or a person.
a. Field b.Record(
√)
10. A ______ is
a dialog box which offers a simple way for entering and displaying a complete
row of information or record.
a. Form( √) b.Database
11. The
_______feature of MS Excel enables you to have a look at only those records
which you wish to dosplay.
a. Sorting b.Filter(
√)
12. _______Restricts
the cell entries within a given range.
a. Filter b.Data
Validation( √)
1. The decimal
number system contains (0-9) digits.
a. 0-10 b.0-9( √)
2. The face
value of a digit is dependent on its Position in the number.
a. Filled b.Position(
√)
3. The
Hexadecimal number system contains 16 digits (0-9) and (A-F)
a. (0-9) &
(A-F) ( √) b. (1-10) & (A-E)
4. The Binary
number is based only on two numbers 0 and 1
a. 0 & 1
(√) b.0 & 10
5. Basic formulas
are the ones that have only one operator in the formula
a. Standard b.Basic( √)
6. Cell
reference
is the cell address present in the formula
a. Cell
reference( √) b.absolute cell reference
7. Excels
displays three worksheet by defalt.
a. Four b.Three ( √)
8. Except edit
no other operation can be defined on
text.
a. Crop b.Edit( √)
9. Data base refers to a
collection of data which is related to particular subject.
a. Data base (
√) b.Data sharing
10. Field is a column
in a data base table which consists of only one type of data.
a. Base b.Field( √)
11. Field name is a column
label for the field in a data base.
a. Field name(
√) b.Field database
12. Data
validation
is required for restricting the cell entries within a given range.
a. Data
validation( √) b.Data interpretation
C.Write True and False of the
following:-
1. The octal
number system contains 10 digits
a. [False] ( √) b.[True]
2. 1 multiplied
with 0 in binary equals to 1
a. [False] b.[True] (
√)
3. Charles Babbage
introduce the concept of 0
a. [Fale] ( √) b.[True]
4. The number
in octal number are 1 to 7
a. [False] ( √)
b.[True]
5. Only simple
calculation can be easily performed with the help of functions
a. [False] ( √)
b.[True]
6. Variables
are the numbers or text values that do not change
a. [False] b.[True] (
√)
7. X+y/z is an
example of basic compound formula
a. [False] b.[True] (
√)
8. INT()
function returns numbers rounded off the nearest integer
a. [False] b.[True](
√)
9. The field
name appears in multiple rows
a. [False] ( √) b.[True]
10. A database
is a dialog box which offers a simple way for entering and displaying a
complete row of info
a. [False] ( √)
b.[True]
11. Searching is
the process of arrangement of data in the ascending or descending order in a
worksheet
a. [False] ( √)
b.[True]
12. The filter
features if MS Excel enables you to have a look at only those records which
wish to display
a. [False] b.[True] (
√)
D.Answer the following questions :-
Que-1
What do you understand by database?
Ans-1
Database refers to a collection of data which related to a particular subject.
Ans-2
Sorting is the process of arrangement of data in the ascending or descending order in a worksheet.
Ans-3Formula
are used for doing calculations which involve addition ,subtraction ,division
and multiplication. It develops a relationship between
multiple cells.
Ans-4 For converting a decimal number into its equivalent binary
number
Follow the steps given below
1.Divide the decimal number by 2
2.Note down the remainder and then
divide the quotient again by 2
3.Continue repeating step 2 until
the quotient becomes Zero.
Ans-5 Formula are used for doing
calculations which involve addition, subtraction, division and multiplication.It develops a relationship between
multiple cells.
