Spreadsheets - Data + Formula [Class 8 Ganita Prakash Part 2] - Spreadsheets

part 2 - Spreadsheets - Spreadsheets - Chapter 5 Class 8 - Tales by Dots and Lines (Ganita Prakash II) - Class 8 (Ganita Prakash - 1, 2 & Old NCERT)
part 3 - Spreadsheets - Spreadsheets - Chapter 5 Class 8 - Tales by Dots and Lines (Ganita Prakash II) - Class 8 (Ganita Prakash - 1, 2 & Old NCERT) part 4 - Spreadsheets - 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

SpreadsheetsSuppose we have this big data We need to find Total Marks & Average marks scored by each student But, data is so big, it will take a lot of time How do we do this? We can put this data into a spreadsheet software like MS Excel or Google Sheets We have put this data here – https://docs.google.com/spreadsheets/d/1UEbOLUF_jUuKR74N-bAb1vcaHjTuN0wqzn15KfSDW2M/edit?gid=0#gid=0 And, it looks like Understanding the Grid A spreadsheet is basically a giant digital notebook. Columns go up and down and are labeled with letters (A, B, C, D...). Rows go left to right and are labeled with numbers (1, 2, 3...). Cells are the small individual boxes where columns and rows meet. We name them by combining the column letter and row number (for example, A1 or C4). Let’s do some questions now

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.