Skip to content

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

1. Question 1

Which data quality trait can be summarized by asking “Is the data really necessary?”

  • ❌ Completeness

  • Relevance

  • ❌ Reliability

  • ❌ Timeliness

Explanation:
Relevance means the data is appropriate, useful, and necessary for the analysis or business problem.


2. Question 2

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

  • ❌ Timeliness

  • ❌ Reliability

  • ❌ Accuracy

  • Completeness

Explanation:
Completeness refers to whether all required data is present, available, and accessible when needed.


3. Question 3

After importing a text file into Excel, some columns don’t show all data. How to fix all column widths at once?

  • ❌ Shorten the text

  • ❌ Click the Format button

  • Select all columns and double-click one of the selected column dividers

  • ❌ Drag a divider across

Explanation:
Selecting all columns (Ctrl + A) and double-clicking the boundary auto-fits every column.


🧾 Summary Table

Q# Correct Answer Key Concept
1 Relevance Checks if data is necessary
2 Completeness Accessibility & availability of data
3 Select all + double-click divider Autofit all columns