worksheet CLASS 7

 

CLASS 7 WORKSHEET

 

1.    Convert decimal number into their binary equivalents

i)               245  -  11110101

ii)           80-   1010000

2.    Convert binary number into their decimal equivalents

i.                11101- 29

ii.            010101- 21

3.                        Write the use of the following functions in excel.

·     product (range)- Multiplication

·     Today()- Date and Time

·     Sort (Number)- Sorts range in ascending or descending order

·     Upper()- uppercase

·     lower()- lowercase

 

 

 

 

 

 

1	ACTIVECELL
2	AUTOFILL
3	CELL
4	FUNCTIONS
5	WORKBOOK
6	WORKSHEET
7	FORMULABAR
8	CELLADDRESS
9	LABEL
10	FILE
11	CELLGRID
12	DRAG
13	FILLDOWN
14	SHEETTABS
15	AUTOSUM
16	FILLRIGHT
17	FORMULA
18	ROW
19	HEADINGS
20	COLUMN