The intermediate Excel test can appear under different names: some companies will refer to it as "standard test", other calls it: "normal user" etc.
Though companies usually hold an intermediate question bank, many of them doesn't offer an intermediate test. For those who do offer such a test, it is unlikely to get medium level questions alone, but rather questions of various levels from basic to advanced. In fact, what differentiates the tests from each other is the ratio between the numbers of questions at each level.
Your practice should cover a wide variety of topics, and include advanced tasks. That, in order to make sure you master as many questions as possible.
In order to properly practice the following questions, copy and paste the chart below to a clean Excel worksheet (left click, hold and drag to mark the table, right click – choose "copy" , at the Excel worksheet choose the first cell on the left (A1), right click – choose paste). Make sure that the cell named A1 is indeed located at cell A1 at your worksheet.
First name (A1) | Last name | Department | Full name | Age | Annual income (th. $) |
---|---|---|---|---|---|
Elisabeth | Aragon | Finance | Elisabeth Aragon | 23 | 55 |
Marlo | Acogny | R&D | 21 | 76 | |
Molly | Freedman | Finance | 25 | 60 | |
Kathleen | Allen | R&D | 26 | 75 | |
Renee | Hobbs | R&D | 25 | 60 |
For more sample questions, with answers and explanations, click here.
Your Excel test can be the deciding factor in whether you get the job or not, and it is imperative that you do well on it. Prepare for each assessment with JobTestPrep's Excel package and get the position you want.