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.
| Producer (A1) |
Model |
Type |
Full Model Name |
Year |
Yearly Sales
(mil,USD) |
| Vonda |
GLE |
Mini |
Vonda GLE |
2009 |
65 |
| Zord |
Triple |
Pick-Up |
|
2010 |
85 |
| Gaudi |
Zoom |
Mini |
|
2010 |
45 |
| Menz |
Citrus |
Family |
|
2009 |
65 |
| 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
Looking for a comprehensive preparation experience? Try JobTestPrep's Excel preparation packages and enable your success.
JobTestPrep is not a part of Microsoft and is not related to them in any way. JobTestPrep offers preparation services for psychometric tests.
