Free Excel Practice Test
Welcome to the free Excel test by JobTestPrep. Here you can get a taste of what we offer in our interview Excel test prep packs. Good luck!
If at some point you don’t understand the questions or you are uncertain on how to proceed don't worry, our Excel prep packs feature tests and tutorials covering these topics and many more.
|Practise Intermediate-Advanced Excel Tests for Interviews|
Get two full-length interactive tests + 180 practice questions!
Interactive Test QuestionsWe have gathered a few sample questions to give you a sense of what your might face on you 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 |
|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 QuestionsSubmit your answers to the questions below and fill the consequent form. A PDF file with the answers and explanation will be sent to the Email provided by you.
Back to top
Excel 2013 Inter./AdvancedExcel + Word 2010 Pack
"Your products increased my score a lot in the test."