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

Reply via email to