6y
Good day! We appreciate your willingness to share feedback about our recruitment process. And we are glad to hear that our test task was challenging and interesting for you. Thanks again for the time you spent on completing it. We will try to address some of your concerns listed here. Hopefully, this will provide a bit more insights.
The task is designed in Google Sheets as we are using this tool in our day-to-day work and finances are not an exception. GSheets uses almost the same logic as Excel, so switching to a new tool should not be a problem (especially with the list of tutorials we provide together with the test task). And if you join us you will have to do it anyway, as well as learn 10+ other tools we use. This task also helps us evaluate the candidate's learning speed. From our experience, we saw a few different solutions for each point stated in the instruction. Our key target was to test how you manage data and make sure important parts are not missing.
We've also added a point with a few rows without data, but with an active status. As you have correctly mentioned, this is a common case. An example of such a situation is when a new person joins but does not provide data, and we need to request it. Our key criterion was to make sure you add all active records (even those without data). But there might have been a miscommunication between you and us at the feedback stage. We are truly sorry for that.
Such a review gives us more insights into how we can improve our feedback to candidates. We will continue polishing our approach.