live skills assessment in excel

Hi folks!

This might not be what’s allowed in this sub so I apologize if this isn’t the right place but I have a live skills test in Excel coming up. I have no idea what the contents will be or what data I’ll be using. I’ve used this subs resources (Thank you!) and I’ve been reviewing what I know already, so I’m not asking for a list of things to know (although I always appreciate that) but more of advice how how to remain collected when analyzing in Excel, if any of you have done an assessment on camera like this, what was it like, and how to… excel:)

I used Excel a lot in my Master’s and in my previous role but nothing fancy. VLOOKUP, Pivot Tables, IF statements (CountIF and SumIF), basic visualizations, etc, but I am way more comfortable coding in R and SQL, and feel like that’s more where my skill set lies than in Excel. I also get really anxious when people watch me work, and the only other live skills test I ever did, I bombed horribly.

Have any of you done an assessment like this and have any recommendations on how to go about it?

Thanks and sorry again if this is not a good place to post this!!