Excel Interview Challenge: Auto-Update Stock from Purchase & Sale Sheets
🧠 Excel Interview Challenge – Day 26
Question:
Aapko 3 Excel sheets banani hai – Purchase, Sale, aur Stock.
Jab aap Purchase sheet me data enter karein (jaise 50 Mouse @ ₹200),
Aur Sale sheet me 25 Mouse sale karein,
To Stock sheet me automatically bacha hua stock aur uski value update ho jaye.
Agar pura stock sell ho jaye, to Purchase sheet me product auto-hide ya mark ho jaye.
🧩 Yeh sab automation dynamic hona chahiye, bina manual update ke!
📌 Kya aap ise solve kar sakte ho?
👇 Comment your solution below!
📍 Follow for daily Excel interview problems
🔔 Like, Share & Subscribe @DecodeWithData
#ExcelInterviewQuestion #StockAutomation #ExcelChallenge #PurchaseSaleStock #DataAnalystPrep #ExcelShorts #DecodeWithData
Видео Excel Interview Challenge: Auto-Update Stock from Purchase & Sale Sheets канала DecodeWithData
Question:
Aapko 3 Excel sheets banani hai – Purchase, Sale, aur Stock.
Jab aap Purchase sheet me data enter karein (jaise 50 Mouse @ ₹200),
Aur Sale sheet me 25 Mouse sale karein,
To Stock sheet me automatically bacha hua stock aur uski value update ho jaye.
Agar pura stock sell ho jaye, to Purchase sheet me product auto-hide ya mark ho jaye.
🧩 Yeh sab automation dynamic hona chahiye, bina manual update ke!
📌 Kya aap ise solve kar sakte ho?
👇 Comment your solution below!
📍 Follow for daily Excel interview problems
🔔 Like, Share & Subscribe @DecodeWithData
#ExcelInterviewQuestion #StockAutomation #ExcelChallenge #PurchaseSaleStock #DataAnalystPrep #ExcelShorts #DecodeWithData
Видео Excel Interview Challenge: Auto-Update Stock from Purchase & Sale Sheets канала DecodeWithData
ExcelTips ExcelTricks ExcelShorts ExcelTutorial ExcelForBeginners ExcelInterview ExcelJobInterview InterviewQuestions DataAnalysisJobs ExcelForJobs ExcelFormulas ExcelFunctions DataAnalytics MIS Interview Advance Excel Interview Productivity excel for job interview Interview Question Question in excel dynamic excel formula data analyst interview Excel for beginner Data Analyst Interview Excel Logic Test Excel Shorts Excel Stock Management Dynamic Stock Sheet Excel
Комментарии отсутствуют
Информация о видео
12 мая 2025 г. 18:30:30
00:00:39
Другие видео канала
