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 Take short quiz All Quiz and Worksheets

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 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.