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.
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 |
For more sample questions, with answers and full explanations, click here.