PGC Assessment Center
Complete the 25-minute assessment and submit your answers before the timer ends.
Assessment Setup
Which position are you applying for?
*
Field Coordinator
Data Management
Your details
Full name
*
First Name
Middle Name
Last Name
Email
*
example@example.com
Phone number with country code
*
Please enter a valid phone number.
Format: (000) 000-0000.
City and country
*
Confirmation
*
I confirm I am completing this assessment alone, without help from other people or AI tools, and I understand the 25-minute limit.
Part 1: Reasoning, creativity and problem solving (35 points)
1.1 What comes next: 3, 7, 15, 31, 63, ?
*
95
125
127
131
1.2 No coordinators are careless. Some careless people are fast. Which conclusion MUST be true?
*
Some fast people are not coordinators
No fast people are coordinators
All coordinators are fast
Some coordinators are fast
1.3 Technician A can paint a wall in 6 hours. Technician B can paint the same wall in 3 hours. Working together at these speeds, how long will they take?
*
4.5 hours
3 hours
9 hours
2 hours
1.4 A phone and its case cost $120 together. The phone costs $100 more than the case. How much does the case cost?
*
$20
$10
$5
$15
1.5 A rope ladder hangs over the side of a ship, and 10 rungs are under water. The rungs are 30 cm apart, and the tide rises by 90 cm. How many rungs are under water now?
*
13
7
10
6
1.6 What comes next: AZ, BY, CX, DW, ?
*
EU
FV
EW
EV
1.7 Your team must cut delivery time by 20% with no extra budget and no extra staff. Which idea is the most creative AND realistic?
*
Ask everyone to work longer hours
Offer customers a discount for choosing later delivery slots
Reduce the number of products you sell
Batch deliveries by neighborhood and time window, and reorganize the picking order so the most frequent items sit closest to the loading door
Part 2: Common sense and English (30 points)
For questions 2.4 to 2.6, choose the pair of words that correctly fills the blanks, in order (first blank / second blank).
2.1 Two managers give you conflicting instructions on the same urgent task. What do you do?
*
Follow the more senior manager without telling the other
Ask both to confirm the priority together, and escalate to a common manager if they still disagree
Do half of each instruction
Wait until one of them notices
2.2 You discover a mistake in a report that was already sent to a client, and nobody has noticed. What do you do?
Say nothing, since the client has not noticed
Correct it quietly in next month's report
Tell your supervisor right away and send the client a corrected version with a short explanation
Blame the template
2.3 A client sends an urgent request at 6:55 PM, five minutes before the end of the day, and it cannot be finished tonight. What is the best response?
Acknowledge it now, say who owns it, and tell the client when they will get a first update
Reply tomorrow morning
Forward it to a colleague without informing the client
Ignore it until the client calls
2.4 "The client said that ____ contract expires on Friday, so ____ important that we confirm the renewal today."
it's / its
its / it's
its / its
it's / it's
2.5 "The new schedule will ____ our deadlines, and the ____ on morale is still unknown."
effect / affect
affect / affect
effect / effect
affect / effect
2.6 "We received ____ complaints this month ____ last month, so I think our changes worked."
less / then
fewer / then
fewer / than
less / than
Part 3: Field Coordinator (35 points)
3.1 Two priority-1 jobs must both be finished within 3 hours from now. Job A needs 40 minutes' travel and 2 hours' work. Job C needs 30 minutes' travel and 1.5 hours' work. The two sites are 30 minutes apart, and you have one technician. What is the best decision?
Send him to A first, then C, since A is longer
Send him to C first, since it is shorter
Recognize that neither order meets both deadlines, so assign a second technician or a subcontractor to one job now and update the client
Do the closest priority-2 job first to save travel time
3.2 You manage 8 technicians. Each completes 5 jobs a day, and 12% of jobs need a revisit that counts as an extra job. Tomorrow 36 new jobs are scheduled. Can the team handle it?
Yes, because 36 is below 40
No, you need three more technicians
Yes, because revisits happen on other days
No: 36 jobs plus 12% revisits is about 40.3 jobs, just above the 40-job capacity, so plan a buffer such as overtime or moving one low-priority job
3.3 For one client, 30% of jobs need a revisit, against 8% for all other clients, with the same technicians and the same parts. What is the most logical first step?
Review that client's revisit work orders for the common cause (access, scope, diagnosis, parts) and check how their requests are described at intake
Replace the technicians who serve that client
Ask the client to submit fewer requests
Add more technicians to that client
3.4 A technician reports a gas smell in a client's kitchen. The client says "ignore it, we are busy". What do you instruct?
Continue with extra care
Test for the leak with a lighter
Stop work, avoid anything that could spark, evacuate the area, call the gas emergency number, and confirm to the client in writing
Reschedule after the lunch rush
3.5 A client is angry because the technician is running 2 hours late. The technician explains that a previous client extended the scope on site without approval. What do you do?
Tell the angry client that another client caused the delay
Offer a discount immediately without checking the facts
Tell the technician to skip this job
Apologize, give a firm arrival time, and separately review the scope-control failure with the technician
3.6 Your report shows on-time arrival at 96%, first-time fix at 71%, and falling client satisfaction. What is the most likely problem?
Visits are ending unresolved because of poor diagnosis, missing parts or unclear scoping
Technicians arrive too late
You have too many technicians
Clients are being unreasonable
3.7 An on-call technician asks for tomorrow off, and a colleague offers to swap. Tomorrow you have emergency contracts. What do you do?
Refuse the request
Approve it automatically
Approve it only after confirming the colleague holds the same certifications, updating the on-call roster, and informing the dispatch team
Let them settle it between themselves
Part 3: Data Management (35 points)
3.1 Column A holds invoice IDs that repeat. Which formula counts the number of DISTINCT invoice IDs in A2:A100 (no blanks)?
=COUNTA(A2:A100)
=SUM(A2:A100)
=COUNTIF(A2:A100,"unique")
=COUNTA(UNIQUE(A2:A100))
3.2 Table orders(id, client_id, amount). Which query returns the total amount per client, only for clients above 10,000 in total, highest first?
SELECT client_id, SUM(amount) FROM orders WHERE SUM(amount) > 10000 GROUP BY client_id ORDER BY 2 DESC;
SELECT client_id, SUM(amount) FROM orders GROUP BY client_id HAVING SUM(amount) > 10000 ORDER BY SUM(amount) DESC;
SELECT client_id, amount FROM orders HAVING amount > 10000;
SELECT client_id, SUM(amount) FROM orders ORDER BY SUM(amount) DESC GROUP BY client_id;
3.3 A 20,000-row customer file has 600 near-duplicate customer records (same person, different spelling) and 1,000 missing postal codes. A report counts customers by city. Which problem most directly makes the count wrong?
The near-duplicate records
The missing postal codes
Both equally
Neither
3.4 You LEFT JOIN 10,000 invoices to payments. Some invoices have two partial payments. The result has 10,800 rows and the invoice totals look inflated. What happened?
Rounding errors
The invoices table has missing data
Each invoice with several payments appears several times (a one-to-many join), so total the payments per invoice before joining
The database has a bug
3.5 Monthly job counts: 52, 49, 55, 51, 240, 50. The 240 comes from an import error that loaded five months at once. Which measure best shows typical monthly volume while you fix it?
Median (51.5)
Mean (about 82.8)
Maximum
Sum
3.6 A colleague asks you to email a spreadsheet of client phone numbers and addresses to his personal Gmail so he can work tonight. What do you do?
Send it, he is trustworthy
Send it with a password
Decline, and give him access through approved company storage with permissions, removing columns he does not need
Send only half the rows
3.7 A VLOOKUP returns #N/A even though the value is clearly visible in the table. What is the most likely cause?
*
The formula is too long
Excel needs a restart
The column is too narrow
The lookup value and the table value differ in type or have hidden spaces (text versus number, trailing space)
Calculation- FC
Calculation- DM
Submit
Should be Empty: