I need to create a test that will test new hires capabilities with excel. I know vlookups and pivot tables are essential, but beyond that I can't think of much. I use a lot of functions which I'm sure are not required for the job. Does anyone have a test or has gone through the process of creating one before?