Ravindra BagaleCourses & study guides

16. Practice Exercises with Answer Hints

16.15 Challenge Exercises

By Last updated:

  1. A Diwali-week report (fictional dates 06-11-2026 to 12-11-2026): day-wise sales per city with a spike chart and a slicer for Platform. Hint: Timeline filtered to the week; line chart from pivot.
  2. A single dynamic formula that returns the top 3 products per city. Hint: TAKE(SORT(FILTER(...),2,-1),3) inside a per-city layout or with REDUCE/VSTACK (Microsoft 365 / Excel 2024).
  3. A macro that splits tblOrders into one sheet per city and saves each as a separate workbook. Hint: extend 12.12 C; Worksheets(city).Copy then ActiveWorkbook.SaveAs.
  4. Build the bank-statement folder query of Module 10 for three months and reconcile with a manual total. Hint: From Folder › Combine; compare SUM of each file.
  5. Create a LAMBDA named DELIVERYFEE that returns the slab fee. Hint: Formulas › Name Manager › New: =LAMBDA(amt,XLOOKUP(amt,{0;99;199;499},{30;25;15;0},,-1)) (Microsoft 365 / Excel 2024).

Ravindra Bagale's Tip

Many students give up when they get stuck on the challenge exercises. Break a big question into small steps – do it for one city first, and once it works, for all cities. If you get stuck, look at the hint, but type the answer yourself instead of copying it.

Thodkyaat sangaycha tar (quick recap)

  • Pratyek exercise swatah Excel madhe kara; hint shevti bagha.
  • Formula challa tari 2–3 rows manually check kara.
  • Scenario prashnat aadhi approach, mag formula.

Aata pudhe jaauya – interview questions!