EXCEL EMPLOYMENT TEST INTERVIEW
EXCEL EMPLOYMENT TEST FOR JOB INTERVIEW
Rhynard Prins is a Business Development Manager, at Pragma Global, an Asset Management company. Based in South Africa, he holds a Bachelor of Engineering, Industrial engineering.
The test consists of 20 exercises about topics usually included in hiring tests developed by companies to assess candidates knowledge of Excel tools, functions and formulas.
The test is divided into two parts (10 problems each) with two different datasets. One of 20 and another of 850 rows.
All exercises are real, describe a regular situation or problem (based on the data provided) that you will have to solve using the most suitable Excel function or tool. Basically, these exercises replicate real world problems or situations that you may encounter at any position of wide range of industries.
Once you finish all the exercises, you will be more confident with Excel and gain the expertise and knowledge required to succeed any job interview.
1) Find duplicates
2) Cell formatting
3) Calculations with dates
4) Count values
5) Conditional formatting
6) Nested functions
7) Sort and filter data
8) Conditional statements
9) Array formulas
10) Drop down lists
11) Protect sheets
13) Analyze and perform calculations on a large dataset.
14) Named ranges
All questions are designed to test candidates applying for positions in engineering, finance, consulting, accounting, audit, etc that require an intermediate level of Excel.
The spreadsheets included in the project have been done with the latest Excel version. It is then compatible with Excel 2007, Excel 2010, Excel 2013 and Excel 2016.
You will receive a protected zip folder and its password in the email confirmation after purchase.
The file is made up of 2 PDFs and 2 Excel files:
– PDF with 20 questions.
– PDF with the solutions (14 pages). It includes detailed explanations about how to solve each problem and print screens with the formulas required to solve each problem.
– 2 Spreadsheets with two datasets.
If you need additional information, do not hesitate to contact us.
Specification: EXCEL EMPLOYMENT TEST INTERVIEW
Only logged in customers who have purchased this product may leave a review.