16. Practice Exercises with Answer Hints
16.1 Modules 1–2: Basics and Data Entry
- Create sheets
Orders,Stores,Products,Report; colour data tabs green and the report tab blue. Hint: right-click tab › Tab Color; Shift + F11 inserts a sheet. - In
Report!B2calculate Amount × GST rate where the GST rate is inF1, and copy it down 10 rows soF1stays fixed. Hint:=A2*$F$1; press F4 to add the dollar signs. - Format 1250000 so it shows ₹12,50,000.
Hint: custom format
[>=10000000]₹##\,##\,##\,##0;[>=100000]₹##\,##\,##0;₹##,##0(Module 1.5). - Show order dates as 14-03-2026 regardless of how they were typed (real dates only).
Hint: Ctrl + 1 › Custom ›
dd-mm-yyyy. - Create a drop-down in the City column that allows only the six cities.
Hint: Data › Data Tools › Data Validation › List › source
=Cities(a named range or Table column). - Allow only whole numbers 1–20 in Qty, with an error message "Qty must be 1 to 20". Hint: Data Validation › Whole number › between 1 and 20 › Error Alert tab.
- Fill Order IDs BLK-001 to BLK-100 without typing each.
Hint: type BLK-001, drag the fill handle; or
="BLK-"&TEXT(ROW()-1,"000").
Ravindra Bagale's Tip
Many students skip this basic section saying "I know this" – and later get stuck on F4, custom formats and Data Validation. Do every exercise yourself at least once, even if it seems easy. Knowing where a button is also gets tested in interviews.
Ravindra Bagale's Tip – मराठी
बरेच students हा basic section "येतं मला" म्हणून सोडून देतात – आणि नंतर F4, custom format आणि Data Validation मध्ये अडकतात. सगळे exercises एकदा तरी स्वतः करा, अगदी सोपे वाटले तरी. Button कुठे आहे हे माहीत असणं पण interview मध्ये तपासलं जातं.
Ravindra Bagale's Tip – हिंदी
बहुत से students इस basic section को "मुझे आता है" कहकर छोड़ देते हैं – और बाद में F4, custom format और Data Validation में अटकते हैं. सारे exercises कम से कम एक बार खुद करो, भले आसान लगें. Button कहाँ है यह जानना भी interview में परखा जाता है.