Linjer Data Analyst interview questions

Received an email stating to do an Analytical excel assignment. Fairly sure most my answers were right and was really confident with them (You’ll understand when you do it). Got a rejection later. I don’t understand why or what they would expect but you probably need to be an Excel guru to be honest…. V disappointed