Visit and subscribe theCPAtube. Complete all HBL assignments on SLS & GC.
Master Your Spreadsheet Skills
MS-Excel is a powerful spreadsheet software in the MS-Office suite used in every workplace to perform calculations and data management or analysis.
You can analyse data, create charts, auto-recalculate answers, organise data and anything to do with numbers with MS-Excel.
It is also powered by a library of functions that can help you calculate sets of data very quickly. Basic examples:
the SUM function calculates the total sum of a set of data.
the AVERAGE function calculates the average value of a set of data.
the MAX function calculates the largest value in a set of data.
the MIN function calculates the smallest value in a set of data.
...
There is a huge function library waiting to be explored
MS-Excel has a feature to auto-recalculate the values in any cell containing formulas.
Also, charts generated from cells of data will regenerate themselves with any data changes.
Click on the following link to check out the summary for all MS-Excel Skills.
Ready For GCE N-levels?
Check if you have these MS-Excel skills
[Success Criteria upcoming]
Study this Youtube tutorial to watch how to solve the MS-Excel question using MS-Excel 2010.
Practice Makes Perfect