Spreadsheet tips for grading

Various spreadsheets have some lesser known formulas or functions that teachers can use for grading. It is not necessary to install or buy extra third-party apps or plug-ins for these features, but it does take some understanding of some intermediate-level spreadsheet syntax that many teachers have never been taught in their teacher training programs. I use these myself, and for the more complex ones, at the end of each semester as I calculate grades, I find myself having to look online again for instructions on some of these. So for my sake, and for other teachers, I have created this guide to help you.

$pi=frac{3}{4}sqrt{3}+24int_{0}^{1/4}{sqrt{x-x^{2}}dx}$