🎨 Day 02 : Formatting, Sorting & Filtering
| A (Product) | B (Rating) | C (Price) | |
|---|---|---|---|
| 1 | Phone | 4.5 | 50000 |
| 2 | Book | 4.8 | 500 |
| 3 | Laptop | 4.2 | 80000 |
1. Grid Sorting and Filtering : Formatting and Data Ordering
🔍 Concept
Excel lets you sort data A–Z, Z–A, or by custom rules on any column. AutoFilter adds dropdown arrows that let you filter rows by value, color, or formula criteria. Number formatting (currency, percentage, decimal places) does not change the underlying value — it only affects display. Conditional Formatting applies color rules based on cell values.
Excel lets you sort data A–Z, Z–A, or by custom rules on any column. AutoFilter adds dropdown arrows that let you filter rows by value, color, or formula criteria. Number formatting (currency, percentage, decimal places) does not change the underlying value — it only affects display. Conditional Formatting applies color rules based on cell values.
🧪 Concept Checks: Basic Formulas
Q1. Find the total price of all items in column C using SUM(C1:C3).
Q2. Find the average rating of items in column B using the AVERAGE function.
Q3. Count the number of items listed by counting ratings in column B using COUNT.
Q4. Find the maximum price in column C using MAX.
Q5. Find the minimum rating in column B using MIN.
🛠️ Professional Practice Tasks
Task 1 (Total Rating): Calculate the sum of all ratings from B1 to B3.
💻 Pure Coding Interview Questions
Q1. Write a formula to calculate the average of the ratings in B1, B2, and B3.
📊 Day 02 Executive Summary
Sorting (Data → Sort) and filtering (Data → AutoFilter) are Excel's primary data exploration tools.
MAX() and MIN() help you quickly find extremes. Conditional Formatting visually highlights outliers — making it easy to spot trends without formulas.