# Microsoft Excel

This section will make your ICT practicals in Microsoft Excel a bit easy!

 Function Syntax Example Sum =sum(startvalue:endvalue) =sum(A1:G1) Average =Average(startvalue:endvalue) =Average(A1:G1) Max =Max(startvalue:endvalue) =Max(A1:G1) Min =Min(startvalue:endvalue) =Min(A1:G1) count (for nos.) =count(startvalue:endvalue) =Count(A1:G1) count (for text) =countA(startvalue:endvalue) =CountA(A1:G1) Integer =Int(value) =Int(25.789) -> 25 Round =Round(value,decimal place) =Round(35.6782,2)-> 35.68 IF =IF(value1,value2,criteria) =IF(D2>50,”A”,”B”) countif =countif(range,criteria) =countif(\$A\$1:\$A\$10,A1) sumif =sumif(range,criteria,sum range) =sumif(\$A\$!:\$A\$10,A1,\$B\$1:\$B\$10) nestedIF =IF(criteria,value1, IF(criteria,value2, IF(criteria,value3,value4))) =IF(D2>80,”A”, IF(D2>70,”B”, IF(D2>60,”C”,”D”))) Vlookup =Vlookup(loopup value,Table array,cot index no.Range Lookup) =Vlookup(A2,sheet2\$A\$1:\$B\$10,1)
1. How to insert header and footer?
• To insert header and footer:
• Click on insert
• Click on header and footer
• Select blank 3 columns
• Insert name, center no., roll no., date and time, Page no., file name, file path
2. How to display function?
• To display function, press control and Alt keys together
3. Page setup
• Orientation – Portrait, Landscape
• Margins – Top, Bottom, Left and Right
• Papersize – A4
• Insert row, Insert column, delete row, delete column
• Printouts – 1) For specific range
• e.g. A1 to D15
• Select range A1 to D15
• Click on File, click print active sheet
• select print, select print selection