Hi All,
I tried to compose a thread with links to pictures etc, but because I just joined, I cannot do so before a few posts.
I am in need of some help using excel, which I have not done in over 15 years.
In the process of applying for school based roles as an exams officer and in all shortlisting and interview process, schools require candidates to do an excel based exercise. In a recent interview last week, I tried to use vlookup but was running against a clock to complete the other exercises, so instead did it manually - thankfully there were not many records.
I have a few more interviews coming up this week and next, and I want to be ready for any excel exercises. So I tried to do the one from last week using vlookup etc. but cannot get my head round it. And I am sure, there are easier ways of doing things than what I did - I wish I can post with pictures to show the exercise and what formulas I've used.
The exercise is:
"On the excel spreadsheet there is an entry sheet received from the Science department asking you to confirm the pupils have been entered for the correct exam.
As you will see, there are three possible tiers for this exam:
• Higher – Exam code – A217H.
• Intermediate – Exam code – A217I
• Foundation – Exam code – A217F
There is also a report printed from the Academy’s exam system confirming the actual entries sent to the exam board.
Please cross-check the two documents and identify whether pupils have been entered in accordance with the Science department’s wishes. Highlight in yellow any mistake or queries you might wish to discuss, and leave additional comments that explain what your queries are."
I will post soon as I am able to with pictures etc.
Thanks,
Jay
Bookmarks