The Notebook Review forums were hosted by TechTarget, who shut down them down on January 31, 2022. This static read-only archive was pulled by NBR forum users between January 20 and January 31, 2022, in an effort to make sure that the valuable technical information that had been posted on the forums is preserved. For current discussions, many NBR forum users moved over to NotebookTalk.net after the shutdown.
Problems? See this thread at archive.org.

    Help with sample excel file for an interview I have tomorrow

    Discussion in 'Windows OS and Software' started by theneighborrkid, Jun 28, 2012.

  1. theneighborrkid

    theneighborrkid Notebook Evangelist

    Reputations:
    161
    Messages:
    655
    Likes Received:
    0
    Trophy Points:
    30
    Howdy Folks,

    So earlier today I found out I had an interview tomorrow, and was just given a time, place, and contact name. Also I got this sample excel file with two questions to help me prepare. Only problem is, I don't know how to do them! I have some experience with vlookups and pivot tables, but not with something like this... It is just for an entry level hourly job, so I can't imagine it is that difficult.

    Link: comp-intel-interview.xlsx download - 2shared

    Thank you for any and all help!
     
    theneighborrkid, Jun 28, 2012
    #1
  2. TreeTops Ranch

    TreeTops Ranch Notebook Deity

    Reputations:
    330
    Messages:
    904
    Likes Received:
    124
    Trophy Points:
    56
    Weird download link. How do we know there isn't a virus in that file?
     
    TreeTops Ranch, Jun 28, 2012
    #2
  3. daver160

    daver160 Notebook Deity

    Reputations:
    148
    Messages:
    766
    Likes Received:
    5
    Trophy Points:
    31
    Indeed, I'm a bit wary of an Excel file uploaded to a fileshare platform. Why not zip it and upload it here?
     
    daver160, Jun 28, 2012
    #3
  4. theneighborrkid

    theneighborrkid Notebook Evangelist

    Reputations:
    161
    Messages:
    655
    Likes Received:
    0
    Trophy Points:
    30
    I forgot I could even do that... now it is here, although I have very little time before my interview.
     

    Attached Files:

    theneighborrkid, Jun 28, 2012
    #4
  5. jlyons264

    jlyons264 Notebook Evangelist

    Reputations:
    380
    Messages:
    474
    Likes Received:
    31
    Trophy Points:
    41
    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)

    I would tell them not to use excel and use access, but since you have to do it in excel. I would use vlookups and use a +1 statement when it comes out true. This will allow you to add multi if statements since there is 3 columns of information to digest.

    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?

    Use if/then statements between the columns. Use another set of three to give true/false statements and add them up.


    4. Please reach out the interviewer for any clarifying questions.

    I would ask why so over complex system.
     
    jlyons264, Jun 28, 2012
    #5
  6. TreeTops Ranch

    TreeTops Ranch Notebook Deity

    Reputations:
    330
    Messages:
    904
    Likes Received:
    124
    Trophy Points:
    56
    Yes, and if you also mention Access, they will think you are really smart and hire you.
     
    TreeTops Ranch, Jun 28, 2012
    #6
  7. Rob.In.AZ

    Rob.In.AZ Notebook Enthusiast

    Reputations:
    0
    Messages:
    46
    Likes Received:
    0
    Trophy Points:
    15
    Either that, or they'll expect him to have in-depth knowledge of Access...which he may or may not have.
     
    Rob.In.AZ, Jun 28, 2012
    #7
  8. theneighborrkid

    theneighborrkid Notebook Evangelist

    Reputations:
    161
    Messages:
    655
    Likes Received:
    0
    Trophy Points:
    30
    Thanks for all the help guys, surprisingly they just wanted me to talk about what I tried to do and I think it went OK.
     
    theneighborrkid, Jun 29, 2012
    #8