Excel Based Assessment Test - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HUKD, you accept our cookie and privacy policy.
Get the HUKD app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

Excel Based Assessment Test

Xiwt Avatar
5y, 10m agoPosted 5 years, 10 months ago
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.
Xiwt Avatar
5y, 10m agoPosted 5 years, 10 months ago
Options

All Comments

(15) Jump to unreadPost a comment
Comments/page:
#1
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! :)
1 Like #2
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?
#3
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)
#4
Xiwt
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.
#5
Ok. I'm pretty sure now that this assessment will be specifically looking to test Excel specific skills to some degree.
#6
fanpages
Xiwt
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.


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.
1 Like #7
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.
1 Like #8
Just did these 3 ten minute quick multiple choice excel assessments, passed all, few errors here and there and a few educated guesses.

http://www.hostedtest.com/TakeTest.asp?c=Sample-skills1

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

Yes I think it is nerves indeed!


Edited By: Xiwt on Feb 28, 2011 15:21
#9
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
#10
#11
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."
#12
Xiwt
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.
#13
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.
1 Like #14
How did your interview go?

Well, I trust.

BFN,

fp.
1 Like #15
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

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!