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

Khup students challenge exercises madhe atkale ki sodun detat. Motha prashna chhotya steps madhe toda – aadhi ekach city sathi kara, chalala ki sagle cities. Atakla tar hint bagha, pan uttar copy na karta swatah type kara.

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!