Spreadsheet Test For Interview – One of the elements that can not be missing from your CV is your Excel level. But in the same way that the recruiter can ask you to provide proof of your training, your knowledge of languages or your working life, it is possible that during the job interview you will be given a test to prove Excel level. That said, it may seem more complex than it really is, but if you have been sincere in your CV you have nothing to fear. Still, let’s see the keys to demonstrate your Excel level in a job interview.
Excel tests in a job interview
As you well know, Excel allows us to do an infinite number of operations, so to guess the test that will make us pass in the interview to demonstrate the level of Excel we have is almost impossible. What we do have is a series of tests that are usually chosen by recruiters to check if the candidates have been honest with their knowledge of Excel in the curriculum or if they have inflated and really are not as prepared as they say they are. Some tests that you can practice with Excel exercises.
Thus, they can make us use functions such as DESREF, INDIRECT or ADDRESS. The first is a function that returns a reference to a range that is a number of rows and columns of a cell or range of cells, INDIRECT points to some fixed coordinates and can be used at the same time as the ADDRESS function, which serves to find the reference of a cell on a sheet. These are just some examples, but before the interview it is recommended that you exercise with the functions of Excel and its syntax so that you do not get caught by surprise.
Another thing that you can ask to demonstrate the level of Excel you have is the creation of a dynamic table or link an Excel table to a Power Point, something that if you are hired you can find yourself in your day to day. Once again, the key to successfully passing the test is to practice. They can also ask you to record a macro and enter some small modification. Although it is not usually the most usual, it never hurts to review the macros and VBA before going to the job interview.
Spreadsheet Test For Interview
Tips to demonstrate your experience with Excel
Beyond having practiced with the different tests that you can put in the job interview, there are a series of tricks or guidelines that you should follow when facing Excel exercises. The first of all is not to complicate your life with the exercises by yourself. Look for a simple example, and do not try to demonstrate a higher level than the test requires you with a difficult example. Make it as simple as possible, since the more difficult you want to do it the easier it is for you to make mistakes. You will have time to demonstrate your level of Excel in the future.
You should also take advantage of the data in the formulas to create the pivot table. Do not improvise or leave anything in the hands of chance, make a dynamic table that will work, however simple it may seem. Finally, remember to apply format to your Excel test so that it is not the same as the other candidates. Add bold, titles or boxes, to give some examples, it helps you improve your presentation. Generally they give us about 30 minutes of time for the test, of leftovers to demonstrate the level of Excel if you have not lied about this point in your curriculum.
Gallery of Spreadsheet Test For Interview
( Click Image to Enlarge )
- Spreadsheet For Business Plan
- Simple Spreadsheet For Ipad
- Scrum Spreadsheet Template
- Simple Accounting Spreadsheet For Small Business
- Sample Excel Spreadsheet For Practice