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

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.

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

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.

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

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).

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

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.

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

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.

CAP - Certified Administrative Professional Practice Test

CAP - Certified Administrative Professional Practice Test

CAP Data Analysis and Reporting 2