Hello,
When hiring in the past, I've created various excel test to ensure competencies. In the first few questions, I would focus on formulas that have the broadest appeal and everyday use. In the later questions, we could focus more on the formulas that would be most applicable to your industry.
It would be my pleasure to work on this project for you.
Best,
Nate