Sum and Average in Spreadsheets

Last updated at August 14, 2026 by

Sum and Average in Spreadsheets - Formula [with Examples] - Class 8 - Spreadsheets

part 2 - Sum and Average in Spreadsheets - Spreadsheets - Chapter 5 Class 8 - Tales by Dots and Lines (Ganita Prakash II) - Class 8 (Ganita Prakash - 1, 2 & Old NCERT)
part 3 - Sum and Average in Spreadsheets - Spreadsheets - Chapter 5 Class 8 - Tales by Dots and Lines (Ganita Prakash II) - Class 8 (Ganita Prakash - 1, 2 & Old NCERT) part 4 - Sum and Average in Spreadsheets - Spreadsheets - Chapter 5 Class 8 - Tales by Dots and Lines (Ganita Prakash II) - Class 8 (Ganita Prakash - 1, 2 & Old NCERT)

Remove Ads Take short quiz All Quiz and Worksheets

Transcript

Sum and Average in SpreadsheetsInstead of using a calculator, we can type a formula into a cell, and the computer does the math instantly. We tell the computer which cells to look at by using a range, written as Start : End - =SUM() adds everything together. =AVERAGE() finds the mean. There are 22 students in the class list. Because Row 1 is used for the header titles, the students' data takes up Rows 2 through 23 Let’s look at some examples We use the same spreadsheet as before Sum of all marks for Farooq is Average Marks scored by Pankaj is Total Marks scored by Ganesh is Average Marks scored in Maths is

CA Maninder Singh's photo - Co-founder, Teachoo

Made by

CA Maninder Singh

CA Maninder Singh is a Chartered Accountant with 16+ years of practical experience and 20+ years of teaching experience. At Teachoo, he simplifies Accounts, Tax and GST with step-by-step examples so students can apply concepts confidently in exams and real life.

For an uninterrupted learning experience, students can use Teachoo Black to remove ads and focus better.