Prepare With JobTestPrep's Sample Questions
Below you will find Excel questions similar to the ones that will appear on the test. Practice with the questions below to see where to focus your preparation efforts and see where you need to improve.
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.
| Name (A1) |
Surname |
Position |
Full Name |
Age |
Annual salary
(th. USD) |
| John |
Smith |
Manager |
John Smith |
35 |
85 |
| Jimmy |
Michaels |
Saleperson |
26 |
60 |
| Michelle |
Levine |
Manager |
37 |
80 |
| Levi |
Johnson |
Tech |
40 |
75 |
| Jenna |
Masterson |
Salesperson |
26 |
60 |
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 Sales over 70 (th. $).
- Under “Full Name”, in cell D4, write a function that combines the “Name” and the “Surename” (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:
