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