CAP Data Analysis and Reporting 2

Question 1

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?

Accepted Answer

VLOOKUP

Answer

HLOOKUP

Answer

INDEX

Answer

MATCH

Question 2

What is the purpose of a pivot table in spreadsheet analysis?

Accepted Answer

To summarize, group, and analyze large datasets by rearranging data into a structured summary view

Answer

To display data in a rotating 3D visualization

Answer

To automatically correct data entry errors in a spreadsheet

Answer

To protect cells from being edited by unauthorized users

Question 3

When preparing a data report for management, which principle ensures the report tells a clear story?

Accepted Answer

Presenting data in a logical sequence that leads the reader from context to findings to recommendations

Answer

Including every available data point to demonstrate thoroughness

Answer

Using the most complex chart types available to showcase analytical skill

Answer

Formatting the report with as many colors as possible to attract attention

Question 4

What does the term 'descriptive statistics' encompass?

Accepted Answer

Summary measures such as mean, median, mode, range, and standard deviation that describe a dataset's characteristics

Answer

Statistical methods used to predict future outcomes from historical data

Answer

Tests used to determine whether observed differences between groups are statistically significant

Answer

Techniques for collecting data through surveys and experiments

Question 5

Which of the following is the correct definition of 'data integrity' in database management?

Accepted Answer

The accuracy, consistency, and reliability of data throughout its lifecycle

Answer

The process of encrypting data to prevent unauthorized access

Answer

The speed at which data can be retrieved from a database

Answer

The total storage capacity allocated to a database

Question 6

In which scenario would a line chart be the most effective visualization choice?

Accepted Answer

Showing monthly sales revenue trends over a two-year period

Answer

Comparing the market share of five competing companies at a single point in time

Answer

Displaying the breakdown of an annual budget by department

Answer

Showing the relationship between employee age and years of experience