Training By Himanshu

Blog

  • ITR-2 Filing Guide for FY 2025-26: Step-by-Step Process, 26AS/AIS Reconciliation, and Old vs New Regime Tax Examples

    1) What is ITR-2 and who should file it

    ITR-2 is meant for individuals and Hindu Undivided Families (HUFs) who do not have income from business or profession but have any of the following:

    • Capital gains (short-term or long-term)
    • Income from more than one house property
    • Foreign income or assets
    • Being a director in a company
    • Investments in unlisted equity shares

    If your only income is salary/pension, one house property, and total income ≤ ₹50 lakh, you may be eligible for ITR-1 instead — otherwise, use ITR-2.

    2) Documents to collect before filing

    • PAN & Aadhaar (linked)
    • Bank account details (IFSC, account number)
    • Form 16 from your employer
    • Form 16A / TDS certificates (from banks, others)
    • Form 26AS (TDS/TCS summary)
    • AIS (Annual Information Statement) and TIS
    • Bank statements (for savings interest)
    • Home loan interest certificate (if applicable)
    • Broker contract notes / capital gains statement
    • Investment proofs for deductions (80C, 80D, etc.)

    3) Important deadlines

    • For FY 2025-26 (AY 2026-27), the last date for filing (non-audit) is 15 September 2026.
    • Belated return can be filed till 31 December 2026 but with a penalty.

    4) How income is reported in ITR-2

    • Salary → Schedule S
    • House Property → Schedule HP
    • Capital Gains → Schedule CG
    • Other Income → “Income from Other Sources” section
    • Deductions → Schedule VI-A
    • Taxes Paid / TDS → Tax Paid and Verification section

    5) Step-by-step filing process (online)

    1. Login to Income Tax e-filing portal
    2. Go to: e-File → Income Tax Returns → File Income Tax Return
    3. Select Assessment Year 2026-27 and choose ITR-2
    4. Select Prepare and Submit Online (prefilled data) or Upload JSON (offline utility)
    5. Review pre-filled data (salary, TDS, bank interest, etc.)
    6. Fill missing details:
      • Salary from Form 16
      • House property income/loss
      • Capital gains with purchase/sale dates and cost
      • Other income (bank interest, etc.)
      • Deductions under Chapter VI-A
    7. Verify TDS and taxes paid with Form 26AS/AIS
    8. Validate the form
    9. Submit and e-verify instantly (Aadhaar OTP, Netbanking, DSC, etc.)

    6) How to use Form 26AS & AIS

    Form 26AS shows all tax credits in your PAN — TDS from employer/bank, TCS, advance tax, and self-assessment tax.
    AIS shows a wider range of financial transactions — stock trades, interest income, property purchases, mutual fund investments, etc.

    Steps to reconcile:

    1. Download Form 26AS from the e-filing portal (redirects to TRACES)
    2. Download AIS/TIS from the portal
    3. Cross-check:
      • Salary TDS in Form 16 = Salary TDS in 26AS
      • Bank interest TDS = TDS in 26AS
      • Capital gains transactions in AIS match broker reports
    4. If mismatch — contact deductor to revise TDS statement or give feedback in AIS

    7) Example calculation — FY 2025-26 (Old Regime)

    Rahul has:

    • Salary: ₹12,00,000 (TDS ₹90,000)
    • Let-out property: rent ₹2,40,000, municipal tax ₹24,000, loan interest ₹1,20,000
    • Bank interest: ₹30,000 (TDS ₹3,000)
    • LTCG (listed shares after 23 Jul 2024): ₹1,50,000
    • Deduction 80C: ₹1,50,000

    House property income:
    Gross rent 2,40,000 − Municipal tax 24,000 = 2,16,000
    Less 30% standard deduction: 64,800 → 1,51,200
    Less interest: 1,20,000 → 31,200 taxable

    Total income before CG:
    Salary after standard deduction: 12,00,000 − 50,000 = 11,50,000

    • House property: 31,200
    • Bank interest: 30,000
      = 12,11,200
      Less 80C: 1,50,000 → 10,61,200

    Capital gains:
    LTCG 1,50,000 − Exemption 1,25,000 = 25,000 taxable @ 12.5% = ₹3,125

    Tax:
    Other income 10,61,200 under old slabs = ₹1,30,860
    Capital gains tax = ₹3,125
    Total = ₹1,33,985
    Cess @ 4% = ₹5,359 → ₹1,39,344
    Less TDS ₹93,000 → Pay ₹46,344

    8) Income-wise tax comparison (Old vs New Regime) — FY 2025-26

    Assumptions:

    • Salaried individual, resident, age < 60
    • No capital gains, only standard deduction (₹50,000) in both regimes
    • No other deductions in New Regime except standard deduction
    • Old Regime includes 80C = ₹1.5 lakh deduction
    Total Income (₹)Old Regime Tax (₹)New Regime Tax (₹)
    5,00,0000 (Rebate u/s 87A)0 (Rebate u/s 87A)
    10,00,0001,02,96075,400
    15,00,0002,58,9601,56,000
    20,00,0004,41,6002,88,400

    Incomes above ₹7 lakh in New Regime do not get full rebate — tax savings depend on deductions you can claim in Old Regime.

    9) Common mistakes to avoid

    • Relying fully on pre-filled data without verifying
    • Ignoring AIS entries — they may contain transactions you forgot to report
    • Not splitting capital gains before/after 23 July 2024 for correct tax rate
    • Missing e-verification — your return will be invalid without it
    • Filing in the wrong form (ITR-1 instead of ITR-2)

    Disclaimer

    This guide is for educational purposes only and is based on current tax rules applicable for FY 2025-26 (AY 2026-27). Tax laws can change, and individual circumstances vary. Always verify figures with your own documents and consult a qualified tax professional before filing.

    Featured products

  • 100 Voucher Entry Examples for Service-Based Companies in Tally

    In a service-based company, day-to-day financial activities—like receiving payments, paying expenses, and adjusting accounts—are recorded using vouchers in Tally.ERP 9 or TallyPrime.
    Voucher entries ensure that every business transaction is documented properly for accounting accuracy, GST compliance, and financial reporting.

    There are several types of vouchers in Tally, including:

    • Payment Vouchers – For expenses, purchases, and other outgoing payments.
    • Receipt Vouchers – For recording income, customer payments, or advances received.
    • Journal Vouchers – For adjustments, provisions, or non-cash transactions.
    • Contra Vouchers – For internal cash/bank transfers.
    • Sales & Purchase Vouchers – For billing customers or recording vendor invoices.

    Below is a comprehensive list of 100 sample voucher entries for a service-based company.

    Tally-style ledger entry format with:

    Date | Voucher Type | Debit Ledger | Credit Ledger | Amount | Narration

    We’ll group by type so it’s easier to follow but still have 100 unique entries.

    100 Voucher Entries for a Service-Based Company (Tally Style)

    A. Sales Vouchers – 20 Entries

    01-04-2025 | Sales | Accounts Receivable | Service Revenue | 50000 | Consulting services to ABC Pvt Ltd, Inv#001
03-04-2025 | Sales | Accounts Receivable | Service Revenue | 75000 | Digital marketing to XYZ Ltd, Inv#002
04-04-2025 | Sales | Bank | Service Revenue | 32000 | Design services to Rohan Enterprises, paid immediately
05-04-2025 | Sales | Accounts Receivable | Service Revenue | 125000 | Annual software support to TechWorld, Inv#003
07-04-2025 | Sales | Accounts Receivable | Service Revenue | 15000 | SEO package to WebX, Inv#004
08-04-2025 | Sales | Accounts Receivable | Service Revenue | 20000 | Social media management for Neo Fashions, Inv#005
09-04-2025 | Sales | Bank | Service Revenue | 45000 | Logo & branding for Fresh Foods, paid upfront
10-04-2025 | Sales | Accounts Receivable | Service Revenue | 18000 | Email campaign for Smart Solutions, Inv#006
11-04-2025 | Sales | Accounts Receivable | Service Revenue | 40000 | Consulting fees to GoFast Logistics, Inv#007
13-04-2025 | Sales | Bank | Service Revenue | 22000 | Mobile app UI design project, paid
15-04-2025 | Sales | Accounts Receivable | Service Revenue | 60000 | Market research for Prime Foods, Inv#008
17-04-2025 | Sales | Accounts Receivable | Service Revenue | 35000 | Video editing project for SmartAds, Inv#009
19-04-2025 | Sales | Bank | Service Revenue | 28000 | Website redesign payment from CoolTech
20-04-2025 | Sales | Accounts Receivable | Service Revenue | 42000 | Training session billed to BizGrow, Inv#010
21-04-2025 | Sales | Accounts Receivable | Service Revenue | 55000 | Cloud integration setup to DataLink, Inv#011
23-04-2025 | Sales | Bank | Service Revenue | 38000 | Hosting migration for GreenSoft, paid
24-04-2025 | Sales | Accounts Receivable | Service Revenue | 29000 | API integration billed to AppMax, Inv#012
26-04-2025 | Sales | Accounts Receivable | Service Revenue | 75000 | Annual AMC billed to MegaTrade, Inv#013
28-04-2025 | Sales | Bank | Service Revenue | 44000 | Creative design for BrandX, paid
30-04-2025 | Sales | Accounts Receivable | Service Revenue | 50000 | Digital strategy billed to InnovateCo, Inv#014

    B. Receipt Vouchers – 20 Entries

    05-04-2025 | Receipt | Bank | Accounts Receivable | 50000 | Payment from ABC Pvt Ltd
06-04-2025 | Receipt | Bank | Accounts Receivable | 75000 | Payment from XYZ Ltd
08-04-2025 | Receipt | Bank | Accounts Receivable | 15000 | Payment from WebX
09-04-2025 | Receipt | Bank | Accounts Receivable | 125000 | Payment from TechWorld
10-04-2025 | Receipt | Bank | Accounts Receivable | 20000 | Payment from Neo Fashions
12-04-2025 | Receipt | Bank | Accounts Receivable | 18000 | Payment from Smart Solutions
13-04-2025 | Receipt | Bank | Accounts Receivable | 40000 | Payment from GoFast Logistics
15-04-2025 | Receipt | Bank | Accounts Receivable | 60000 | Payment from Prime Foods
18-04-2025 | Receipt | Bank | Accounts Receivable | 35000 | Payment from SmartAds
19-04-2025 | Receipt | Bank | Accounts Receivable | 28000 | Payment from CoolTech
21-04-2025 | Receipt | Bank | Accounts Receivable | 42000 | Payment from BizGrow
23-04-2025 | Receipt | Bank | Accounts Receivable | 55000 | Payment from DataLink
24-04-2025 | Receipt | Bank | Accounts Receivable | 38000 | Payment from GreenSoft
25-04-2025 | Receipt | Bank | Accounts Receivable | 29000 | Payment from AppMax
27-04-2025 | Receipt | Bank | Accounts Receivable | 75000 | Payment from MegaTrade
28-04-2025 | Receipt | Bank | Accounts Receivable | 44000 | Payment from BrandX
29-04-2025 | Receipt | Bank | Accounts Receivable | 50000 | Payment from InnovateCo
30-04-2025 | Receipt | Bank | Accounts Receivable | 33000 | Payment from AlphaBuild
01-05-2025 | Receipt | Bank | Accounts Receivable | 46000 | Payment from BetaWare
02-05-2025 | Receipt | Bank | Accounts Receivable | 58000 | Payment from VisionSoft

    C. Payment Vouchers – 20 Entries

    05-04-2025 | Payment | Rent Expense | Bank | 25000 | Office rent for April
06-04-2025 | Payment | Internet Expense | Bank | 2000 | April broadband bill
07-04-2025 | Payment | Salaries Expense | Bank | 120000 | April salaries paid
08-04-2025 | Payment | Printing & Stationery | Cash | 1500 | Printing expense
09-04-2025 | Payment | Electricity Expense | Bank | 6500 | Electricity bill
10-04-2025 | Payment | Office Supplies | Cash | 3000 | Office consumables
11-04-2025 | Payment | Travel Expense | Bank | 4500 | Client visit fare
12-04-2025 | Payment | Marketing Expense | Bank | 8000 | Google Ads spend
13-04-2025 | Payment | Software Subscription | Bank | 12000 | Annual Zoom license
14-04-2025 | Payment | Cleaning Expense | Cash | 2200 | Office cleaning
15-04-2025 | Payment | Telephone Expense | Bank | 2500 | Mobile bills
16-04-2025 | Payment | Courier Charges | Cash | 800 | Documents couriered
17-04-2025 | Payment | Repairs & Maintenance | Bank | 5000 | AC repair
18-04-2025 | Payment | Security Charges | Bank | 3500 | Office security
19-04-2025 | Payment | Staff Welfare | Cash | 1500 | Refreshments
20-04-2025 | Payment | Professional Fees | Bank | 20000 | Auditor fee
21-04-2025 | Payment | Subscription Expense | Bank | 1500 | Online tool subscription
22-04-2025 | Payment | Insurance Expense | Bank | 7000 | Office insurance premium
23-04-2025 | Payment | Legal Charges | Bank | 6000 | Contract review
24-04-2025 | Payment | Training Expense | Bank | 9000 | Staff workshop

    D. Journal Vouchers – 15 Entries

    30-04-2025 | Journal | Depreciation Expense | Accumulated Depreciation | 5000 | Depreciation for April
30-04-2025 | Journal | Provision for Tax | Provision for Income Tax | 15000 | Income tax provision
30-04-2025 | Journal | Accrued Income | Service Revenue | 10000 | Services rendered but not yet billed
30-04-2025 | Journal | Prepaid Insurance | Insurance Expense | 6000 | Prepaid adjustment
30-04-2025 | Journal | Interest Receivable | Interest Income | 3000 | Accrued interest on deposit
30-04-2025 | Journal | Rent Expense | Prepaid Rent | 2500 | Rent paid in advance
30-04-2025 | Journal | Bonus Expense | Provision for Bonus | 8000 | Staff bonus provision
30-04-2025 | Journal | Outstanding Expenses | Salaries Expense | 12000 | Unpaid salary provision
30-04-2025 | Journal | Bad Debt Expense | Accounts Receivable | 5000 | Write-off customer dues
30-04-2025 | Journal | Discount Allowed | Accounts Receivable | 2000 | Discount to client
30-04-2025 | Journal | Interest Expense | Interest Payable | 3500 | Loan interest accrued
30-04-2025 | Journal | Bank Charges | Bank | 1200 | Bank service fees
30-04-2025 | Journal | GST Input | Accounts Payable | 4500 | GST adjustment
30-04-2025 | Journal | Advertising Expense | Prepaid Advertising | 3000 | Advance payment for ads
30-04-2025 | Journal | Office Expense | Outstanding Expenses | 2500 | Office expense accrued

    E. Contra Vouchers – 10 Entries

    05-04-2025 | Contra | Bank | Cash | 10000 | Cash deposit in bank
06-04-2025 | Contra | Cash | Bank | 5000 | Cash withdrawn for petty cash
07-04-2025 | Contra | Bank | Cash | 15000 | Cash deposit
09-04-2025 | Contra | Cash | Bank | 8000 | Withdrawal for office use
12-04-2025 | Contra | Bank | Cash | 7000 | Cash deposit
15-04-2025 | Contra | Cash | Bank | 6000 | Withdrawal for petty expenses
17-04-2025 | Contra | Bank | Cash | 12000 | Cash deposit
20-04-2025 | Contra | Cash | Bank | 4000 | Withdrawal for emergency
22-04-2025 | Contra | Bank | Cash | 9000 | Cash deposit
25-04-2025 | Contra | Cash | Bank | 3000 | Withdrawal for petty expenses

    F. Purchase Vouchers – 15 Entries

    06-04-2025 | Purchase | Office Equipment | Bank | 45000 | Laptop purchase
07-04-2025 | Purchase | Furniture | Accounts Payable | 12000 | Chairs purchased on credit
08-04-2025 | Purchase | Software Subscription | Bank | 18000 | Adobe Creative Cloud annual plan
10-04-2025 | Purchase | Office Stationery | Cash | 2500 | Office paper and pens
12-04-2025 | Purchase | Printer | Bank | 8000 | New office printer
14-04-2025 | Purchase | UPS Battery | Bank | 5500 | Battery replacement
15-04-2025 | Purchase | CCTV Equipment | Bank | 22000 | Security cameras purchase
17-04-2025 | Purchase | Coffee Machine | Cash | 6000 | Staff coffee machine
18-04-2025 | Purchase | Whiteboard | Cash | 1500 | Meeting room whiteboard
20-04-2025 | Purchase | Projector | Bank | 18000 | Conference projector
21-04-2025 | Purchase | Mobile Phone | Bank | 25000 | Company mobile for manager
23-04-2025 | Purchase | External Hard Drive | Cash | 4000 | Backup drive
25-04-2025 | Purchase | AC Unit | Bank | 30000 | AC for meeting room
27-04-2025 | Purchase | Website Hosting | Bank | 12000 | Annual hosting plan
29-04-2025 | Purchase | Domain Registration | Bank | 1500 | Company domain renewal

    How to Enter These Vouchers in Tally

    1. Prepare Ledgers Before Entering

    Before you start, make sure you’ve created these ledger groups in Tally → Accounts Info → Ledgers → Create:

    • Assets:
      • Accounts Receivable (Sundry Debtors)
      • Bank (Bank Accounts)
      • Cash (Cash-in-hand)
      • Office Equipment, Furniture, etc. (Fixed Assets)
    • Income:
      • Service Revenue
      • Interest Income
    • Expenses:
      • Rent Expense, Salaries Expense, Electricity Expense, etc. (Indirect Expenses)
      • Marketing Expense, Travel Expense, etc. (Indirect Expenses)
      • Depreciation Expense (Indirect Expenses)
    • Liabilities:
      • Accounts Payable (Sundry Creditors)
      • Provision for Income Tax
      • Provision for Bonus
      • Interest Payable, Outstanding Expenses

    2. Choosing Voucher Type in Tally

    When entering a transaction:

    • Sales → F8: Sales (DR customer / CR Service Revenue)
    • Receipt → F6: Receipt (DR Bank/Cash / CR Customer)
    • Payment → F5: Payment (DR Expense / CR Bank/Cash)
    • Purchase → F9: Purchase (DR Asset/Expense / CR Bank/Creditors)
    • Journal → F7: Journal (Any adjustment that’s not cash/bank)
    • Contra → F4: Contra (Cash-Bank transfers within the business)

    3. Steps for Entering a Voucher in Tally

    Example: Sales Entry — 01-04-2025

    1. Go to Gateway of Tally → Accounting Vouchers → F8 Sales
    2. Enter Date: 01-04-2025
    3. Party’s A/c Name: Select Accounts Receivable (or customer ledger)
    4. Sales Ledger: Service Revenue
    5. Amount: 50000
    6. Narration: Consulting services to ABC Pvt Ltd, Inv#001
    7. Press Ctrl + A to save.

    Example: Receipt Entry — 05-04-2025

    1. Go to F6: Receipt
    2. DR Ledger: Bank → ₹50,000
    3. CR Ledger: Accounts Receivable → ₹50,000
    4. Narration: Payment from ABC Pvt Ltd
    5. Save.

    Example: Payment Entry — 05-04-2025

    1. Go to F5: Payment
    2. DR Ledger: Rent Expense → ₹25,000
    3. CR Ledger: Bank → ₹25,000
    4. Narration: Office rent for April
    5. Save.

    Example: Journal Entry — 30-04-2025

    1. Go to F7: Journal
    2. DR Ledger: Depreciation Expense → ₹5,000
    3. CR Ledger: Accumulated Depreciation → ₹5,000
    4. Narration: Depreciation for April
    5. Save.

    Example: Contra Entry — 05-04-2025

    1. Go to F4: Contra
    2. DR Ledger: Bank → ₹10,000
    3. CR Ledger: Cash → ₹10,000
    4. Narration: Cash deposit in bank
    5. Save.

    4. Best Practice Tips

    • Always check DR = CR before saving.
    • Keep narrations clear for future reference.
    • Use Alt + 2 in the voucher screen to duplicate similar entries.
    • For bulk entries, first create all ledgers so voucher entry is faster.

    Impact on Tally Reports

    Voucher TypePrimary EffectReports Impacted
    SalesIncreases revenue & debtor balanceP&L (Income ↑), Balance Sheet (Debtors ↑)
    ReceiptsIncreases cash/bank, reduces debtor balanceBalance Sheet (Cash/Bank ↑, Debtors ↓)
    PaymentsIncreases expense or asset, reduces cash/bankP&L (Expense ↑) or Balance Sheet (Assets ↑, Cash ↓)
    PurchasesIncreases asset or expenseBalance Sheet (Asset ↑) or P&L (Expense ↑)
    JournalAdjusts balances without cash/bankDepends on accounts affected
    ContraMoves funds within businessOnly Balance Sheet (Cash/Bank movement)

    💡 Tip for Practice:
    If you enter all 100 of these in Tally Education / TallyPrime sample company, by the end:

    • P&L will show your Service Revenue vs all expenses.
    • Balance Sheet will reflect Assets, Liabilities, and Closing Cash/Bank.
    • You’ll get real practice with narrations, ledger grouping, and DR/CR rules.

    Featured products

  • Mastering QUERY Function in Google Sheets: Complete Guide with Examples & Interview Questions

    The QUERY function in Google Sheets is one of the most powerful and versatile tools available. It allows you to perform SQL-like data manipulations—filtering, sorting, aggregating, and grouping—on your spreadsheet data.

    📌 QUERY Function Syntax

    QUERY(data, query, [headers])

    🔹 Arguments:

    1. data: The range of cells that you want to query.
    2. query: A string written in a pseudo-SQL format.
    3. headers (optional): The number of header rows at the top of your data (default is 1).

    🧠 Why Use QUERY?

    It combines the power of multiple functions like FILTER, SORT, VLOOKUP, SUMIF, UNIQUE, and even PIVOT TABLES—all in one.

    ✅ Basic Examples

    Assume we have the following data in A1:D6:

    NameAgeDepartmentSalary
    John25Sales30000
    Alice30HR35000
    Bob24Sales28000
    Carol29Marketing40000
    Dave35HR38000

    🔹 1. Select All Rows

    =QUERY(A1:D6, "SELECT *", 1)

    🔸 Returns the full table.

    🔹 2. Select Specific Columns

    =QUERY(A1:D6, "SELECT A, C", 1)

    🔸 Returns only Name and Department columns.

    🔹 3. Filtering Rows (WHERE Clause)

    =QUERY(A1:D6, "SELECT A, D WHERE C = 'Sales'", 1)

    🔸 Shows Name and Salary of employees in Sales department.

    🔹 4. Using Comparison Operators

    =QUERY(A1:D6, "SELECT A, B WHERE D > 30000", 1)

    🔸 Returns Name and Age of employees earning more than 30,000.

    🔹 5. Sorting (ORDER BY)

    =QUERY(A1:D6, "SELECT A, D ORDER BY D DESC", 1)

    🔸 Returns Name and Salary sorted by Salary in descending order.

    🔹 6. Grouping and Aggregating (GROUP BY)

    =QUERY(A1:D6, "SELECT C, AVG(D) GROUP BY C", 1)

    🔸 Calculates average salary per department.

    🔹 7. Labeling Columns

    =QUERY(A1:D6, "SELECT C, AVG(D) GROUP BY C LABEL AVG(D) 'Average Salary'", 1)

    🔸 Adds a custom label to the aggregated column.

    🔹 8. Limit Results

    =QUERY(A1:D6, "SELECT * LIMIT 3", 1)

    🔸 Returns only the first 3 rows.

    🔹 9. Combining WHERE and ORDER BY

    =QUERY(A1:D6, "SELECT A, D WHERE D > 30000 ORDER BY D DESC", 1)

    🔸 Filters employees with salary > 30,000 and sorts them in descending order.

    🔹 10. Dynamic Query with Cell Reference

    =QUERY(A1:D6, "SELECT A, D WHERE D > "&E1, 1)

    🔸 Assuming cell E1 has the value 30000, this will filter dynamically.

    ⚠️ Notes:

    • Text values in queries must be enclosed in single quotes (‘ ‘).
    • Numbers and cell references can be added directly.
    • QUERY is case-insensitive by default.

    🎯 Common Use Cases

    • Creating dashboards
    • Creating dynamic reports
    • Filtering datasets based on dropdown selections
    • Summarizing large data tables
    • Converting flat data into summarized views like pivot tables

    📘 Real-Life Example:

    Imagine a school with student records:

    StudentClassSubjectMarks
    Rahul10Math85
    Sneha10Science90
    Aman11Math78
    Priya10Math92

    To find average marks in each subject for class 10:

    =QUERY(A1:D5, "SELECT C, AVG(D) WHERE B = 10 GROUP BY C", 1)

    🔸 Returns Math and Science with their average marks for class 10 students.

    💼 Top 10 Interview Questions on Google Sheets QUERY Function

    1. Q: What is the QUERY function in Google Sheets?
      A: It allows you to use SQL-like queries to filter, sort, group, and summarize data.
    2. Q: How do you filter records using a text value in QUERY?
      A: Use WHERE column = 'Text', e.g., WHERE C = 'Sales'.
    3. Q: How can you sort data using QUERY?
      A: Use ORDER BY clause: ORDER BY column [ASC|DESC].
    4. Q: What does GROUP BY do in QUERY?
      A: It aggregates values (e.g., SUM, AVG) based on unique groups in a column.
    5. Q: How do you rename column headers in the QUERY result?
      A: Use the LABEL clause: LABEL AVG(D) 'Average Salary'.
    6. Q: What’s the difference between SELECT * and SELECT A, B?
      A: SELECT * selects all columns; A, B selects only specific columns.
    7. Q: How can you use a cell reference in a QUERY?
      A: Concatenate it: "SELECT A WHERE B > "&E1
    8. Q: Can you use OR and AND in QUERY filters?
      A: Yes. Example: WHERE B > 25 AND C = 'HR'
    9. Q: What happens if you omit the headers parameter?
      A: QUERY assumes the first row is the header by default (1).
    10. Q: How is QUERY different from FILTER function?
      A: FILTER is simpler and only filters data. QUERY is more powerful with sorting, aggregation, grouping, and SQL-like operations.

    Featured products

  • Best Laptops for Students Under ₹25,000 in 2025: Top 4 Budget Picks Compared

    If you’re a student looking for a reliable laptop under ₹25,000, you’re in luck! Whether it’s for online classes, browsing, MS Office work, or light coding and entertainment, we’ve compared four excellent budget laptops that give you the best bang for your buck. These laptops are compact, powerful enough for daily use, and most importantly—easy on the pocket.

    Let’s break down their features, pros, and cons to help you make an informed choice.

    🔹 1. Lenovo V15 Intel Celeron N4500 – ₹22,999

    Amazon Link: Click Here

    • Display: 15.6″ Full HD (1920×1080), Anti-glare
    • Processor: Intel Celeron N4500 (Up to 2.8GHz)
    • RAM & Storage: 8GB DDR4 RAM | 256GB SSD (upgradable)
    • Graphics: Intel UHD Graphics
    • OS: Windows 11 Home
    • Weight: 1.7 kg

    ✅ Pros:

    • Full HD display at this price is a huge bonus
    • Good RAM and SSD combo for smooth performance
    • Upgradable SSD

    ❌ Cons:

    • Slightly heavier
    • Celeron processor is entry-level

    Best for: Students needing a larger screen for research, MS Office, and online classes.

    🔹 2. DELL Wyse 5470 (Celeron N4100) – ₹24,666

    Amazon Link: Click Here

    • Display: 14.0″ HD (1366 x 768)
    • Processor: Intel Celeron Quad Core N4100 (Up to 2.4GHz)
    • RAM & Storage: 8GB DDR4 RAM | 256GB SSD + 16GB eMMC
    • Graphics: Intel UHD Graphics
    • OS: Windows 11 Home + MS Office 2021
    • Weight: 1.4 kg

    ✅ Pros:

    • Quad-core processor performs better than dual-core
    • Very lightweight (only 1.4 kg)
    • Includes MS Office
    • Sleek and portable for travel

    ❌ Cons:

    • HD screen only (not Full HD)
    • Slightly higher price near the ₹25k mark

    Best for: Students on the move who value portability and better multitasking.

    🔹 3. HP 255 G9 (Athlon 3050U) – ₹22,990

    Amazon Link: Click Here

    • Display: 15.6″ HD (1366×768), Anti-glare
    • Processor: AMD Athlon Silver 3050U
    • RAM & Storage: 4GB RAM | 256GB SSD
    • Graphics: Integrated
    • OS: DOS (Windows must be installed separately)
    • Weight: 1.47 kg

    ✅ Pros:

    • Big screen size with anti-glare
    • Reliable AMD processor
    • Decent build quality

    ❌ Cons:

    • Only 4GB RAM
    • No pre-installed Windows—additional cost & setup effort

    Best for: Students who have access to Windows installation and want an AMD option.

    Version 1.0.0

    🔹 4. Acer One 14 Ryzen 3 3250U – ₹24,999

    Amazon Link: Click Here

    • Display: 14″ HD (1366 x 768), Anti-glare
    • Processor: AMD Ryzen 3 3250U (Up to 3.5GHz)
    • RAM & Storage: 8GB DDR4 RAM (expandable) | 256GB SSD
    • Graphics: AMD Radeon
    • OS: Windows 11 Home
    • Weight: ~1.5 kg

    ✅ Pros:

    • Powerful Ryzen 3 processor
    • Windows 11 pre-installed
    • Expandable RAM
    • Sleek design

    ❌ Cons:

    • Slightly more expensive
    • Display is HD, not Full HD

    Best for: Students needing better performance for multitasking or coding.

    🏆 Our Recommendation: The Winner

    👉 Acer One 14 with Ryzen 3 3250U stands out as the best overall pick.

    Why?
    It combines strong performance, 8GB RAM, Windows 11, and expandability—a rare combination at this price point. While it doesn’t have Full HD, the Ryzen processor ensures smoother multitasking and longevity, making it future-proof for students.

    ✨ Final Thoughts

    All four laptops are good value for their price and serve specific use cases:

    LaptopBest For
    Lenovo V15Budget + Full HD Display
    DELL Wyse 5470Lightweight, better multitasking
    HP 255 G9Entry-level with large screen
    Acer One 14Best performance for serious students

    ⚠️ Tip: Always check if your use case (like Zoom, Excel, or Tally) requires Windows. Avoid DOS-based laptops if you’re not tech-savvy.

    Featured products

  • The Best All-in-One Desktop for Creators in 2025 – My Experience with Lenovo IdeaCentre

    🎥💻 Why the Lenovo IdeaCentre AIO 13th Gen i9 Is My Ultimate Workstation for Video Editing & Graphics

    If you’re a content creator, graphic designer, or video editor, you know how crucial it is to have a machine that keeps up with your creative flow. I’ve tried many desktops over the years—some bulky, some loud, some powerful but not stylish—but nothing has come close to the Lenovo IdeaCentre AIO 13th Gen Core i9.

    Let me take you through my personal experience with this beast of a machine, which I now proudly call my daily driver and creative partner.

    🔧 Powerhouse Performance that Speaks for Itself

    Powered by the 13th Gen Intel Core i9-13900H, this AIO delivers 14 cores and 20 threads, with P-cores clocking up to 5.4GHz. Translation? Whether I’m editing 4K videos in Premiere Pro or running heavy After Effects renders, this machine handles it like slicing butter with a hot knife. There’s no lag, no freezing, no “Not Responding” nightmares.

    And thanks to 32GB DDR5 RAM, multitasking is seamless—I can have After Effects, Photoshop, Chrome with 15 tabs, and Spotify running without a hitch.

    ⚡ Speed That Matches My Creativity

    With a 1TB PCIe 4.0 NVMe SSD, everything loads in seconds. No more wasting time waiting for files to open or exports to finish. Boot time? Around 7 seconds flat.

    Even transferring huge RAW video files feels fast. The SSD is so responsive, I almost forget what it was like to use a traditional hard drive.

    🎨 Stunning 27″ QHD IPS Display – A Designer’s Dream

    The 27-inch QHD (2560×1440) screen is a masterpiece on its own. With 99% sRGB color accuracy, IPS panel, and 350 nits brightness, it’s tailor-made for video color grading, photo editing, and graphic work.

    No exaggeration: it feels like I’m seeing my own work for the first time in its full glory. The anti-glare screen and low blue light make long editing sessions easy on the eyes too.

    🔈 Immersive Audio & Built-In Alexa – Productivity Meets Comfort

    The Harman 3W x2 speakers are surprisingly rich and full—perfect when I’m editing audio tracks or watching reference videos. And the 5MP + IR camera? Excellent clarity for client meetings on Zoom.

    Plus, with Alexa built-in, I can control my workspace hands-free—set reminders, play music, or check tasks without touching the keyboard. It’s a small thing, but it adds so much convenience.

    🧑‍💻 Sleek, Clean, and Modern Setup

    This is an All-in-One, which means no messy cables. Just one power cord and done. The build is premium and elegant—grey finish, slim bezels, and a minimal footprint. It looks professional and futuristic on any desk.

    Included in the box:

    • Wireless EOS Keyboard
    • Wireless EOS Mouse
    • Power Adapter
    • User Manual

    You literally plug it in and you’re good to go.

    💸 Pricing & Offers: Totally Worth the Investment

    At a limited-time price of ₹1,04,990 (down from ₹1,24,890), this machine is incredible value for what it offers. And if you use an SBI Credit Card, you can grab it with No Cost EMI at ₹17,498/month for 6 months. Totally worth every rupee if you’re investing in a serious creative setup.

    👉 Check it out here: Buy on Amazon

    💬 Final Thoughts – My Honest Recommendation

    I’ve worked on MacBooks, custom gaming rigs, and mid-range desktops—but the Lenovo IdeaCentre AIO i9 13th Gen strikes the perfect balance between power, aesthetics, and simplicity. For creators like me who value both performance and elegance, this is a no-brainer.

    Whether you’re editing videos, creating digital art, streaming content, or building your own agency—this is the machine that grows with you.

    If you’re even slightly serious about your creative work—this is the best investment you can make right now.

    Featured products

  • Why America Feels Insecure: The Truth Behind the 50% Tariff

    India Rising While America Turns Inward: How 50% Tariffs Reflect Changing Global Power Equations

    For much of the 20th century, the United States stood tall as the unchallenged superpower — economically, militarily, and diplomatically. But in the 21st century, the world is changing rapidly. A once-confident America is now turning increasingly inward, and its latest move — a proposed 50% blanket tariff on all imports by Donald Trump — reflects more fear than strength.

    At the same time, India too is using tariffs — but strategically. Recently, India raised import duties to 40-50% on Chinese EVs, solar modules, and select electronics to boost domestic manufacturing and secure its critical sectors. The difference? India’s policy is forward-looking and rooted in economic self-reliance, while America’s is defensive and politically motivated.

    This moment marks a shift in the global balance — and India must seize it.

    🧩 Understanding the U.S. Shift: From Confidence to Control

    📉 The Decline of Absolute Economic Dominance

    • In 1945, the U.S. made up 50% of global GDP. Today, it’s around 24%.
    • The U.S. now imports everything — from iPhones to insulin, steel to semiconductors — relying heavily on China, India, Vietnam, and Mexico.
    • Trade deficits have crossed $1 trillion annually, mostly with China and Asian economies.

    This shift has exposed structural weaknesses in the U.S. economy — and the political backlash is visible in populist rhetoric and protectionist trade policies.

    🔥 Trump’s 50% Tariff Announcement – Strategy or Desperation?

    📰 What Happened?

    • Former U.S. President and 2024 candidate Donald Trump proposed a 50% tariff on all imports.
    • This would affect India, China, Mexico, Vietnam, and even U.S. allies in Europe and Asia.
    • His rationale: bring back manufacturing jobs and punish countries “stealing American prosperity.”

    But such across-the-board tariffs are economically reckless. They could:

    • Raise prices for American consumers.
    • Spark global trade retaliation.
    • Hurt U.S. manufacturers that rely on global supply chains.
    • Isolate the U.S. in a multipolar world.

    🇮🇳 India’s 50% Tariff – A Strategic and Targeted Move

    Unlike Trump’s political gamble, India’s recent 40-50% tariffs serve long-term national interests:

    ✅ What India Did:

    • Raised tariffs to 50% on Chinese electric vehicles (EVs).
    • Imposed higher duties on solar modules and certain electronics from China.
    • Goal: Protect India’s domestic manufacturing, avoid overdependence on a single country (China), and secure critical sectors like energy and mobility.

    🧠 Why This Makes Sense:

    • Boosts ‘Make in India’ initiatives.
    • Reduces strategic dependence on an increasingly aggressive neighbor.
    • Encourages global players to set up manufacturing in India, not just export here.
    • Shields local MSMEs from predatory pricing by Chinese firms.

    India’s tariff use is surgical and sector-specific, aimed at nation-building — not political drama.

    🧠 Why the U.S. Feels Insecure — And How It Lost Ground

    🔻 Economic Drift

    • Offshored manufacturing for decades for short-term cost savings.
    • Became dependent on China for pharmaceuticals, rare earths, chips, and more.
    • Allowed financial capitalism to overtake productive manufacturing.

    🔻 Military Overstretch

    • Trillions spent in Iraq, Afghanistan, Syria — without strategic wins.
    • Meanwhile, China built factories, roads, and tech dominance.

    🔻 Populist Backlash

    • Middle America lost jobs.
    • Income stagnated.
    • Trump-style populism grew.

    The result? Tariffs as panic buttons, not policy.

    📉 Why Trump’s Tariffs Will Hurt the U.S. (Again)

    • U.S. consumers will pay more.
    • Allies and trade partners will retaliate.
    • Companies will face supply chain chaos.
    • Inflation may spike.
    • No guarantee jobs will return — they may just move to Mexico, India, Vietnam instead of China.

    🔁 History Repeats:

    • 1930: Smoot-Hawley Tariff deepened the Great Depression.
    • 2002: Bush’s steel tariffs hurt auto industry and were scrapped.
    • 2018: Trump’s China tariffs led to a bruising trade war — no clear win.

    🇮🇳 Why India Shouldn’t Fear the 50% Threat — But Leverage It

    ✅ 1. India’s Internal Strength Is Growing

    • World’s fastest-growing large economy.
    • $650+ billion forex reserves.
    • Booming sectors: EVs, pharma, IT, defense, infra, semiconductors.
    • Strong governance focus on self-reliance (Atmanirbhar Bharat).

    ✅ 2. Reduced Dependency = Greater Autonomy

    India now understands:

    • Over-dependence on any one country (e.g. China) = strategic risk.
    • Diversified trade = stronger bargaining power.
    • Tariff tools must be used strategically, not politically.

    ✅ 3. Global Trust in India Is High

    • Neutral yet firm.
    • Engaged with West, East, BRICS, Africa.
    • Attracting global companies to set up base in India.

    🧭 What Should India Do Next?

    • Expand South-South trade with BRICS+, ASEAN, Africa.
    • Promote domestic supply chains in EVs, solar, chips, and AI.
    • Negotiate trade deals with EU, UAE, Australia, Japan.
    • Encourage FDI in manufacturing and R&D.
    • Use tariffs strategically where needed, not impulsively.

    The world is entering a new phase of economic nationalism and strategic decoupling. But there’s a right and wrong way to do it.

    • Trump’s 50% tariff: Fear-driven, vote-driven, globally destabilizing.
    • India’s selective 50% tariff: Thoughtful, strategic, aimed at national development.

    India is no longer just reacting to global shocks — it’s crafting its own future. And that’s the real story behind the 50% tariff moment.

    Featured products

  • Trump’s 50% Tariff Proposal: Populism or Policy? India Stands Strong

    India at the Crossroads of Global Trade: Understanding Trump’s 50% Tariff Proposal

    As the U.S. gears up for another presidential election, former President Donald Trump is once again dominating headlines—this time with a bold (and controversial) proposal to impose a flat 50% tariff on all imports if re-elected.

    This has stirred concern not just within the U.S. but also in major exporting countries like India, China, Mexico, Vietnam, and others. While some interpret this move as madness, others believe it’s a well-planned political strategy.

    But what does this really mean?

    Let’s dig deeper into whether this is:

    • A calculated election move
    • A trade war tactic to gain leverage
    • Or simply populist messaging that could backfire

    Before that, here’s some important historical context.

    📜 Past Examples of Trump’s Tariff Policies

    Trump is no stranger to aggressive trade policies. During his 2016–2020 presidency, he took several bold steps in global trade that shaped the current economic discourse.

    🔸 2018–2020: U.S.–China Trade War

    • Tariffs on $360+ billion worth of Chinese goods
    • Retaliatory tariffs by China on U.S. products like soybeans, pork, and aircraft
    • Impact: American farmers suffered. Inflation rose. Global supply chains were disrupted.

    🔸 Tariffs on Allies

    • Steel and aluminum tariffs imposed on EU, Canada, and Mexico
    • Result: Trade partners responded with retaliatory tariffs on American whiskey, dairy, and motorcycles

    🔸 NAFTA Renegotiation (→ USMCA)

    • Trump threatened to pull out of NAFTA unless better terms were secured
    • Canada and Mexico eventually agreed to new terms under pressure

    Now let’s explore why Trump might be proposing a 50% tariff now—and what the implications are.

    1️⃣ Is It a Strategic Move for Votes in an Election Year?

    Yes. It’s classic electoral politics.

    Trump’s core supporters—especially in swing states like Michigan, Ohio, and Pennsylvania—are blue-collar workers who feel left behind by globalization. A strong, protectionist trade stance helps:

    • Rally his base
    • Show he’s “tough” on China and outsourcing
    • Revive the “America First” narrative

    It simplifies complex economic issues into emotionally powerful slogans like:

    “Bring Back Jobs”
    “Make in America”
    “We Don’t Need China”

    ✅ Strategically, it’s a high-impact tool to regain political momentum.

    2️⃣ Is It a Negotiation Tactic to Pressure Other Nations?

    Highly likely.

    Trump has a track record of using tariff threats as bargaining chips in trade talks. His goal is often to:

    • Push countries to renegotiate deals on U.S. terms
    • Gain market access for American companies
    • Force domestic manufacturing revival

    However, this tactic has risks:

    • Retaliation from trade partners
    • Diplomatic strain with allies
    • Loss of market share to countries like India and Vietnam

    🧨 Tariffs can serve as a negotiation tool, but repeated use diminishes their effectiveness.

    3️⃣ Or Is It Short-Sighted Populism That Could Backfire?

    Almost certainly yes.

    A flat 50% tariff sounds bold but ignores economic realities:

    • U.S. businesses rely on foreign raw materials (chips, metals, parts)
    • Tariffs will raise costs for American manufacturers
    • Consumers will face higher prices, worsening inflation
    • Trading partners will retaliate, harming U.S. exports

    🧠 Trade is not a zero-sum game.

    In a globally connected economy, over-simplified trade measures lead to pain on both sides—as seen during the 2018–2020 trade war.

    🔄 Reverse Impact on the U.S. Economy

    Here’s what Trump’s tariff policy could unintentionally trigger:

    • 📈 Inflation spike in the U.S. due to expensive imports
    • 🚫 Reduced product variety in U.S. markets
    • 💼 Job losses in sectors that rely on global exports (agriculture, aerospace, tech)
    • 🏭 Investment diversion to more stable regions like India, Vietnam, and the EU

    The U.S. needs global supply chains just as much as others need the U.S. market.

    🇮🇳 Why This Might Be Good News for India

    India can actually benefit from this shift if it plays its cards right.

    ✅ Diversification of Exports:

    Instead of relying on U.S. demand, India can strengthen its trade ties with:

    • ASEAN and RCEP nations
    • European Union
    • Middle East and Africa

    ✅ Stronger Domestic Market:

    India’s large domestic population and consumption base gives it insulation from external shocks.

    ✅ Self-Reliance Boost:

    “Atmanirbhar Bharat” initiatives align well with global decoupling trends. As countries seek alternatives to China and the U.S., India can step up as a reliable manufacturing hub.

    A less U.S.-dependent trade model = greater sovereignty and resilience.

    💬 What the RBI Governor’s Statement Signifies

    Recently, the RBI Governor remarked that those calling India a “dead economy” have been proven wrong—a subtle but strong pushback against negative narratives.

    It’s significant because:

    • RBI is non-political and data-driven
    • It reflects confidence in India’s fundamentals
    • Reinforces that India isn’t as vulnerable to external noise as critics claim

    ✍️ Conclusion

    Trump’s 50% tariff proposal is less about sound economics and more about political optics. Whether it’s a tactic or a gamble, it is likely to:

    • Hurt the U.S. economy
    • Trigger global retaliation
    • Open new doors for countries like India

    India, with its growing domestic market, diversified export plans, and increasing global stature, is well-positioned to thrive—even as others turn inward.

    Featured products

  • India’s Economic Backbone: Why the RBI Governor’s Rebuttal Proves India Is Far from a ‘Dead Economy

    🇮🇳 India’s Strength in Words: Why the RBI Governor’s Statement Matters More Than Political Rhetoric

    In a world often dominated by populist political statements and global trade tension, the recent remarks by India’s Reserve Bank of India (RBI) Governor—a non-political, professional economist—carry special weight. His calm yet firm rebuttal to claims labelling India as a “dead economy” is not just a response to noise, but a clarion call reinforcing India’s economic resilience.

    🎙️ Why the RBI Governor’s Voice Matters More

    Unlike elected leaders or political influencers, the RBI Governor is apolitical and independent, guided only by data, macroeconomic realities, and national interest. When Governor Sanjay Malhotra says India is growing at 6.5% and contributing 18% to global GDP growth, it isn’t spin. It’s fact.

    His position demands rigorous analysis, neutrality, and foresight. This makes his statement far more credible than politically charged comments. While a politician may gain by downplaying or exaggerating economic situations, the RBI cannot afford either.

    📊 Debunking the “Dead Economy” Myth

    The RBI Governor’s statement came in response to former US President Donald Trump’s remark calling India a “dead economy.” However, the reality, as explained by the central bank, is quite the opposite:

    • India is one of the top contributors to global economic growth—even ahead of the United States in terms of contribution percentage.
    • It has a robust domestic demand, a vibrant services sector, and rapid digitalisation, all fueling inclusive growth.
    • Macro indicators are healthy: inflation is under control, forex reserves are stable, and the banking sector is stronger than ever.

    🚢 Understanding the 50% US Tariff – What It Means for India

    There’s been anxiety over Trump’s suggested 50% tariff on Chinese and possibly Indian imports if he returns to office. But let’s break this down:

    1. India isn’t China: Our exports are largely specialised, including pharmaceuticals, IT services, gems & jewellery, textiles, automotive components, and skilled human capital. These aren’t easily replaceable.
    2. Minimal Direct Impact: While a few sectors may feel the pinch, India’s overall export to the US is diversified and unlikely to suffer massive contraction. The US needs Indian software, drugs, and diamonds—things it can’t easily get from domestic sources or other markets.
    3. Alternative Markets: India’s aggressive push in Middle East, Africa, Europe, and Southeast Asia means we’re not heavily reliant on the US anymore. Trade deals with the UAE, Australia, and talks with the EU & UK show India is already shifting gears.

    🌍 Turning Tariff Threats into a Strategic Advantage

    Rather than panic, India should (and is) using this as an opportunity to reduce dependency on any one nation. Here’s how:

    • Diversification of Export Markets: Reduces risk and gives India stronger bargaining power.
    • Strengthening Local Demand: India’s large middle class and digital economy offer a powerful domestic cushion.
    • Boosting Self-Reliance: Policies like Make in India, PLI schemes, and Startup India further reduce vulnerability to external shocks.

    By depending less on any single country, especially a volatile partner, India gains more control over its economic destiny.

    🔁 The Boomerang Effect on the U.S.

    If the U.S. imposes heavy tariffs on Indian goods:

    • Prices will rise for American consumers, especially for drugs, jewelry, and IT services.
    • Inflation could increase as alternate sources are costlier or less reliable.
    • Supply chains will be disrupted, especially in high-value niches like software support, back-office operations, and pharma.

    In essence, the tariff may hurt India somewhat—but it could hurt the U.S. economy more subtly and longer-term.

    🛡️ Conclusion: India’s Economic Backbone Is Strong

    The RBI Governor’s remarks are not just defensive; they are data-driven validations of India’s rise. In times of global uncertainty and political posturing, India’s stable, non-political economic institutions like the RBI provide the assurance investors, businesses, and citizens need.

    Rather than focusing on rhetoric, India must continue its focus on self-reliance, diversified trade, and economic reform. The world’s fifth-largest economy isn’t “dead”—it’s only getting stronger.

    Featured products

  • Tariff or No Tariff, India Marches On: Why the US 50% Tariff Won’t Stop Indian Growth

    🇮🇳 Trump’s 50% Tariff on Indian Goods – What It Means for India and the US

    The recent hike in US tariffs on Indian goods—from 25% to 50%—is a significant trade move that will impact several industries. While the intention may be to reduce dependency on Indian imports and penalize geopolitical actions (such as oil purchases from Russia), the fallout is expected to create challenges for both countries—not just India.

    🔻 Which Indian Industries Are Affected?

    The US is one of India’s largest export destinations, and certain sectors are more exposed to this trade route than others. Industries with heavy dependency on US buyers include:

    1. Textiles & Garments

    • India exports a large volume of ready-made garments and home textiles to the US.
    • The sector contributes significantly to employment, especially for women.
    • With a 50% tariff, Indian-made clothing will become more expensive for US retailers, making them shift sourcing elsewhere or reduce imports.

    2. Gems & Jewellery

    • India is a global leader in diamond cutting and jewellery crafting.
    • Around 30–40% of high-end gem exports go to the US.
    • Tariff hikes make Indian jewellery far less competitive compared to Thai or Vietnamese suppliers.

    3. Seafood (Especially Shrimp)

    • The US is the top buyer of Indian shrimp.
    • The tariff may wipe out the price advantage India has enjoyed for years, leading to loss of orders.

    4. Leather & Footwear

    • Leather goods and accessories are another major export to the US.
    • India’s price-sensitive products may no longer be viable after the tariff bump.

    5. Chemicals, Engineering Goods & Auto Parts

    • These form a growing share of high-value manufacturing exports.
    • These industries may see reduced demand or buyers looking for alternative suppliers.

    📉 How Much Will It Impact India’s Export Economy?

    • India currently exports around $85–90 billion worth of goods to the US annually.
    • A large portion (estimated $60–65 billion) falls under categories directly affected by the tariff.
    • Exporters expect a 40–50% drop in orders in the impacted sectors due to loss of price competitiveness.
    • Specific industries like seafood may face revenue losses of ₹20,000–₹25,000 crore.
    • In total, India could see a $8–10 billion dent in export earnings in the short term.

    💪 Can the Indian Economy Handle This Shock?

    Yes—and here’s why:

    ✅ 1. Exports Are Only a Small Part of India’s GDP

    • India’s economy is now worth over $4 trillion.
    • Exports to the US form less than 2% of India’s GDP, so even a large drop in those exports won’t derail growth.

    ✅ 2. Strong Domestic Demand

    • India’s large middle class and consumption-based economy help balance export losses.
    • Sectors like real estate, fintech, renewable energy, and infrastructure are seeing growth from within the country.

    ✅ 3. Diversified Trade Routes

    • India is actively expanding exports to Europe, Southeast Asia, Middle East, and Africa.
    • New Free Trade Agreements (FTAs) and trade corridors reduce dependency on any single country.

    ✅ 4. Robust Sectors Unaffected by Tariff

    • IT services, pharmaceuticals, and software exports—India’s strongest exports—remain unaffected.
    • These sectors continue to attract global clients, investments, and revenue.

    ✅ 5. FDI and Manufacturing Momentum

    • India is becoming a preferred manufacturing hub under the “China plus one” strategy.
    • Global companies are investing in Indian production, which builds long-term resilience.

    🔁 How the Tariff Will Hurt the US Too

    While the US may try to pressure India through tariffs, this decision could backfire in multiple ways:

    📌 1. Higher Consumer Prices

    • American retailers importing Indian textiles, jewellery, and shrimp will pay more, passing the cost to consumers.
    • This could add to inflation—a problem already troubling the US economy.

    📌 2. Limited Alternatives

    • India is among the few countries that can produce high volumes at low cost.
    • Finding new suppliers may not be easy, and short supply could lead to product shortages or delays.

    📌 3. Disrupted Supply Chains

    • Indian exporters form part of critical global supply chains, especially in auto components and engineering goods.
    • Disrupting this flow can hurt US manufacturing, not just retail.

    📌 4. Loss of Balance in Strategic Partnership

    • The tariff move may strain India-US relations in areas like defense, tech, and geopolitical collaboration.
    • This weakens long-term trust and trade stability.

    📌 5. Hurt to US Importers and SMEs

    • Many small and mid-sized US businesses rely on cost-effective Indian goods.
    • The tariffs may lead to layoffs, shrinking margins, or even shutdowns for such importers.

    🧠 Final Takeaway

    India may lose some short-term export revenue, but its economic fundamentals remain strong. With a growing domestic market, global investor interest, and alternate trade partners, India has the capacity to withstand the pressure and emerge even stronger.

    On the other hand, the US may find itself struggling with inflation, limited alternatives, and unhappy consumers. In an interconnected world, trade barriers often result in mutual damage—not unilateral success.

    Featured products

  • 100 Essential Ledger Accounts for a Logistics Company with Tally Prime Groups & Setup Guide

    ✅ What Are Ledgers?

    Ledgers in accounting are books or digital records where all financial transactions related to a particular account (e.g., fuel expense, customer, vendor) are recorded.

    🧾 100 Ledger Names for a Logistics Company (Categorized)

    🔹 Assets (Group: Assets)

    Ledger NameGroup
    1. Cash in Hand | Cash-in-Hand
    2. Cash at Bank – ICICI | Bank Accounts
    3. Cash at Bank – HDFC | Bank Accounts
    4. Accounts Receivable – ABC Pvt Ltd | Sundry Debtors
    5. Accounts Receivable – XYZ Logistics | Sundry Debtors
    6. Fixed Assets – Office Equipment | Fixed Assets
    7. Fixed Assets – Vehicles | Fixed Assets
    8. Fixed Assets – Computers | Fixed Assets
    9. Fuel Inventory | Stock-in-Hand
    10. Tyres Inventory | Stock-in-Hand
    11. Prepaid Insurance | Current Assets
    12. Prepaid Maintenance | Current Assets
    13. Input GST | Duties & Taxes
    14. TDS Receivable | Current Assets
    15. Advances to Staff | Loans & Advances (Asset)

    🔹 Liabilities (Group: Liabilities)

    Ledger NameGroup
    1. Accounts Payable – DEF Transporters | Sundry Creditors
    2. Accounts Payable – LMN Fuel Suppliers | Sundry Creditors
    3. TDS Payable | Duties & Taxes
    4. GST Payable | Duties & Taxes
    5. Loan – HDFC | Secured Loans
    6. Loan – ICICI | Secured Loans
    7. Provident Fund Payable | Current Liabilities
    8. ESI Payable | Current Liabilities
    9. Salary Payable | Current Liabilities
    10. Bonus Payable | Current Liabilities

    🔹 Income (Group: Indirect Incomes)

    Ledger NameGroup
    1. Freight Income – Domestic | Sales Accounts
    2. Freight Income – International | Sales Accounts
    3. Loading Charges Income | Indirect Incomes
    4. Warehousing Income | Indirect Incomes
    5. Handling Charges Income | Indirect Incomes
    6. Demurrage Income | Indirect Incomes
    7. Detention Charges Received | Indirect Incomes
    8. Packaging Income | Indirect Incomes
    9. Customs Clearance Income | Indirect Incomes
    10. Other Miscellaneous Income | Indirect Incomes

    🔹 Expenses (Group: Indirect Expenses)

    Ledger NameGroup
    1. Fuel Expense | Indirect Expenses
    2. Vehicle Maintenance | Indirect Expenses
    3. Toll Charges | Indirect Expenses
    4. Insurance – Vehicle | Indirect Expenses
    5. Insurance – Office | Indirect Expenses
    6. Driver Salary | Indirect Expenses
    7. Cleaner Salary | Indirect Expenses
    8. Staff Salary | Indirect Expenses
    9. Bonus Expense | Indirect Expenses
    10. Conveyance | Indirect Expenses
    11. Office Rent | Indirect Expenses
    12. Godown Rent | Indirect Expenses
    13. Electricity Charges | Indirect Expenses
    14. Water Charges | Indirect Expenses
    15. Telephone Expenses | Indirect Expenses
    16. Mobile Expenses | Indirect Expenses
    17. Internet Expenses | Indirect Expenses
    18. Postage & Courier | Indirect Expenses
    19. Printing & Stationery | Indirect Expenses
    20. Legal & Professional Fees | Indirect Expenses
    21. Audit Fees | Indirect Expenses
    22. Bank Charges | Indirect Expenses
    23. Loading & Unloading Expense | Indirect Expenses
    24. Packaging Expense | Indirect Expenses
    25. Demurrage Charges Paid | Indirect Expenses
    26. Detention Charges Paid | Indirect Expenses
    27. Security Charges | Indirect Expenses
    28. Repairs – Building | Indirect Expenses
    29. Repairs – Equipment | Indirect Expenses
    30. Repairs – Vehicles | Indirect Expenses
    31. Training Expenses | Indirect Expenses
    32. Marketing & Advertisement | Indirect Expenses
    33. Business Promotion | Indirect Expenses
    34. Licenses & Permits | Indirect Expenses
    35. IT Support Charges | Indirect Expenses
    36. Software Subscription | Indirect Expenses
    37. ERP Charges | Indirect Expenses
    38. Interest on Loan – HDFC | Indirect Expenses
    39. Interest on Loan – ICICI | Indirect Expenses
    40. Penalty Charges | Indirect Expenses
    41. Miscellaneous Expenses | Indirect Expenses

    🔹 Customers (Group: Sundry Debtors)

    Ledger NameGroup
    1. ABC Pvt Ltd | Sundry Debtors
    2. XYZ Logistics | Sundry Debtors
    3. JKL Exporters | Sundry Debtors
    4. MNO Traders | Sundry Debtors
    5. PQR Enterprises | Sundry Debtors
    6. STU Distributors | Sundry Debtors
    7. VWX Manufacturers | Sundry Debtors
    8. BCD Retailers | Sundry Debtors
    9. HIJ Warehousing | Sundry Debtors
    10. LMN Shipping | Sundry Debtors

    🔹 Vendors (Group: Sundry Creditors)

    Ledger NameGroup
    1. Diesel Supplier – Reliance | Sundry Creditors
    2. Diesel Supplier – HP | Sundry Creditors
    3. Spare Parts Supplier – ABC Auto | Sundry Creditors
    4. Tyre Supplier – MRF | Sundry Creditors
    5. Insurance – ICICI Lombard | Sundry Creditors
    6. Mechanic – Local Garage | Sundry Creditors
    7. Transport Union Fees | Sundry Creditors
    8. Toll Vendor – FASTag | Sundry Creditors
    9. Loading Labor Contractor | Sundry Creditors
    10. Internet Provider – Airtel | Sundry Creditors
    11. Security Contractor | Sundry Creditors
    12. Advertising Agency | Sundry Creditors
    13. Accounting Consultant | Sundry Creditors
    14. Legal Advisor | Sundry Creditors

    📌 How to Create a Ledger in Tally Prime

    Steps:

    1. Gateway of Tally → Create → Ledger
    2. Enter:
      • Name of the ledger (e.g., “Fuel Expense”)
      • Group (e.g., “Indirect Expenses”)
      • Enable GST/TDS/Bank details if required
    3. If there’s any opening balance, enter it (positive for assets, negative for liabilities)
    4. Press Ctrl + A to save

    💼 When to Enter Opening Balances?

    • For Sundry Debtors/Creditors → Opening balance is the amount pending to be received/paid at the start of books.
    • For Cash/Bank → Enter the actual balance on the start date.
    • For Loans or Liabilities → Enter the outstanding amount as a negative balance.
    • For Assets like vehicles → Enter the book value at the time of starting Tally.

    ✅ Maintaining ledgers with proper groups ensures accurate reporting, correct GST calculations, and easy audit trail.

    Featured products

  • The Harsh Reality Facing MBBS Graduates in India: A Deep Dive into Cost, ROI, and the Way Forward

    Medicine has long been viewed as a prestigious and noble career in India. However, for the vast majority of MBBS graduates, particularly from private institutions, the dream has turned into a harsh reality. With escalating tuition fees, inadequate job opportunities, and poor return on investment (ROI), the situation is increasingly unsustainable. This report explores the data, trends, and implications behind this growing crisis, and presents a case study to illustrate the gravity of the issue.

    Section 1: The Economics of MBBS Education in India

    Type of CollegeFees (approx.)DurationTotal Investment (incl. misc.)
    Government College₹50,000 – ₹1 lakh5.5 years₹2–5 lakhs
    Private Medical College₹60 lakhs – ₹1.2 crore5.5 years₹75 lakhs – ₹1.5 crore
    Deemed Universities₹80 lakhs – ₹1.5 crore5.5 years₹1 crore+
    MBBS Abroad₹25–40 lakhs5.5 – 6 years₹30–50 lakhs

    Note: These figures include tuition, hostel, living costs, and coaching for NEET PG.

    Section 2: Post-MBBS Income Levels

    Type of Work / JobSalary (Monthly)Annual Salary
    Govt. House Surgeon / JR₹35,000 – ₹60,000₹4 – ₹7 lakh
    Private Hospital (Tier 1 city)₹40,000 – ₹80,000₹5 – ₹10 lakh
    Rural Posting / NGO Work₹25,000 – ₹40,000₹3 – ₹5 lakh
    Clinic/Assistant Doctor₹20,000 – ₹50,000₹2.5 – ₹6 lakh

    Given these salaries, a student who invested ₹1 crore in their MBBS education will require 15–20 years or more to break even.

    Section 3: What’s Going Wrong?

    A. Oversupply of MBBS Graduates vs. PG Seats

    • Over 1 lakh MBBS seats annually.
    • Only ~50,000 PG seats.
    • Thousands of doctors remain underqualified for specialist roles and thus underpaid.

    B. Commercialization of Medical Education

    • Capitation-based admissions dominate in private colleges.
    • Quality of education often does not match the cost.

    C. Limited Government Jobs

    • Healthcare infrastructure remains underdeveloped.
    • Many doctors left waiting years for stable public jobs.

    D. Lack of Entrepreneurial & Business Skills

    • MBBS syllabus lacks training on running a practice, digital branding, or financial literacy.

    E. NEET PG Pressure & Mental Health Toll

    • Thousands prepare 1–2 years post-MBBS for NEET PG.
    • Delay in career growth, no income, rising stress levels.

    Section 4: Detailed Case Study – Dr. Riya Sharma

    • Background: Dr. Riya, from Jaipur, pursued MBBS from a private medical college in Maharashtra. Her family spent approximately ₹1.1 crore including fees, hostel, and coaching.
    • Post-MBBS Situation: After graduating in 2022, she worked as a junior resident in a private hospital for ₹45,000/month.
    • NEET PG Struggles: She failed to secure a PG seat in her first attempt and took a drop year, investing another ₹1.5 lakh in coaching.
    • Financial Burden: The family took a loan of ₹30 lakhs; EMI was ₹35,000/month. Her salary barely covered the EMI.
    • Outcome: In 2024, she secured a DNB seat in anaesthesia. But her PG stipend is only ₹42,000/month, again offering little relief.

    Verdict: Despite 7 years of intense study and over a crore in spending, Dr. Riya is financially constrained and under heavy pressure.

    Section 5: Alternatives and Smart Choices for Youth

    A. Consider Alternative Careers

    CourseDurationCostAvg Salary
    BDS5 yrs₹5-15L₹4-8L
    BAMS5.5 yrs₹2-10L₹3-6L
    BPT4.5 yrs₹2-6L₹2-5L
    B.Sc. Nursing4 yrs₹1-3L₹2-4L
    Medical Coding6-12 mo₹1L₹4-6L

    B. Learn Non-Clinical Skills

    • Health data analytics
    • Medical content creation
    • Digital branding for doctors
    • Public health and administration

    C. Go Global

    • Consider PLAB (UK), USMLE (USA), or Germany-based PG options.
    • ROI is often higher and systems are more transparent.

    D. Build Personal Brand

    • Use social media and platforms like YouTube, Practo, and LinkedIn.
    • Start with awareness content or teleconsultation services.

    Conclusion

    MBBS is no longer the secure, prestigious career it once was, unless entered via government colleges or backed by successful PG specialization. The economics are brutally skewed for private college graduates.

    Message to Students & Parents: Treat medical education as a strategic investment. Evaluate costs, alternatives, and the real career landscape before committing.

    Message to Policymakers: Urgent reforms are needed in medical education pricing, seat distribution, healthcare hiring, and entrepreneurial training to ensure India doesn’t waste its medical talent.

    Featured products

  • 100 Excel Interview Questions and Answers: Crack Your Next MIS, Data Analyst, or Excel Job Interview

    Microsoft Excel is a powerful tool used across industries for data analysis, reporting, financial modeling, and business intelligence. Whether you’re applying for roles in data analysis, finance, accounting, MIS (Management Information System), operations, or even marketing, a strong grip on Excel can set you apart.

    👤 Who Should Use This?

    This list is ideal for:

    • Job seekers in roles like MIS Executive, Data Analyst, Financial Analyst, Business Analyst, Operations Manager, or Accountant
    • Freshers preparing for entry-level roles requiring Excel
    • Professionals upskilling for promotions or transitions to analytical roles
    • Trainers or HR professionals preparing candidates for interviews

    ✅ Excel Interview Questions and Answers (100 Q&A)

    🟩 Section 1: Basic Excel Skills

    1. Q: What is Microsoft Excel used for?
      A: Excel is used for data entry, data analysis, calculations, charting, pivot tables, and automation using formulas and macros.
    2. Q: What is a cell in Excel?
      A: A cell is the intersection of a row and a column where data is entered.
    3. Q: What is the difference between a worksheet and a workbook?
      A: A worksheet is a single sheet in Excel; a workbook is a file containing one or more worksheets.
    4. Q: How do you save a workbook in Excel?
      A: Use Ctrl + S or go to File > Save/Save As.
    5. Q: What are the different data types in Excel?
      A: Text, Numbers, Dates, Boolean (TRUE/FALSE), Currency, and Custom formats.
    6. Q: How do you insert a new row or column?
      A: Right-click on the row/column header > Insert, or use Ctrl + Shift + "+".
    7. Q: How do you freeze panes?
      A: Go to View > Freeze Panes to lock rows/columns for scrolling.
    8. Q: What is a range in Excel?
      A: A range is a selection of two or more cells, e.g., A1:A10.
    9. Q: How can you wrap text in a cell?
      A: Select the cell, go to Home > Wrap Text.
    10. Q: How do you merge cells?
      A: Select cells > Home > Merge & Center.

    🟨 Section 2: Formulas and Functions

    1. Q: What is the difference between a formula and a function?
      A: A formula is user-created (e.g., =A1+A2), while a function is a predefined operation (e.g., =SUM(A1:A2)).
    2. Q: What does the SUM function do?
      A: It adds up numbers in a given range. Example: =SUM(A1:A5)
    3. Q: What is the use of IF function?
      A: It performs logical tests. Example: =IF(A1>50, “Pass”, “Fail”)
    4. Q: What does VLOOKUP do?
      A: It searches for a value in the first column and returns data from a specified column.
      Example: =VLOOKUP(101, A2:C10, 3, FALSE)
    5. Q: What is the difference between VLOOKUP and HLOOKUP?
      A: VLOOKUP searches vertically; HLOOKUP searches horizontally.
    6. Q: What does the INDEX function do?
      A: It returns the value of a cell at a specific row and column in a range.
    7. Q: How does MATCH work?
      A: MATCH returns the position of a value in a range.
      Example: =MATCH(50, A1:A10, 0)
    8. Q: What is the use of CONCATENATE or CONCAT function?
      A: Joins multiple text strings into one.
      Example: =CONCAT(A1, " ", B1)
    9. Q: What is the difference between COUNT, COUNTA, and COUNTBLANK?
      A:
      • COUNT: counts numbers only
      • COUNTA: counts non-empty cells
      • COUNTBLANK: counts empty cells
    10. Q: How do you round numbers in Excel?
      A: Use ROUND, ROUNDUP, or ROUNDDOWN functions.

    🟧 Section 3: Intermediate Excel (Data Tools & Formatting)

    1. Q: What are conditional formatting rules?
      A: They format cells based on criteria (e.g., highlight values > 100).
    2. Q: How do you apply data validation?
      A: Data > Data Validation to restrict input (e.g., allow only numbers 1–100).
    3. Q: What is the use of “Remove Duplicates”?
      A: It deletes repeated data from a range.
    4. Q: How to use Text to Columns?
      A: Data > Text to Columns (used to split data based on delimiters).
    5. Q: What is a named range?
      A: A defined name for a cell or range (e.g., =SalesTotal)
    6. Q: What are sparklines?
      A: Mini charts within a cell to show trends.
    7. Q: How do you use Find and Replace?
      A: Ctrl + F (Find), Ctrl + H (Replace)
    8. Q: What is Flash Fill?
      A: Automatically fills patterns based on previous entries (Ctrl + E)
    9. Q: What is a drop-down list in Excel?
      A: Created using Data Validation to restrict input to a list.
    10. Q: What is the use of Goal Seek?
      A: To find the input value needed to achieve a desired result.

    🟦 Section 4: Charts and Visualizations

    1. Q: How do you insert a chart?
      A: Select data > Insert > Choose a chart type (e.g., column, line, pie)
    2. Q: What is a combo chart?
      A: A chart combining two chart types (e.g., column + line)
    3. Q: What is a pivot chart?
      A: A chart based on PivotTable data.
    4. Q: Can charts be dynamic?
      A: Yes, by using named ranges or tables with formulas.
    5. Q: What is a slicer in charts or pivots?
      A: A filter control used to filter PivotTables visually.

    🟫 Section 5: Pivot Tables & Data Analysis

    1. Q: What is a PivotTable?
      A: A tool to summarize large data sets with drag-and-drop fields.
    2. Q: How do you insert a PivotTable?
      A: Insert > PivotTable > Choose data and location
    3. Q: Can you group data in PivotTable?
      A: Yes, right-click on values > Group (useful for dates or ranges)
    4. Q: What is the difference between Value Field Settings – SUM vs COUNT?
      A: SUM totals numeric values, COUNT counts entries.
    5. Q: How do you refresh a PivotTable?
      A: Right-click > Refresh or use the Refresh button in the Ribbon.

    🟥 Section 6: Advanced Excel

    1. Q: What is Power Query?
      A: A data transformation tool to import, clean, and combine data.
    2. Q: What is Power Pivot?
      A: A data modeling tool to create relationships and use DAX formulas.
    3. Q: What are array formulas?
      A: Formulas that perform multiple calculations on one or more items.
    4. Q: What is the use of XLOOKUP?
      A: A more powerful and flexible replacement for VLOOKUP.
    5. Q: How do you use dynamic arrays like FILTER and SORT?
      A:
      • =FILTER(range, condition) to filter data
      • =SORT(range, column, order) to sort data
    6. Q: What is a dashboard in Excel?
      A: A visual interface using charts, KPIs, and PivotTables to monitor key metrics.
    7. Q: What is DAX in Power Pivot?
      A: Data Analysis Expressions – a formula language for creating custom calculations.
    8. Q: What is a data model in Excel?
      A: A relational database built using Power Pivot or linked tables.
    9. Q: What is Solver?
      A: An add-in used for optimization problems (e.g., maximize profit).
    10. Q: Can Excel connect to external data sources?
      A: Yes, from Access, SQL Server, web, CSV, etc.

    🔵 Section 7: Macros and VBA

    1. Q: What is a macro in Excel?
      A: A recorded sequence of steps that can be replayed.
    2. Q: How do you record a macro?
      A: View > Macros > Record Macro
    3. Q: What is VBA?
      A: Visual Basic for Applications – programming language for automating tasks.
    4. Q: What is a module in VBA?
      A: A container for procedures or code.
    5. Q: How do you open the VBA editor?
      A: Press Alt + F11.

    🟣 Section 8: Macros and VBA (Continued)

    1. Q: What is the difference between a Sub and a Function in VBA?
      A: A Sub performs actions but doesn’t return a value. A Function performs actions and returns a value.
    2. Q: How do you write a simple macro in VBA to display a message box?
      A:
    Sub ShowMessage()
    MsgBox "Hello, this is a message!"
End Sub
    1. Q: How can you run a macro using a button?
      A: Insert a Form Control button from the Developer tab, assign the macro.
    2. Q: What is a UserForm in VBA?
      A: A custom form/dialog box you can design for data entry or interaction.
    3. Q: What are some common uses of VBA in Excel?
      A: Automating reports, generating emails, cleaning data, creating dashboards, etc.

    🔶 Section 9: Error Handling and Troubleshooting

    1. Q: What does #DIV/0! error mean?
      A: Division by zero error – occurs when dividing by 0 or a blank cell.
    2. Q: What is #N/A error?
      A: “Not Available” – typically occurs with lookup functions when value not found.
    3. Q: What is #REF! error?
      A: Invalid cell reference – often happens when a cell referred in a formula is deleted.
    4. Q: What is #VALUE! error?
      A: Incorrect data type used in a formula.
    5. Q: How do you use IFERROR function?
      A: Wrap formulas to catch and replace errors.
      Example: =IFERROR(A1/B1, "Error in calculation")
    6. Q: What is circular reference in Excel?
      A: A formula that refers to its own cell, creating an endless loop.
    7. Q: How do you audit formulas in Excel?
      A: Use Formula Auditing tools (Formulas > Trace Precedents/Dependents)
    8. Q: How to evaluate formulas step by step?
      A: Use “Evaluate Formula” tool under Formulas tab.
    9. Q: What is the purpose of Watch Window?
      A: To monitor the values of key cells during calculations.
    10. Q: How can you protect a worksheet or cell?
      A: Review > Protect Sheet. Use Format Cells > Protection to lock/unlock cells first.

    🔷 Section 10: Excel Productivity Tips

    1. Q: How do you quickly select a range of data?
      A: Use Ctrl + Shift + Arrow keys.
    2. Q: How do you select non-contiguous cells?
      A: Hold Ctrl and click on individual cells.
    3. Q: How do you convert rows to columns (or vice versa)?
      A: Use Paste Special > Transpose.
    4. Q: How do you remove blank rows quickly?
      A: Use filters to find blanks and delete rows.
    5. Q: What does Ctrl + ; do?
      A: Enters the current date.
    6. Q: What does Ctrl + Shift + L do?
      A: Applies or removes filters.
    7. Q: How can you repeat the last action?
      A: Press F4.
    8. Q: How to lock row 1 while scrolling?
      A: View > Freeze Panes > Freeze Top Row.
    9. Q: What does Alt + = do?
      A: Inserts the SUM function automatically.
    10. Q: How do you insert the current time?
      A: Press Ctrl + Shift + ;

    ⚫ Section 11: Scenario-Based & Practical Questions

    1. Q: You have employee data. How do you find duplicate names?
      A: Use Conditional Formatting > Highlight Duplicates or use =COUNTIF(range, cell)>1
    2. Q: How would you create an attendance tracker in Excel?
      A: Use dates in columns, names in rows, and mark “P”/”A”; use COUNTIF for totals.
    3. Q: How to find top 3 sales from a list?
      A: Use =LARGE(range, 1), =LARGE(range, 2), etc.
    4. Q: How to split full names into first and last names?
      A: Use =LEFT() and =RIGHT() with FIND() or use Text to Columns.
    5. Q: How would you highlight weekends in a calendar?
      A: Use Conditional Formatting with formula: =WEEKDAY(A1,2)>5
    6. Q: How do you prepare a monthly sales dashboard?
      A: Use PivotTables, Pivot Charts, Slicers, Conditional Formatting, KPI indicators.
    7. Q: A client sends data in PDF – how do you get it into Excel?
      A: Use Power Query > Get Data from PDF or copy-paste and clean.
    8. Q: How do you track changes in Excel?
      A: Use File > Info > Version History (for OneDrive) or use manual versioning.
    9. Q: How would you remove all hyperlinks in a sheet?
      A: Select all cells > Right-click > Remove Hyperlinks.
    10. Q: How do you compare two columns for matching entries?
      A: Use =IF(A2=B2, "Match", "No Match") or use =COUNTIF(range, value)

    🟤 Section 12: Bonus & Conceptual Questions

    1. Q: What is the default file extension for Excel?
      A: .xlsx (macro-enabled workbook: .xlsm)
    2. Q: Can you open CSV files in Excel?
      A: Yes, Excel can open and edit CSV files.
    3. Q: What are Excel Tables and their benefits?
      A: Structured data ranges with automatic formatting, filters, and dynamic references.
    4. Q: What is a 3D reference in Excel?
      A: A formula referring to the same cell across multiple sheets. Example: =SUM(Sheet1:Sheet3!A1)
    5. Q: What are dynamic named ranges?
      A: Named ranges that adjust automatically as data changes using formulas like OFFSET or INDEX.
    6. Q: How does Excel handle leap years in date calculations?
      A: Excel treats dates as serial numbers and accurately accounts for leap years.
    7. Q: What is the use of INDIRECT function?
      A: Returns a cell reference from a text string. Example: =INDIRECT("A"&1)
    8. Q: What is the TODAY function used for?
      A: Returns the current date. Example: =TODAY()
    9. Q: Can Excel perform web scraping?
      A: Yes, using Power Query or legacy Web connectors (with limitations).
    10. Q: What are some common interview tasks given in Excel interviews?
      A:
    • Creating dashboards
    • Cleaning raw data
    • Performing VLOOKUP/INDEX-MATCH
    • Creating PivotTables
    • Writing formulas for KPIs
    • Automating tasks using macros

    🎓 Final Tips for Excel Interview Preparation

    • Practice real-world Excel projects (MIS reports, dashboards, sales trackers).
    • Be comfortable with both mouse navigation and keyboard shortcuts.
    • Focus on accuracy, speed, and logic—especially when solving lookup or data-cleaning tasks.
    • If the job requires automation, learn VBA basics and Power Query.

    🚀 Master MIS & Data Automation – One Course, Endless Opportunities!


    Boost your career with our Complete MIS Training Program – designed for professionals who want to excel in Data Management, Reporting, and Automation using Excel, Access, Macros, and SQL.

    ✅ 16.5 hours of expert-led video
    📂 26 downloadable resources
    🏅 Certificate of Completion
    💼 Real-world projects & job-ready skills

    👉 Perfect for MIS aspirants, analysts, and working professionals.

    Start now and become the go-to expert for smart data solutions!
    🔗 Enroll today

    Featured products