Excel Test / Data Analysis (vs. Investment Modelling)

Hi everyone,

Looking for a role atm at an associate level and obviously facing modeling test / case study from 1h to 48h... 

Came across a modeling test from Savills OCM (M&A, Financing, blablabla...) basically the RE "IB" from Savills, I guess that it could make sense to move there and then back to REPE at a nice shop due to the nice deal-flow they have across Europe. They ask their candidates to take a 45 min excel data analysis + 1h30 multifamily modelling test. (Any thoughts on this role would be much appreciated)

Modelling test: super easy, probably the easiest I came across, basic assumptions, I/O Debt, IRR/EM output, 3 sensitivities and that's all.

Data test was horrible, extremely messy doc composed of 8 tabs of demographics numbers related to London Boroughs some with dates some without (Age, House Price, Employment, Earnings...) 

You're supposed to assume we're in 2023, some data is from 2003 to 2015 some 2003 to 2027... Proper mess. It is asked to advise a client entering London's multifamily market, giving him the best Borough using at least 2 of the 8 tabs: create 3 graphs + write 3 bullet points (that's all).

That being said, I'm starting to fear these excel tests vs. investment modeling which I'm comfortable with. I've been told by a REPE shop after an interview with the partner that he would send me a 1h excel test tomorrow that will require 20 min of my time based on my CV... Potentially CF modelling which would be fine, but I'm starting to dread receiving a weird excel test not really linked to an investment/development. 

Anyone in a position to share excel test / data test??? Happy to trade with modelling tests I have from different funds (Living, Industrial, Office).

Thanks