12,900+ practice questions · 144 exams · new questions added every week
Practice questions › Data Analyst › Data Analytics

Data Analyst Data Analytics practice questions

10 free questions with answers and explanations. Try each one, then tap “Show answer”.

  1. 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.

  2. 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.

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

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

  5. 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%.

  6. 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.

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

  8. 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.

  9. 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.

  10. 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.

Want more Data Analyst Data Analytics questions?

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 Telegram

More Data Analyst practice

About the Data Analyst on Mock Night · Original practice questions; not affiliated with the exam board.