This is similar to the Interactive Test above but covers only the most vital and commonly used Excel operations. Some Excel shortcuts will also be inactive.
EXAMPLES OF USES OF MICROSOFT EXCEL SOFTWARE
Unlike working with Excel for real, the interactive software does not allow much room for trial and error, so formulas and functions must be spelled correctly. There are a maximum of 30 questions with a time limit of around 35 minutes. Each question consists of a task for the user to complete, along with accompanying data. This is taken on interactive software that simulates the use of Excel’s interface. Let's examine each of those: Interactive Test SHL provides three different types of Excel skills test: Interactive, Interactive-Essentials and Adaptive. The most popular are the SHL Microsoft Excel tests and the Kenexa Prove It! Excel tests. Many of the psychometric test companies that candidates might be familiar with from previous job application assessments also provide Excel skills test. Here candidates must complete a series of tasks on an Excel spreadsheet, according to their skill level.Ĭandidates will be asked to sit a basic, intermediate or advanced level test, depending on the position they are applying for.
The simulation format is more common for Excel tests.
The multiple-choice questions are pulled at random from a large pool of possible questions, so no test is the same. Multiple-choice tests will include questions covering every area of the software, so candidates will need to be very familiar with key functions and layout. In the majority of cases, companies will use specifically designed software from a test provider.
This would usually be an interactive test and will often involve working with Excel software itself. Some companies will set a test they have built themselves. The Excel test may be presented as a series of multiple-choice questions or it may use interactive software to simulate the use of Excel’s interface.