Skip to content

Skill readiness test

Data Analyst at Technology Ventures

5 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. Two tables are related on a shared key but the relationship shows a dotted line in the model view. What does that usually mean?
3. In Power BI, what is the main purpose of a DAX measure versus a calculated column?
4. 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?
5. 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?