Groups

    Excel Based Assessment Test

    Anyone had this sort of assessment for a job interview? Done loads of psychometric tests but never had one of these before. Any examples, ideas or advice on how to prepare for it / what to expect? Help only got today! I have intermediate MS Office skills, it's for a network technician role.

    15 Comments

    I have written assessment tests before when interviewing candidates.

    What specifically is Microsoft Excel going to be used for in the Network Technician role you are applying for?

    BFN,

    fp.

    PS. Good Luck!

    Excel based could mean one of two things; they either want to test your knowledge of spreadsheets (formulae, charts, macros etc) and excel in general, or they will give you a test made in excel (fill out answers in an excel cell next to the relevant question)

    I'm not sure, though, maybe someone else has had experience?

    Original Poster

    Yeah MarkyB that is exactly what I'm trying to figure out but I could not get any more information.

    Anyway I think I should concentrate on the formulae, macros side of things.

    fanpages Excel, from what I gather will be mainly used in an administrative capacity (to keep / log records)

    Xiwt

    Yeah MarkyB that is exactly what I'm trying to figure out but I could not … Yeah MarkyB that is exactly what I'm trying to figure out but I could not get any more information.Anyway I think I should concentrate on the formulae, macros side of things.fanpages Excel, from what I gather will be mainly used in an administrative capacity (to keep / log records)



    If that is the extent of the usage I would concentrate on reading the "Lookup and reference functions (reference)" section of the Microsoft Excel Help file [primarily the HLOOKUP, VLOOKUP, & LOOKUP functions; possibly MATCH & INDEX as well) & familiarising yourself with the "Data" menu options (Sort, Filter, Subtotals, & so on).

    Knowing how to use the "Math and trigonometry functions (reference)" functions, specifically =SUM, =SUMIF, =SUMIFS (depending on which version of Excel you are going to be using), =SUMPRODUCT are always helpful for more complex total & sub-total usage.

    Apart from that, do you know how to use Excel on a day-to-day basis already? Are you happy with what a cell is... a row... a column... a range... moving around (including keyboard shortcuts) & what menu options does what function?

    I am presuming you do not need to understand how to program using Visual Basic for Applications.

    However, why the rush to "cram" information today? Did you not have advance warning? If this interview has been sprung on you quickly, & you do not know what you are to be interviewed on, could you not have asked for an appointment later in the week?

    Additionally, if Excel is a fundamental requirement & you do not have these skills, are you sure this is the right role for you?

    BFN,

    fp.

    Original Poster

    Ok. I'm pretty sure now that this assessment will be specifically looking to test Excel specific skills to some degree.

    Original Poster

    fanpages

    If that is the extent of the usage I would concentrate on reading the … If that is the extent of the usage I would concentrate on reading the "Lookup and reference functions (reference)" section of the Microsoft Excel Help file [primarily the HLOOKUP, VLOOKUP, & LOOKUP functions; possibly MATCH & INDEX as well) & familiarising yourself with the "Data" menu options (Sort, Filter, Subtotals, & so on).Knowing how to use the "Math and trigonometry functions (reference)" functions, specifically =SUM, =SUMIF, =SUMIFS (depending on which version of Excel you are going to be using), =SUMPRODUCT are always helpful for more complex total & sub-total usage.Apart from that, do you know how to use Excel on a day-to-day basis already? Are you happy with what a cell is... a row... a column... a range... moving around (including keyboard shortcuts) & what menu options does what function?I am presuming you do not need to understand how to program using Visual Basic for Applications.However, why the rush to "cram" information today? Did you not have advance warning? If this interview has been sprung on you quickly, & you do not know what you are to be interviewed on, could you not have asked for an appointment later in the week?Additionally, if Excel is a fundamental requirement & you do not have these skills, are you sure this is the right role for you?BFN,fp.



    Thank you for this.

    I was just informed today and there was no choice on the date.

    I do know how to use Excel on a day-to-day basis and quite comfortable with the concepts of a spreadsheet package and the menu functions, I'm not a real whizz with keyboard shortcuts though.

    No there is no programming requirement.

    It's just because my Excel skills have never really been formally tested or assessed to any degree at all, which is why I want to make sure I prepare as thoroughly as possible.

    Sounds like you just have a touch of pre-interview nerves then.

    If there is no specific requirement other than "normal" usage, & you have that, then please do not worry yourself unnecessarily.

    Of course, though, reading how to use certain functions/formulae so the answers are fresh in your mind will help for tomorrow, but I suspect you have other things to go over that are more prevalent for the role to "revise" first.

    If you know how to use MS-Excel, but do not know how to do a specific function when a business task requires it, the fact you can demonstrate how you would go about finding out how to do it is probably all the interviewer is looking for.

    BFN,

    fp.

    Original Poster

    Just did these 3 ten minute quick multiple choice excel assessments, passed all, few errors here and there and a few educated guesses.

    hostedtest.com/Tak…ls1

    just change 1 to 2 and 3 at the end for the others.

    Yes I think it is nerves indeed!

    Edited by: "Xiwt" 28th Feb 2011

    Original Poster

    I want to practice some Excel assessments like this.

    If anyone has any links to anymore I'd be really grateful if you could post them in this thread.

    Thanks a lot for your help fanpages and MarkyB

    Original Poster

    fanpages, is it this you suggest to try? I tried clicking the link in your post above but it says "Access denied. Unable to proceed due to improper call of Perception.

    If you are running Perception from a Management System or Portal, please check this system is calling Perception correctly. Information to help diagnose this is in the pip.log file.

    Otherwise the system administrator can determine the reason for this by checking the Perception log files."

    Xiwt

    fanpages, is it this you suggest to try? I tried clicking the link in … fanpages, is it this you suggest to try? I tried clicking the link in your post above but it says "Access denied. Unable to proceed due to improper call of Perception.If you are running Perception from a Management System or Portal, please check this system is calling Perception correctly. Information to help diagnose this is in the pip.log file. Otherwise the system administrator can determine the reason for this by checking the Perception log files."



    Yes, that's the one; the questions are random from what I've seen so you can use the link a few times. It is not a site I've used before; I just searching for something (using Google.com) when you asked for further examples.

    The link I provided must have worked on my local machine because I already had the client-side cookie for the site.

    If you link works use that instead

    BFN,

    fp.

    Original Poster

    Yes these questions are random and much better because they are more practical based... I've done it twice getting lower scores between 50-60%. I think I will concentrate on the functions you mentioned initially and make sure I am fully comfortable with those.

    How did your interview go?

    Well, I trust.

    BFN,

    fp.

    Original Poster

    Hi,

    Yes it went very well thanks. The Excel assessment only touched on very basic Excel skills.

    It was more about testing administrative / initiative skills to source appropriate info /pricing from the net for certain parts and prepare accurate orders to maintain minimum stock levels.

    I suppose you could have done it without any formula really but I used some to save time as there was deliberately more tasks to do than possible in the time (20 min). Finishing the tasks was not the point though, I took a systematic approach and so I'm happy with how I worked and what I achieved in the time.



    Post a comment
    Avatar
    @
      Text
      Top Discussions
      1. Just heard this...2 ★★★★★★★★★★★★★★ congrats to all on 392k ★★★★★★★★★★★★★★7767252
      2. Lets hope that there are as few injuries as possible - Parson's Green40214
      3. Quidco and new IPAD 'Prevent Cross-Site Tracking'11
      4. word association Game73944481

      See more discussions