Data Analyst Data Analytics practice questions
10 free questions with answers and explanations. Try each one, then tap “Show answer”.
- 5 · Data validation
1. A field intended to store percentage values contains 1250. What should an analyst do first?
- A. Check the field definition, units and source before changing it
- B. Assume it should be 12.5 and overwrite it
- C. Delete the entire dataset
- D. Convert every number to a date
Show answer
Answer: A. Check the field definition, units and source before changing it
Unexpected values should be investigated against definitions and source context before correction.
- 1 · Missing values
2. A report shows blank values in the delivery-date column. What should an analyst do first?
- A. Investigate why values are missing and assess their impact before choosing a treatment
- B. Replace every blank with today’s date
- C. Delete the entire dataset
- D. Assume every blank means zero
Show answer
Answer: A. Investigate why values are missing and assess their impact before choosing a treatment
Missingness should be understood before imputation, exclusion or other treatment.
- Excel
3. Which Excel function is used for removing extra spaces from text?
- A. CONCAT (or &)
- B. XLOOKUP
- C. TRIM
- D. IFERROR
Show answer
Answer: C. TRIM
TRIM: removing extra spaces from text.
- Excel
4. Cell B2 holds 58 and B10 holds the total 116. What does =B2/B10 show when formatted as a percentage with one decimal place?
- A. 51%
- B. 2%
- C. 50%
- D. 500%
Show answer
Answer: C. 50%
58 ÷ 116 = 0.5 → 50%.
- Excel
5. Cell B2 holds 481 and B10 holds the total 719. What does =B2/B10 show when formatted as a percentage with one decimal place?
- A. 669%
- B. 67.9%
- C. 66.9%
- D. 1.5%
Show answer
Answer: C. 66.9%
481 ÷ 719 = 0.669 → 66.9%.
- 5 · Analysis reproducibility
6. Why should an analyst document data transformations and assumptions?
- A. So another person can understand, reproduce and review the analysis
- B. To make the report longer
- C. To hide unexpected results
- D. To avoid validating the source data
Show answer
Answer: A. So another person can understand, reproduce and review the analysis
Documented methods and assumptions support reproducibility, review and trustworthy decisions.
- 3 · Power Query
7. What is Power Query mainly used for in Power BI?
- A. Connecting to, cleaning and transforming data
- B. Managing passwords
- C. Designing cables
- D. Writing CSS
Show answer
Answer: A. Connecting to, cleaning and transforming data
Power Query connects to data sources and transforms data before loading.
- Visualisation
8. Which chart best shows the relationship between two numeric variables?
- A. Pie chart
- B. Scatter plot
- C. Bar chart
- D. Card
Show answer
Answer: B. Scatter plot
Each point is one observation.
- 3 · SQL joins
9. Which join returns only rows where the join condition matches in both tables?
- A. INNER JOIN
- B. LEFT JOIN
- C. FULL OUTER JOIN
- D. CROSS JOIN
Show answer
Answer: A. INNER JOIN
INNER JOIN returns rows with matching values in both joined tables.
- SQL
10. How do you test for missing values in SQL?
- A. WHERE column = NULL
- B. WHERE NULL(column)
- C. WHERE column IS NULL
- D. WHERE column == ''
Show answer
Answer: C. WHERE column IS NULL
Comparing with = NULL never returns true.
Get fresh questions every day, focused on your weak topics, plus timed mock tests. Free to start.
Practise free in the web app Practise on TelegramMore Data Analyst practice
About the Data Analyst on Mock Night · Original practice questions; not affiliated with the exam board.