Practice Test GeeksKSA - Knowledge, Skills, and Abilities Practice Test
← All KSA Flashcard Decks

Data Analysis & Reporting Flashcards

7 cards from real KSA practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 7 Data Analysis & Reporting flashcards as text

  1. Which Excel function looks up a value in the first column of a table and returns a value from another column in the same row?

    Answer: VLOOKUP

    VLOOKUP searches the leftmost column and returns a value from a specified column in the matching row.

  2. In SQL, which clause filters grouped results after aggregation?

    Answer: HAVING

    HAVING applies conditions to aggregated groups, whereas WHERE filters rows before grouping.

  3. A dataset has 8% of values missing at random in one column. Which approach is generally most defensible?

    Answer: Document the issue and use an appropriate method such as imputation or exclusion

    Missing data should be handled with a documented, justified method and its limitations disclosed.

  4. What is the main purpose of a pivot table?

    Answer: To summarize and cross-tabulate large datasets interactively

    Pivot tables let you quickly aggregate and reorganize data by categories.

  5. A p-value of 0.03 in a hypothesis test with alpha 0.05 means you should:

    Answer: Reject the null hypothesis

    Because 0.03 is below the 0.05 threshold, the result is statistically significant.

  6. Which practice best ensures your analysis can be reviewed and reproduced by a colleague?

    Answer: Documenting data sources, assumptions, and methods

    Documentation and preserved raw data enable verification and reproducibility.

  7. A bar chart's y-axis starts at 90 instead of 0, exaggerating small differences. This is an example of:

    Answer: A misleading visualization

    Truncated axes on bar charts distort the visual comparison of magnitudes.

How this page was made: written with AI tools and published by Nathan Beja, founder of Practice Test Geeks, who is responsible for its content. We have not yet matched this exam's facts to an official source, so confirm fees, dates and rules with the exam body. Not reviewed by a subject-matter expert. Editorial policy