Skip to content

Skill readiness test

Data Analyst at Voices of Hope Lexington Inc

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 is the correct way to lock a cell reference so it does not shift when copied across a row?
2. 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?
3. 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?