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