Graded Quiz :Excel Basics for Data Analysis (IBM Data Analyst Professional Certificate) Answers 2025
1. Question 1
Which key Data Analyst task is typically done last?
-
❌ Cleaning data
-
❌ Analyzing data
-
✅ Visualizing data
-
❌ Collecting data
Explanation:
The usual workflow is: Collect → Clean → Analyze → Visualize.
So visualization is done last.
2. Question 2
How are Excel worksheet cells referenced?
-
✅ Column letter first then row number
-
❌ Row number first then column letter
-
❌ Cell number first then row number
-
❌ Column number first then row letter
Explanation:
Excel uses the format A1, C10, etc. → Column (letter) + Row (number).
3. Question 3
Which Excel shortcut tells you how many rows of data you have (assuming no empty rows)?
-
❌ CTRL+Home
-
❌ CTRL+Up
-
❌ CTRL+Right
-
✅ CTRL+Down
Explanation:CTRL + Down jumps to the last filled row, letting you see the total row count.
🧾 Summary Table
| Q# | Correct Answer | Key Concept |
|---|---|---|
| 1 | Visualizing data | Final step in analysis workflow |
| 2 | Column letter → Row number | Excel cell referencing |
| 3 | CTRL + Down | Jump to last row of data |
If you want, I can help you prepare for more quizzes or make a quick Excel cheat sheet.