Hi Anand,

I would need the test for recruitment purpose. we are looking a highly
analytical person in our team and too good with excel skills.

Therefore , would need the test including some macro questions , good use of
excel functions / logical conditions. ( in short... advance excel test and
not basic excel test).

Thanks Anand.


Navneet

On Sun, Jul 10, 2011 at 9:14 AM, anandydr <anand...@gmail.com> wrote:

> Hi Navneet,
>
> If you could elaborate the purpose of this test it would be easier to
> generate a test. For example is this test for the purpose of
> recruitment? Do you plan to recruit MIS executives, or data entry
> operators or senior data analysts, or designers of dashboards,
> templates. Depending upon the complexity the number and complexity of
> questions would vary. Like the SUM ( ) function is volatile i.e. it
> would recalculate everytime the sheet is reopened so if someone is
> using sum or sumif function on a sheet say 500 or 1000 times the sheet
> would be very slow, instead DSUM should be used. A data analyst or a
> dashboard designer would know this but a data entry operator or MIS
> executive would not. Similarly there would be Macros and there
> performance issues. Would you need questions on macros as well??
>
> Please elaborate. I can be reached at anandydr at gmail dot com. I am
> sure many other group members would have readymade questions sets to
> help you with your case as well.
>
> Warm regards,
> Anand Kumar
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Reply via email to