Ravindra BagaleCourses & study guides

16. Practice Exercises with Answer Hints

By Last updated:

Mitrano, Excel vachun yet nahi – karun yeta! Ya module madhe pratyek module sathi exercises aahet, aani pratyek exercise khali chhota answer hint dila aahe. Aadhi swatah prayatna kara, atakla tarach hint bagha. Roj 5 exercises – ek mahinyat tumhi ekdum confident vhal.

Use the fictional Blinkit_Maharashtra.xlsx workbook (Module 1.2) and the mini dataset of Module 3 for all exercises. Hints show the key function or ribbon path, not always the full answer.

Concepts in this chapter

  1. 16.1Modules 1–2: Basics and Data Entry
  2. 16.2Module 3: Formulas and Functions
  3. 16.3Module 4: Lookups
  4. 16.4Module 5: Data Cleaning
  5. 16.5Module 6: Tables, Sorting and Filtering
  6. 16.6Module 7: PivotTables
  7. 16.7Module 8: Charts
  8. 16.8Module 9: Dynamic Arrays
  9. 16.9Module 10: Power Query
  10. 16.10Module 11: What-If Analysis
  11. 16.11Module 12: Macros and VBA
  12. 16.12Module 13: Dashboards
  13. 16.13Module 14: Protection and Printing
  14. 16.14Mixed Scenario Exercises
  15. 16.15Challenge Exercises

The chapter recap is at the end of the last concept page.