16. Practice Exercises with Answer Hints

16.1 Modules 1–2: Basics and Data Entry

By Ravindra Bagale · Last updated: 25 September 2026

1. 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.
2. In Report!B2 calculate Amount × GST rate where the GST rate is in F1, and copy it down 10 rows so F1 stays fixed. Hint: =A2*$F$1; press F4 to add the dollar signs.
3. Format 1250000 so it shows ₹12,50,000. Hint: custom format [>=10000000]₹##\,##\,##\,##0;[>=100000]₹##\,##\,##0;₹##,##0 (Module 1.5).
4. Show order dates as 14-03-2026 regardless of how they were typed (real dates only). Hint: Ctrl + 1 › Custom › dd-mm-yyyy.
5. 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).
6. 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.
7. 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").