Module 10 · Query Builder: building KPIs

Module quiz

12 items drawn at random from a bank of 12 · pass mark 75% · unlimited retakes

1. Which field belongs to the KPI shell, not the query?

2. You need a new query that's nearly identical to an existing Active one — same structure, one small tweak to the formula. What's the fastest way to build it?

3. Which two controls make up the two-step model for creating a KPI?

4. You created a KPI and it's empty everywhere — why?

5. Which block lets you reuse another query's result as an input?

6. Where do Update range and Calculate future values if possible live?

7. Which column in the query list unambiguously identifies a KPI, even when two rows share a name?

8. A custom KPI is edited by the person who built it. What's different from editing a standard KPI?

9. A margin calculation was built as Revenue − COGS ÷ Revenue instead of (Revenue − COGS) ÷ Revenue. What's wrong with it?

10. Which control resets the query canvas entirely?

11. What is the right order: Save, Run query, Build, Check against a trusted number?

12. A colleague wants a new KPI for "revenue per employee" — a common enough metric. What's the first question worth asking?