Interactive Test Questions
Below are sample questions to give you a sense of what you will face on your test.
Please copy the table below and paste it in a new Excel spreadSheet. Make sure the table is aligned correctly and that the cell marked A1 is pasted in Cell A1 on the spreadsheet.
| A | B | C | D | E | F | |
| 1 | Producer | Model | Type | Full Model Name | Year | Yearly Sales (Mil, US Dollars) |
| 2 | Vonda | GLE | Mini | Vonde GLE | 2009 | 65 |
| 3 | Zord | Triple | Pick-Up | 2010 | 85 | |
| 4 | Gaudi | Zoon | Mini | 2012 | 45 | |
| 5 | Menz | Citrus | Family | 2009 | 65 | |
| 6 | Buzuki | Sun | Family | 2008 | 70 |
Basic Level Questions
- Change the table's alignment to Center.
- Insert a new column Below Menz.
- Set the Page Orientation to Landscape.
Intermediate-Advanced Level Questions
- Highlight all cells with Yearly Sales above 60 (mil. $).
- In cell D3, write a function that combines the "Maker" and the “Type” (like in cell D2).
- Create a PivotTable for Annual Sales per Year.
Multiple Choice Test Questions
Submit your answers to the questions below and fill the consequent form. A PDF file with the answers and explanation will be sent to the e-mail you provided.
Prepare For Success
If you need more extensive preparation look no further than our complete test package. This test is just a sample and by no means is a full preparation for the real test. Ensure you are fully prepared with our top quality PrepPacks™.
JobTestPrep is not a part of Microsoft and is not related to them in any way. JobTestPrep offers preparation services for psychometric tests.
