Analyst
Junior Analyst
Project
Meridian Retail Co. · Excel · beginner
The brief
Same crisis, spreadsheet view. In the inventory sheet of the data file, use conditional formatting to turn every negative stock_qty cell red, then use a counting formula to state how many rows are negative. Managers will scan this sheet in a hurry: the red must be impossible to miss.
Independent grading
62/100
Achieved 1 Nov 2026
Graded automatically against a fixed rubric for this task. Feedback and submitted work remain private to the analyst.
What is DataSimHQ?
A practice platform where analysts complete graded business tasks for simulated companies in SQL, Power BI, and Excel, and build a portfolio of proven work. Learn more