Graded Quiz :Excel Basics for Data Analysis (IBM Business Analyst Professional Certificate) Answers 2025

Question 1

Which data quality trait asks if the data is really necessary?

❌ Completeness
❌ Reliability
❌ Timeliness
✅ Relevance

Explanation:
Relevance focuses on whether the data is useful and necessary for the specific task or decision.

Question 2

Which data quality trait refers to the availability and accessibility of data?

❌ Completeness
✅ Timeliness
❌ Accuracy
❌ Reliability

Explanation:
Timeliness means data is available when needed and accessible at the right time.

Question 3

How can you fix all column widths at the same time in Excel?

✅ Select all columns and double-click one of the selected column dividers
❌ Click the Format button
❌ Drag a divider across
❌ Shorten the text

Explanation:
Selecting all columns and double-clicking a divider auto-adjusts all column widths to fit the data.

🧾 Summary Table