Looking for advise/recommendations taking my first excel test for an inventory planning position

Hello!

I was just told during a phone interview I will be moving forward and taking an excel test. I have never taken an excel test before and am incredibly nervous! I currently work as a supply chain buyer/planner for 3 years and though I work in excel most of the day its mostly from exported sheets that need very basic clean up to work off of. I rarely use formulas of any kind, used vlookup maybe a couple times, created a some basic spreadsheets and done only one version of a pivot table in that time. My knowledge in excel is rudimentary and I have very basic knowledge of how formulas work. I'm concerned I'll be in over my head and embarrassed during this test.

I have 1 week to prepare and am looking for any advise, things to specifically work on, or any practice tests recommendations regarding this field. Perhaps some stories on your experience with your first, or any excel tests you've taken as well. Thank you!