Logo Interview Hunt
Login

MS Excel

• A spreadsheet app used for calculations, data entry, and analysis
• Made of rows and columns that create cells.

• The intersection between rows and columns is called cells

• MS- excel consist 1048576 Rows and 16384 Columns in a singal sheet.
• You can put numbers, text, formulas, and charts inside it

 


• Helps you do tasks like:

  • Adding expenses

  • Making business reports

  • Calculating profit and loss

  • Managing lists (customers, stock, attendance)

  • Creating graphs
    • Works with formulas like =SUM(A1:A10) to do math instantly

 

Imagine a notebook made of tiny boxes, but the boxes can do math, draw, sort, and analyze.

Topics

Conditional Formatting Sorting

Sorting

🔹 1. Simple Sorting (A to Z / Z to A)

Steps:

  1. Jis column ke data ko sort karna ho, usme kisi ek cell par click karo

  2. Data tab me jao

    • A → Z = Ascending (Small to Big / A to Z)

    • Z → A = Descending (Big to Small / Z to A)

📌 Example:

  • Names → A to Z

  • Marks → Highest to Lowest

🔹 2. Multi-Level Sorting (2 ya zyada columns)

Example:

Pehle Class, phir Marks ke according sort karna ho

Steps:

  1. Data select karo (Heading ke sath)

  2. Data tab → Sort

  3. Sort by: Class

  4. Add Level

  5. Then by: Marks

  6. OK

🔹 3. Custom Sorting (Month, Day, Rank etc.)

Example:

January, February, March… order me sort

Steps:

  1. Data select karo

  2. Data → Sort

  3. Order → Custom List

  4. Month/Day list choose karo

  5. OK

🔹 4. Sorting Numbers

  • Smallest to Largest

  • Largest to Smallest

📌 Percent, currency, date – sab same process se sort hota hai

🔹 5. Sorting Dates

 

  • Oldest to Newest

  • Newest to Oldest