I have take home Excel assessment for an associate a***yst role at a marketing company that I'm interviewing

Kind of having hard time with the assessment and would really appreciate some help

I was also laid off few months ago and been struggling to find a job since

Below are the questions and data set

Word file

mediafire.com/file/sst2cycenr108tj/Data_Set___Case_Questions.docx/file

Excel file

mediafire.com/file/m7bdnlea3akudgh/Applicant_Data_Set.xlsx/file

i might be able to help what’s the question?

Thanks, it's basically 9 questions that need to be answered

I was given data set and from there I made pivot table to answer the question but been having trouble

First question is - If the clients goal is to maximize revenue, which metric should they optimize towards?

@FBI

ROI?

Cook my books next

They should optimize for revenue

i was gonna say is this a trick question

Yeah it seems like the first question is theoretical

optimize towards amount spent to maximize revenue

give further details

=Concatenate("Whole lotta", " ", "$$$")

But forreal, we'd need more context like a picture of the data set

Updated op with pics

Updated op

Anyone?

S*** hard af

you're cooked G

They're asking too much for an entry level job that pays between 50-65k

Do your own job

Damn man ktt is getting f***ed with these jobs today

Where would you sign up to learn this? Seems interesting for me to learn as a graphic designer to see how testing my designs work for other clients.

This is a***ytical insights that marketing companies do to see how their kpi/campaigns are doing

basically data a***ytics

you posted a screenshot of the excel without any of the column names?

Id try the marketing subs on reddit. Theyre helpful