Ravindra BagaleCourses & study guides मराठी Track your progress

16. Practice Exercises with Answer Hints

Friends, you cannot learn Excel by reading – you learn it by doing! This module has exercises for every module, and a short answer hint under each exercise. Try on your own first, and look at the hint only when you are stuck. Five exercises a day – in one month you will feel fully confident.

Live story: Practice before the real file

Suppose Ravina has read every chapter but freezes when a real file opens. Reading is not doing. This chapter gives short exercises on the same fictional Blinkit data for every module, each with an answer hint. Try first, check the hint only when you are stuck, and do five a day.

All numbers in this story are fictional practice data.

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.