CAP Data Analysis and Reporting

Question 1

Which chart type is most appropriate for showing the proportion of parts to a whole?

Accepted Answer

Pie chart

Answer

Line chart

Answer

Bar chart

Answer

Scatter plot

Question 2

In spreadsheet software, which function calculates the average of a range of cells?

Accepted Answer

AVERAGE

Answer

SUM

Answer

MEDIAN

Answer

COUNT

Question 3

What is a 'dashboard' in the context of business data reporting?

Accepted Answer

A visual display that consolidates key performance indicators and metrics in a single, easy-to-read interface

Answer

A physical bulletin board where printed reports are posted

Answer

A detailed narrative report submitted to senior leadership monthly

Answer

A spreadsheet that stores raw data before it is analyzed

Question 4

When analyzing data, what does 'data cleaning' refer to?

Accepted Answer

The process of identifying and correcting errors, duplicates, and inconsistencies in a dataset

Answer

Converting data from one file format to another

Answer

Encrypting sensitive data before storing it

Answer

Removing outliers from a dataset because they distort the average

Question 5

Which of the following best describes a 'key performance indicator' (KPI)?

Accepted Answer

A measurable value that demonstrates how effectively an organization is achieving a key business objective

Answer

A list of tasks that must be completed before a project is approved

Answer

A financial ratio used exclusively by the accounting department

Answer

An informal conversation between a manager and employee about performance

Question 6

In data analysis, what does 'sorting' data mean?

Accepted Answer

Arranging data in a specified order such as ascending or descending by a selected column

Answer

Filtering data to show only records that meet certain criteria

Answer

Grouping related records into categories

Answer

Calculating totals for groups of related records