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

Question 1

Which of the following key Data Analyst tasks is typically done last?

❌ Collecting data
❌ Cleaning data
❌ Analyzing data
✅ Visualizing data

Explanation:
After data is collected, cleaned, and analyzed, the final step is to visualize the results so insights can be easily understood and communicated.

Question 2

How are Excel worksheet cells referenced?

❌ Column number first then row letter
❌ Row number first then column letter
✅ Column letter first then row number
❌ Cell number first then row number

Explanation:
Excel uses the format Column Letter + Row Number, such as A1, B5, or C10.

Question 3

Which Excel shortcut helps find how many rows of data you have (with no empty rows)?

❌ CTRL+Right
✅ CTRL+Down
❌ CTRL+Home
❌ CTRL+Up

Explanation:
CTRL + Down Arrow jumps from the current cell to the last filled row in that column, helping you identify the total number of rows.

🧾 Summary Table