📊 Day 01 : Excel Orientation & Essential Formulas
| A (Quantity) | B (Price) | C (Tax) | |
|---|---|---|---|
| 1 | 10 | 150 | 15 |
| 2 | 5 | 300 | 30 |
| 3 | 2 | 1200 | 120 |
1. Spreadsheet Coordinates : Columns, Rows and Operators
🔍 Concept
Excel stores data in columns (A, B, C...) and rows (1, 2, 3...). Every formula starts with an equals sign (=). You can perform standard arithmetic (+, -, *, /) and use ranges (A1:B3) inside functions. Cell references update automatically when you copy formulas — this is called relative referencing.
Excel stores data in columns (A, B, C...) and rows (1, 2, 3...). Every formula starts with an equals sign (=). You can perform standard arithmetic (+, -, *, /) and use ranges (A1:B3) inside functions. Cell references update automatically when you copy formulas — this is called relative referencing.
🧪 Concept Checks: Basic Formulas
Q1. Calculate the product of A2 and B2.
Q2. Sum the quantities in cells A1, A2, and A3 using basic addition (+).
Q3. Subtract tax C1 from price B1.
Q4. Divide price B2 by quantity A2.
Q5. Calculate total price including tax for item 3 (A3 * B3 + C3).
🛠️ Professional Practice Tasks
Task 1 (Aggregate Quantity): Calculate the sum of all quantities from A1 to A3 using the SUM function.
💻 Pure Coding Interview Questions
Q1. Write the formula to calculate the average price of items 1, 2, and 3 using the AVERAGE function.
📊 Day 01 Executive Summary
Every Excel formula starts with
=. Cell references like A1 are the building blocks of all spreadsheet logic. Basic operators (+, -, *, /) combined with functions like SUM() and AVERAGE() allow you to build powerful calculations across ranges of data.