Prepare With JobTestPrep's Sample Questions
Below you will find Excel questions similar to the ones that will appear on the test. Take a look at the questions below to see where you are lacking and need improvement. Start an all-around preparation effort using Excel PrepPack™ and gain instant access to our best online resources to guarantee you pass your assessment!
Practice Online for the Excel 2016 Assessment Tests
Surpass the competition with the aid of our exclusive job recruitment preparation materials. We offer 24/7 access to a vast array of practice tests, study guides, and more to ensure your victory. Join us and begin practicing today!
Excel Sample Questions
To answer the sample questions, copy the following table to a new Excel spreadsheet. The cell marked with (A1) must be pasted in cell A1 on the spreadsheet. Once the table has been copied, continue to the following question.
| A | B | C | D | E | F | |
| 1 | Name | Surname | Position | Full Name | Age | Annual Salary* |
| 2 | John | Smith | Manager | John Smith | 35 | 85 |
| 3 | Jimmy | Michaels | Salesperson | Jimmy Michaels | 26 |
60 |
| 4 | Michelle | Levine | Manager | 37 | 80 | |
| 5 | Levi | Johnson | Tech | Levi Johnson | 40 | 75 |
| 6 | Jenna | Masterson | Salesperson | Jenna Masterson | 26 | 60 |
*In thousand USD
Basic Level Questions
- Align the Text to the right.
- Insert a new row between John and Jimmy.
- Set the Page Orientation to "Landscape".
Intermediate-Advanced Level Questions
- Highlight every cell with Annual Salary over 70 thousand USD.
- Under “Full Name”, in cell D4, write a function that combines the “Name” and the “Surname” (like in cell D3).
- Create a PivotTable for "Annual Salary" per "Age".
Learn About the 5 Most Common Topics on Excel Assessment Tests
Multiple-Choice Test Questions
Submit your answers to the questions below and fill the consequent form. A PDF file with answers and explanation for all questions will be sent to the email provided by you.
Prepare for Your Excel Test
Doing well on the Excel test can be the deciding factor for whether you get the job or not. Therefore, it is imperative that you practice. Prepare for your assessment with JobTestPrep's Excel Practice and get the position you are seeking.
Looking for more practice? Get the preparation you need with our other Excel PrepPacks™
Related Links:
| Free Mechanical Aptitude Test | Free Postal Exam 473 |
| Free Situational Judgement Test | Free Police Exam |
| Free Cognitive Assessment Test | Free Clerical Test Practice |