I am new to this forum. I'd like to get some help from the experts.

I have an interview to attend and I was told that I'll be given data to work with in Excel.

"X company needs to know their market share for gasoline product in which there are 2 market participants. Be prepared to take a data set to be provided at the interview and use a pivot table to organize the data and calculate the market share development over a period of time."

What would be best way to approach such questions? What are the possible ways I could handle such questions?

any help/advice is highly appreciated!