Data Entry & Formatting

45 min4 lessons

Lessons

4 sheets:

Sheet Data Types

A column: mix of real numbers and numbers-stored-as-text (left-aligned) for the ISNUMBER/ISTEXT exercise
B column: real dates and dates-stored-as-text
C column: TRUE/FALSE booleans
D1 note: "Formula bar + alignment se pehchano — kaunsa asli number/date hai?"

Sheet Number Formats

A1:A6 raw unformatted numbers (including a large one like 12500000 for the lakh/crore exercise and a negative one)
No custom format applied yet — students apply ##,##,##0 and the color/condition codes themselves

Sheet Conditional Formatting

A1:B31 — 30 rows of Region, Sales dummy data, unformatted, for Highlight Rules / Data Bars / Color Scales / formula-rule practice

Sheet Tables

A1:C51 — 50 rows of Product, Category, Amount as a plain range (not yet a Table) for the Ctrl+T exercise

1. Cell left-aligned hai lekin number jaisa dikh raha hai — sabse pehla shaq kya hoga?

Yeh number text ke roop me store hai

2. Boolean TRUE internally kaunsa number hota hai?

3. Custom format `##,##,##0` kis grouping style ke liye hai?

Indian lakh/crore numbering

4. Percentage format lagane se pehle value kaisi honi chahiye?

Already decimal form me (jaise 0.85, 85 nahi)

5. Kaunsi CF type "heatmap" jaisa poora range dikhati hai?

Color Scales

6. CF rules me kaunsa checkbox neeche wale rules ko skip karta hai?

Stop If True

7. Table banane ka shortcut kya hai?

Ctrl + T

8. Table[@Column] ka matlab kya hai?

Same row ka us column ka value

9. Table ke Total Row me Sum choose karne se kaunsa formula lagta hai?

SUBTOTAL (filtered rows ko sahi handle karta hai)

10. Table ko normal range banane ka option kahan milta hai?

Table Design tab → Convert to Range