Preparing for Interview would like some help

Hello all,

I have an interview and was given this sample file to prepare me for doing something similar during an interview. This is just an entry hourly position so it isn't something crazy.

Here are the two questions from the file:

1. Sub-vertical Frequency - You are tasked with finding how many deals got tagged with each unique sub-vertical. Please have a final table that lists each unique sub-vertical and how many deals got tagged with it (remember: a deal can get tagged with up to 5 sub-verticals so you will need to take that into account)

2. Sub-Vertical Accuracy - Assume that "RawData" is not perfectly accurate and "TrueData" is perfectly accurate. You want to measure how accurate "RawData" is compared to "TrueData". How would you do this?

For 2. I would think you could do paste the "TrueData" sheet into the "RawData" sheet side by side and then put an =if(blahfromTRUE=blahfromRAW,1,0) and then filter for things with a 0 to show what is not accurate.

For 1 I am not as sure since in "RawData" there is a slash separating the vertical and subverticial.

Thank you in advanced for all help!