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 |