Project Portfolio Finance and Data Analyst at twentyAI

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?

$A1 A$1 $A$1 A1$

2. In Power BI, what is the main purpose of a DAX measure versus a calculated column?

Measures compute dynamically per visual context; calculated columns are stored per row They are identical in every way Calculated columns can only be text Measures cannot use aggregation functions

3. 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?

VLOOKUP CONCAT SUMIF TRANSPOSE

4. 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?

Excel crashes The field silently switches to COUNT instead of SUM The text values are converted to 0 automatically Nothing changes

5. Two tables are related on a shared key but the relationship shows a dotted line in the model view. What does that usually mean?

The relationship is inactive The tables are identical The relationship is many-to-many by definition There is a syntax error

Personalized learning that starts with what you want to achieve.

Start learning

Learn

Courses
Learning paths
Roles
Skills
Jobs

Product

How it works
AI learning
Pricing
FAQ

Company

About
Blog
Contact

Legal

Privacy
Terms

What do you want to achieve? →