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
What is the purpose of conditional formatting in spreadsheet software?
Answer: To automatically apply visual formatting (colors, icons) to cells based on their values or content
Conditional formatting changes cell appearance (background color, font color, icons, data bars) automatically when cell values meet specified conditions, enabling quick visual identification of patterns, outliers, or status.
What does 'filtering' data accomplish in a spreadsheet or database?
Answer: Temporarily hiding rows that do not meet specified criteria so only relevant records are displayed
Filtering temporarily hides rows that do not meet the filter criteria, allowing users to focus on a relevant subset of data without deleting any records. The hidden rows reappear when the filter is removed.
Which of the following correctly describes the difference between a chart's title and its axis labels?
Answer: The title describes the overall chart; axis labels identify what each axis measures and its unit of measurement
A chart title provides the overall context for what the chart shows, while axis labels identify the variable (and unit) on each axis, together ensuring the reader can correctly interpret the chart.
What is the purpose of a 'data validation' rule in a spreadsheet?
Answer: To restrict the type or range of data that can be entered into a cell, reducing errors
Data validation rules prevent incorrect data entry by specifying what type of data (whole numbers, dates, text from a list) and what range of values a cell will accept, flagging or blocking invalid entries.
When an administrative professional notices a significant outlier in a dataset, what is the recommended first step?
Answer: Investigate whether the outlier is a data entry error or a genuine extreme value before deciding how to handle it
Outliers should always be investigated before any action is taken — they may represent data entry errors (which should be corrected), system glitches, or genuine extreme values that reflect real phenomena important to the analysis.
Which report format would be MOST appropriate for presenting complex findings to a senior leadership team?
Answer: A concise executive summary with supporting visuals, followed by detailed appendices for those who want more depth
Senior leaders benefit most from concise summaries with clear visuals that highlight key insights, with detailed supporting data available in appendices for those who need to dig deeper.