CAP Data Analysis and Reporting 3

Question 1

What is the purpose of conditional formatting in spreadsheet software?

Accepted Answer

To automatically apply visual formatting (colors, icons) to cells based on their values or content

Answer

To restrict what type of data can be entered into a cell

Answer

To automatically sort data when new records are added

Answer

To protect cells from accidental deletion

Question 2

What does 'filtering' data accomplish in a spreadsheet or database?

Accepted Answer

Temporarily hiding rows that do not meet specified criteria so only relevant records are displayed

Answer

Permanently deleting records that do not match the selected criteria

Answer

Sorting records from the highest to lowest value

Answer

Calculating totals for a specific subset of data

Question 3

Which of the following correctly describes the difference between a chart's title and its axis labels?

Accepted Answer

The title describes the overall chart; axis labels identify what each axis measures and its unit of measurement

Answer

The title and axis labels are interchangeable and serve the same purpose

Answer

The title appears at the bottom while axis labels appear at the top

Answer

Axis labels are required only on pie charts; other chart types use only a title

Question 4

What is the purpose of a 'data validation' rule in a spreadsheet?

Accepted Answer

To restrict the type or range of data that can be entered into a cell, reducing errors

Answer

To automatically format cells based on their content

Answer

To check for duplicate values across a column

Answer

To calculate the statistical significance of data differences

Question 5

When an administrative professional notices a significant outlier in a dataset, what is the recommended first step?

Accepted Answer

Investigate whether the outlier is a data entry error or a genuine extreme value before deciding how to handle it

Answer

Immediately delete the outlier to prevent it from skewing the analysis

Answer

Include the outlier without any examination to avoid altering the dataset

Answer

Report the outlier to the IT department as a system error

Question 6

Which report format would be MOST appropriate for presenting complex findings to a senior leadership team?

Accepted Answer

A concise executive summary with supporting visuals, followed by detailed appendices for those who want more depth

Answer

A raw data export from the database with no narrative explanation

Answer

A lengthy narrative report with no charts or tables

Answer

A series of disconnected charts without any explanatory text