BCS-011 • Block 3: Productivity Tools & Internet Essentials
Unit 7: Spreadsheets, Formulas, Functions & Charts
Techniques for data modeling and analysis using spreadsheet software. Covers absolute vs relative cell references, mathematical, statistical, and logical functions (IF, VLOOKUP, SUMIF), and dynamic chart creation.
Key Concepts Covered
- Cell Referencing: Relative, Absolute, and Mixed
- Mathematical & Statistical Functions
- Logical Functions (IF, AND, OR) & Lookup (VLOOKUP, XLOOKUP)
- Data Sorting, Filtering, and Conditional Formatting
- Chart Types (Bar, Line, Pie) and Visual Data Analysis