Handling a mark sheet with LibreOffice

Here is a useful mark sheet:

https://drive.google.com/file/d/0B_ZD8gM2F8i_UkRIOC1FQnVfMGc/edit?usp=sharing

1. It gives the average marks, highest marks, number of passes and so on.
2. It also ranks the marks and puts the fails in brackets. 
3. Type the marks in the yellow cells.
4. Please change the "% of passing marks / max. marks" if necessary.

License of this mark sheet / Summary of License (5 Feb 2014)

Creative Commons — Attribution 3.0 Unported — CC BY 3.0
http://creativecommons.org/licenses/by/3.0/