Data Analysis and Reporting Flashcards
6 cards from real CAP practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 Data Analysis and Reporting flashcards as text
Which Excel function is used to look up a value in the first column of a table and return a corresponding value from another column?
Answer: VLOOKUP
VLOOKUP (Vertical Lookup) searches for a value in the leftmost column of a table range and returns a value from a specified column to the right, making it ideal for cross-referencing data tables.
What is the purpose of a pivot table in spreadsheet analysis?
Answer: To summarize, group, and analyze large datasets by rearranging data into a structured summary view
A pivot table is a powerful data summarization tool that allows users to quickly group, count, sum, and analyze large datasets by dragging fields into rows, columns, values, and filters.
When preparing a data report for management, which principle ensures the report tells a clear story?
Answer: Presenting data in a logical sequence that leads the reader from context to findings to recommendations
Effective data reports follow a logical narrative structure — establishing context (what the data is about), presenting key findings (what the data shows), and leading to conclusions or recommendations (what should be done).
What does the term 'descriptive statistics' encompass?
Answer: Summary measures such as mean, median, mode, range, and standard deviation that describe a dataset's characteristics
Descriptive statistics summarize and describe the basic features of a dataset — measures of central tendency (mean, median, mode) and variability (range, standard deviation) — without making inferences beyond the data.
Which of the following is the correct definition of 'data integrity' in database management?
Answer: The accuracy, consistency, and reliability of data throughout its lifecycle
Data integrity ensures that data is accurate, complete, consistent, and trustworthy — maintained from creation through eventual deletion — so that reports and decisions based on the data are reliable.
In which scenario would a line chart be the most effective visualization choice?
Answer: Showing monthly sales revenue trends over a two-year period
Line charts are optimal for displaying continuous data over time, clearly showing trends, patterns, increases, decreases, and inflection points across a time series.