Lesson 1: Number System
1. The base of Binary number System is ------( 2 )
2.The base of ----------system is 10 ----(Decimal number system)
3.octal number system consists of ------------- digits.(8 digits)
4.In Binary addition , 1+ 1 is equals to -----10 (0 is the result and 1
is carry)
5. -Binary number system is understood by the computer system.
6. ---------- uses 16 symbols to represent number.(Hexa decimal number
system)
7.In Binary subtraction , 1-1 is equals to -----0
8. 0 - 1 with resprective binary subtraction ------ 1 with 1(1 is the
borrow)
9. Who introduced the concept of zero (Arya bhat)
10. A converts the decimal number to its binary equivellent.
11. In binary multiplication , 1x1 is equlast to ----------1
12. To convert decimal number to Binary number, divide the number by ----
-----2
13. To convert decimal number to octal number, divide the number by ----
---- 8
14. To convert decimal number to hexa number, divide the number by ------
16
15. Bit means either 0 or 1
16. Nibble means 4 bits
17. Byte meabs 8 bits or 2 nibbles
18. Lovelylace is the first compueter programmer.
Lesson 2: Formulas and functions
1. The cell address in a formula is also called Cell reference
2. A formula always begins with an = sign
3. Formulas are used to perform calculations
4.The cell address in a formula , that does not change on coping is
considered as -Absolute cell reference
5.The cell address in a formula , that does change on coping is
considered as ---- relative cell reference
6. ------ are input to the functions which accepts values as number or
text.
=sum(5,6) , =max(a4,b5,c6)
7.A function must be followed by opening and closing ----Parenthesis----
---
8. when a formula is using more than one operator that formula we call it
as Compound Formula
9. in excel Name box showes the current cell address.
10. maximum value in the list ---- =max()
12. =min() 13. =power() 14.=average() 15. Ctrl+C
16. Ctrl+V
17. ctrl+x
18. range operator symbol(:)
A4:z4
19.# div/0 ( when a number is divided with zero)
20. #### (when the column width is less and the data is more)
21. #value error(when the formula contains invalid data)
=sum(4,5,9,'ramu')
22. # name error : no valid cell reference
23. = Today() ---> we can see the date
24. =now() ---> date as well as time
23. =day(today())-- getting day
24. =month(today()) -- getting month
25. =year(today()) --- getting year
Lesson 3: Excel as database
1. --Database------ is a collection of information related to particular
subject.
2. Database consists fields and records
3. A field is a column with in database, that contains only one type of
data.
sno sname comp maths social
4. record : a row in a database is callled
5. sorting : Arranging the data either in ascending or descending order.
Data---> sort and filter
6. which feature allows to see particular data and hide remaining data --
-- filter
7. which feature restricts the cell data entry --- validity
8. Which feature provides an easy way to enter and display a record. ----
--------form
Lesson 4: Advanced features of excel (charts)
1. ------------is an effective way to represent the data in pictorial
manner.(chart)
2.In a chart , ---Data serires----- are the bars or slices that show data
value.
3. -Legend---- is a key that is used to identify the colors ,or patterens
or symbols assigned to series
4. ----Bar---- chart displays data in the form of long rectanglur rods.
5. vertical axis another name --------- Y-axix or value axis
6. Horizontal axis name ----X-axis or catogery axis.
