Show the average marks in other subjects after the last row by typing - Spreadsheets

part 2 - Question 3 - Page 113 - Spreadsheets - Chapter 5 Class 8 - Tales by Dots and Lines (Ganita Prakash II) - Class 8 (Ganita Prakash - 1, 2 & Old NCERT)

Remove Ads Share on WhatsApp

Transcript

Question 3 - Page 113 Show the average marks in other subjects after the last row by typing the appropriate formulae.To get the averages for the rest of the subjects, you would go to the empty row underneath the last student (Row 24) and type: English: =AVERAGE(D2:D23) Maths: =AVERAGE(E2:E23) Social Science: AVERAGE(F2:F23)

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

Made by

CA Maninder Singh

CA Maninder Singh is a Chartered Accountant for the past 16 years. He also provides Accounts Tax GST Training in Delhi, Kerala and online.