Important Facts About Advanced Excel Tests
The advanced level test is aimed for candidates who will manage a large amount of data and use the software at high capacity. It therefore requires a candidate to master the different features of the software. This doesn't mean you won't see any basic or intermediate questions on the advanced level test. They will, however, be the minority. Most of the questions will deal with formulas, macro creation, advanced formatting and document properties. Make sure to review the different topics to best prepare.
Excel Assessment Test Sample Questions
Here are some sample Excel test questions which could appear on an interactive test. 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 and choose "copy". On the Excel worksheet choose the first cell on the left (A1), right click and choose paste. Make sure that the cell named A1 is indeed located at cell A1 on 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
- Fill in with red every income higher than 70 using conditional formatting
- Under "full name," combine the first and last name using the CONCATENATE function
For more sample questions, with answers and full 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.