Verified by DataSimHQ

Analyst

Aliyu Usman

Junior Analyst

Project

Flag the Negative Stock

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