Excel Interview Prep
60 मिनट4 पाठ12 प्रश्न
पाठ
अभ्यास फ़ाइल
⬇ डाउनलोड करें career-boosters-practice.zipCareer Boosters practice bundle
Extract career-boosters-practice.zip before working with its files.
career-practice.xlsx: interview log, project planner, keyword checker and pricing exercise.career-reference.xlsx: static checked answers for the five portfolio projects and messy-export case.datasets/: seven original CSVs plus the retail target table required by the retail brief.resume-templates/: the supplied fresher and experienced DOCX examples. Replace every example claim with truthful personal information.templates/: editable project README, proposal and handover outlines.solutions-en.md/solutions-hi.md: worked guidance for all 14 lessons.answer-key.json/audit_career.py: reproducible numerical references.
All datasets are synthetic. Build and explain your own workbook before using the answers. Public posting, applications and messages are exercises for you to choose and complete; the bundle does not send or publish anything.
मॉड्यूल प्रश्नोत्तरी (12)
1. Which lookup error does IFNA catch?
#N/A only
2. Merge vs Append in one line?
Merge adds columns by key; Append adds rows
3. What should you say after the definition?
When you use it, an example, and one trap
4. Which role is most often tested on speed with a raw data dump?
MIS Executive
5. Function for a loan EMI?
PMT
6. Formula for reorder point?
Daily usage × lead time + safety stock
7. How do you write "greater than the value in E1" as a COUNTIFS criterion?
">"&E1
8. Two-way lookup without XLOOKUP?
INDEX with two MATCHes
9. Exact match in MATCH needs which last argument?
0
10. First step with a messy file?
Protect the raw data / work on a copy
11. Why parse each date format explicitly?
Auto-parsing can turn 2026-01-10 into 1-Oct or fail on mixed formats
12. Clean total of the sample file?
₹32,90,500 from 32 invoices