Important Facts about Intermediate Excel Tests
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.
Excel Assessment Test Sample Questions
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 |
Intermediate - Advanced Level Sample Questions
- Use the color red to fill in every income higher than 70 using conditional formatting
- Under "full name", combine the first and last name. (CONCATENATE function)
For more sample questions, with answers and explanations, click here.
FAQ
- Q: Will I be able to use the preparation kit again if I need it in the future?
A: Yes. Once you have purchased the kit, it is available for one year or 100 uses (whichever comes first). - Q: Is it necessary for me to have the corresponding version of Excel/Word?
A: Absolutely. You can only practice for these tests with the version of Excel/Word already on your computer. Therefore, you should have the relevant version for the test available before your purchase. - Q: Can I practice online?
A: No. You must install the software in order to practice. - Q: What if I don't have Excel/Word?
A: As already stated you can only practice using the Microsoft Office software installed on your computer. - Q: Will the preparation kit work with MAC?
A: No. Only Microsoft Windows is currently supported.
Prepare for Success
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.