Am I cheating!?

Kind of a gray area. It is cheating because I assume you’re not supposed to look it up and be able to do it. BUT in the office, you can look it up, every now and then I see posts on here asking how to do various things in excel and whatnot...so your call.

Do as you wish but remember if you get the job and you really don’t know how to perform tasks on Excel then you’re fucked. 

A company I have been interviewing with gave me an excel test that I have about a week to do and I honestly do not know how to do a lot of it. That being said I can find how to do it by looking at other models and videos online. By using those as a reference am I misrepresenting my skills or would they expect me to use outside resources. 

I wouldn't hand in something you downloaded off the internet with the details populated in, but I don't think it's wrong to use an outside resource.  In my experience, people in real estate don't give a shit if you're good at modeling, they want you to understand the how and why of what goes into and comes out of an underwriting.  If you can show you understand the material, and show you know why your underwriting is spitting out the result it is, that carries a lot more water.  You can always learn more later.  And moreover, it's a results oriented business, not a process oriented one like a junior banker is expected to go through, so just getting the job done without a lot of fuss looks resourceful.

Honestly, mixed feelings on this one. If you can "learn" how to do it quickly, and then actually do it, that is one thing. If you are essentially copy and pasting and just getting by marginally to get it done..... then, what will you do if you get the job? You would have to crash course learn this stuff beforehand, which is doable!! The flip side is that you may likely screw it up and turn in wrong numbers (which is sort of a solution in and of itself). 

I would advise a bit of humble, honesty.... Turn it in and just be honest that you had to stretch yourself to complete it, and that if given the opportunity you will crash learn everything you need before day one. If this turns them off from you (and honestly, I very much think it can), then you are probably not a great fit for job. If they appreciate the honesty and effort, then it may be a great fit. People don't start out knowing everything, it's okay, but being honest is really key. Some places care more than others, and some even like to help train people so you learn how to do it 'the right way'. 

If you can leverage resources while doing your job, there is no reason why you can't leverage resources while doing an online modeling test.  If they wanted it done from scratch there would be a strict time frame.

You're not cheating. One way firms get around virtual exams is to set a hard time limit. I've had both types--the ones with a time limit (between 1 - 3 hours) are usually set up in a way that should take you the entire time to complete the exam, leaving barely any wiggle room to learn something new online for the exam. The ones without a time limit are just testing whether you can get something done correctly, and sometimes speed does matter even if they don't specify (e.g. sending it in the day after you receive the exam, or even the same night). 

Mother Theresa, use the resources available to you and handle your business. Hope you get the offer.