Skip to content

Skill readiness test

Human Resources Data Analyst at Arnold Porter

3 questions, about 3 minutes. This is a diagnostic, not a certification — it estimates your skill readiness, it does not guarantee you are qualified for or will be hired into this role.

1. Which function looks up a value in one column and returns a value from another column in the same row, matching on the leftmost column?
2. A pivot table field summarizes as SUM by default but the underlying column has some text values mixed in. What is the most likely visible symptom?
3. Which is the correct way to lock a cell reference so it does not shift when copied across a row?