Apply Built – in Functions and Formulas

Task: Apply Built – in Functions and Formulas
No	Steps
C2.1 Apply Built – in Functions and Formulas
01	Open spreadsheet package
02	Create or open exiting Workbook
03	Type the following data A B C D E 1 Student Name Subject 1 Marks Subject 1 Marks Subject 1 Marks Average 2 Saman 55 45 78 3 Kamal 85 68 54 4 Amal 65 78 64
04	Place the cell pointer in the cell where you want the result (E2)
05	Click formula ribbon
06	Click insert function tool
07	Select a function 'Category' (Statistical)
08	Select a function (Average) àOK
09	Type cell addresses(B2:D2) àOK
10	Copy formula other cell
C2.2 Apply user define Functions and Formulas
01	Open or create workbook
02	Click a worksheet
03	Type the following data A B C D E 1 Student Name Subject 1 Marks Subject 1 Marks Subject 1 Marks Average 2 Saman 55 45 78 3 Kamal 85 68 54 4 Amal 65 78 64
04	Place the cellpointer in the cell where you want the result (E2)
05	Type =average(B2:D2)
06	Press enter key on the key board
07	Copy formula other cell