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

Here are the answers in your strict required exam format ✅❌
(All options shown, correct ones marked, with a clear Explanation after each question, and a 🧾 Summary Table at the end)

Question 1

What is one of the issues that empty rows cause in your spreadsheet?

❌ Formula errors
✅ Indexing function error
❌ Data will be hidden
❌ Spell-check will fail

Explanation:
Empty rows can break the continuity of data ranges, which often causes indexing and lookup functions (like VLOOKUP, INDEX) to behave incorrectly.

Question 2

How to remove all empty rows at the same time in an imported spreadsheet?

❌ Use Search & Replace
❌ Delete empty rows one at a time
✅ Select all rows → filter for Blanks → select and delete
❌ Use Remove Duplicates

Explanation:
Filtering for Blanks lets you select all empty rows at once and delete them efficiently.

Question 3

Easiest way to locate and remove duplicated rows in Excel?

✅ Select all data and click the Remove Duplicates button
❌ Use Conditional Formatting
❌ Search for first character
❌ Use HLOOKUP

Explanation:
The Remove Duplicates button is the fastest and simplest method to delete duplicate rows.

Question 4

What does the PROPER function do?

❌ Repairs a REF error
❌ Converts uppercase to lowercase
❌ Converts lowercase to uppercase
✅ Changes text to sentence (proper) case

Explanation:
PROPER() capitalizes the first letter of each word, making text look clean and readable.

Question 5

Why use Paste Values when pasting from a helper row to the original row?

❌ Validates the copied function
❌ Keeps cell formatting the same
✅ Makes sure formulas aren’t also copied
❌ Ensures consistency

Explanation:
Paste Values pastes only the results, not the formulas, preventing calculation issues.

Question 6

One way to apply new data formats to the rest of a column is:

❌ Format button
✅ Format Painter tool
❌ Text Import wizard
❌ Paste Special tool

Explanation:
The Format Painter quickly copies formatting from one cell to others.

Question 7

Which tools can split one column with two names into two columns? (Select all that apply)

❌ Format Painter tool
❌ Paste Special
✅ Flash Fill feature
✅ Text to Columns feature

Explanation:

• Text to Columns splits data using delimiters (like space or comma)

• Flash Fill automatically detects and applies patterns

🧾 Summary Table