Chapter 9 Day 6 Class11 Unit 3 | Performing Calculation on Data | COMA & COMS | Semester 1

UNIT III Data Visualization using Spreadsheet
Performing Calculations on Data
Naming groups of data, creating formulas to calculate values (e.g., SUM, AVERAGE, COUNT), summarizing data that meets specific conditions (e.g., AVERAGEIF, COUNTA, COUNTBLANK, COUNTIFS, SUMIF, IFERROR etc), finding and correcting errors in calculations.

Changing Workbook Appearance
Formatting Cells, defining styles, workbook themes and table styles, making numbers easier to read, changing the appearance of data based on its value, adding images to worksheets.

Data Analysis and Manipulation
Limiting data appearance on screen, working with text functions for data cleaning, Splitting and combining data, Data normalization and standardization, working with ranges and named ranges, conditional formatting, data validation and error checking, using logical functions (e.g., IF, AND, OR), sorting and filtering data.

Class 11 Computer science
Class 11 Computer application
1st semester class 11 Computer science
Class 11 Computer science chapter 1
Computer Science
Class 11 West Bengal board Computer Science chapter 1
WBBHSE class 11 Computer science
WBBHSE semester 1 Complete science
#spreadsheet #excel #science #students #wbbhse #hs #class11 #computerscience #computerapplications #cs
#computer

Playlists for New Syllabus Semester 1
✅ Basic Computer Organization | Class 11 Unit 1 | Chapter 1
https://studio.youtube.com/playlist/P...

✅ Concepts of Software | Class 11 Unit 1 | Chapter 2
https://studio.youtube.com/playlist/P...

✅ Computer System and Organization | Class 11 Unit 1 | Chapter 2
https://studio.youtube.com/playlist/P...

✅ Number System Class11 Semester 1 | Class 11 Unit 1 | Chapter 3
https://studio.youtube.com/playlist/P...

✅ Boolean Algebra | Class 11 Unit 1 | Semester 1 (New Syllabus) Chapter 4
https://studio.youtube.com/playlist/P...

✅ Boolean Algebra Class 11 WBCHSE (OLD Syllabus)
https://studio.youtube.com/playlist/P...




Unit 2
✅ Programming Fundamentals | Class 11 Unit 2 | Chapter 5
https://studio.youtube.com/playlist/P...

Unit 3
✅ Data Visualization using Spreadsheet | Class 11 Unit 3
https://studio.youtube.com/playlist/P...

For More Details:
Contact:
SUKANTA GHOSH
Facebook Page:   / gcadebi  
Email: [email protected]