Spreadsheet - Recap from Class 6
Definition
Definition: A spreadsheet is a computer application that helps us store data and perform calculations on it.
Examples
- Microsoft Excel
- LibreOffice Calc
- Google Sheets
Already learned in Class 6
- Creating a spreadsheet and inserting data.
- Inserting and deleting rows and columns.
- Using min, max, sum, count and average functions.
Graphs and Charts
Definition
Definition: Data in its raw form cannot convey much information. Charts and graphs represent data visually so it becomes easy to understand.
Types of Charts (from data)
- 1
Line Chart: Shows changes and trends over time, e.g. temperature across a week.
- 2
Bar Chart: Compares values side by side, e.g. marks of different students.
- 3
Pie Chart: Shows how parts make up a whole, e.g. how you spend your day.
Sorting and Filtering
- 1
Sorting: Arranges data in an order - ascending (small to large, A to Z) or descending (large to small, Z to A) - making it easier to read and compare.
- 2
Filtering: Shows only the rows that match a condition and hides the rest - useful with large tables.
Logical Functions
- 1
IF: Returns one result when a condition is true and another when it is false, e.g. IF(marks>=40, "Pass", "Fail").
- 2
SUMIF: Adds only the values that meet the given condition.
- 3
COUNTIF: Counts only the cells that meet the given condition.
