Excel Function Questions in Hinglish
1. SUMIF Question
Ek sales data sheet mein, aapke paas different regions (North, South, East, West) ke
monthly sales figures hain. Aapko sirf "North" region ke total sales calculate karne hain.
Data sheet ka format kuch iss tarah hai:
Date Region Sales Amount
01-Jan-2025 North 45000
05-Jan-2025 South 38000
10-Jan-2025 North 52000
15-Jan-2025 East 41000
20-Jan-2025 West 39000
25-Jan-2025 North 48000
Aapko SUMIF function ka use karke sirf "North" region ke total sales nikalne hain. Aap iss
problem ko kaise solve karenge? SUMIF function ka syntax aur solution dono batayein.
2. COUNTIF Question
Aapke paas ek student marks sheet hai jisme different students ke exam scores hain.
Aapko yeh pata karna hai ki kitne students ne 75 se zyada marks score kiye hain.
Data sheet ka format kuch iss tarah hai:
Student Name Subject Marks
Rahul Mathematics 82
Priya Mathematics 68
Amit Mathematics 91
Student Name Subject Marks
Neha Mathematics 73
Vikram Mathematics 88
Sonia Mathematics 65
Deepak Mathematics 79
Aapko COUNTIF function ka use karke 75 se zyada marks wale students ki count nikalni
hai. COUNTIF function ka syntax aur solution detail mein explain karein.
3. VLOOKUP Question
Aapke paas do Excel sheets hain. Pehli sheet mein employee details hain jisme
Employee ID, Name, aur Department hai. Dusri sheet mein Employee ID aur unke
monthly salary details hain.
Employee Details Sheet:
Employee ID Name Department
E001 Rajesh Kumar Finance
E002 Anita Sharma HR
E003 Sunil Verma Marketing
E004 Meena Patel IT
E005 Vikrant Singh Operations
Salary Details Sheet:
Employee ID Basic Salary HRA DA Total Salary
E001 45000 15000 5000 65000
E002 38000 12000 4000 54000
E003 42000 14000 4500 60500
E004 50000 18000 6000 74000
Employee ID Basic Salary HRA DA Total Salary
E005 40000 13000 4200 57200
Aapko Employee Details sheet mein ek naya column "Total Salary" add karna hai aur
VLOOKUP function ka use karke har employee ke liye unki Total Salary Salary Details
sheet se fetch karni hai.
VLOOKUP function ka syntax aur iss problem ka solution step-by-step explain karein.
Aapka formula kya hoga aur kaise work karega?
4. XLOOKUP Question
Aapke paas ek product inventory management system hai jisme multiple sheets hain. Ek
sheet mein product details hain aur dusri sheet mein sales transactions.
Product Details Sheet:
Product Code Product Name Category Price Stock
P101 Samsung Galaxy S22 Mobile 65000 25
P102 iPhone 14 Pro Mobile 120000 15
P103 Dell XPS 13 Laptop 95000 10
P104 HP Pavilion Laptop 72000 18
P105 Sony Bravia 55" TV 88000 8
Sales Transactions Sheet:
Transaction Product
Date Customer Quantity Amount
ID Code
05-
T001 Rohan Mehta P102 1 120000
Mar-2025
08-
T002 Priyanka Joshi P104 2 144000
Mar-2025
12-
T003 Arjun Singh P101 3 195000
Mar-2025
Transaction Product
Date Customer Quantity Amount
ID Code
15-
T004 Neha Gupta P105 1 88000
Mar-2025
18- Karan
T005 P103 1 95000
Mar-2025 Malhotra
Aapko Sales Transactions sheet mein do new columns add karne hain - "Product Name"
aur "Current Stock". Aapko XLOOKUP function ka use karke Product Details sheet se har
transaction ke liye corresponding product name aur current stock fetch karna hai.
XLOOKUP function ka syntax samjhayein aur batayein ki yeh VLOOKUP se kaise better
hai. Iss problem ka solution step-by-step explain karein, aur yeh bhi batayein ki agar
product code match na ho to "Product Not Found" display kaise karein.
