1. Question 1

What issue do empty rows cause in a spreadsheet?

• ❌ Indexing function error

• ❌ Spell-check will fail

• ❌ Data will be hidden

• ✅ Formula errors

Explanation:
Empty rows can break formulas, especially those relying on continuous data ranges (e.g., SUM, VLOOKUP, PivotTables).

---

2. Question 2

How do you remove all empty rows at once?

• ❌ Search & Replace

• ✅ Select all rows → Filter for Blanks → select and delete

• ❌ Delete one at a time

• ❌ Remove Duplicates

Explanation:
Filtering for Blank rows and deleting them is the fastest, cleanest method.

---

3. Question 3

Easiest way to locate and remove duplicate rows?

• ❌ Highlight Cells Rules → Duplicate Values

• ❌ HLOOKUP

• ❌ Search for first character

• ✅ Select all data → Remove Duplicates button

Explanation:
The Remove Duplicates button deletes duplicated rows instantly with one click.

---

4. Question 4

What does the PROPER function do?

• ❌ Repairs REF error

• ❌ Sentence case

• ❌ Converts upper to lower

• ❌ Converts lower to upper

• ✅ Capitalizes the first letter of each word (Proper Case)

Explanation:
=PROPER("john SMITH") → John Smith

---

5. Question 5

Why use Paste Values when pasting from a helper row?

• ❌ Keeps formatting

• ❌ Ensures consistency

• ✅ Makes sure formulas aren’t copied

• ❌ Validates the function

Explanation:
Paste Values pastes the final results, not the helper formulas.

---

6. Question 6

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

• ✅ Format Painter tool

• ❌ Text Import Wizard

• ❌ Paste Special tool

• ❌ Format button

Explanation:
Format Painter copies the formatting to any selected cells.

---

7. Question 7

Tools/features that split one column with two names into two columns? (Select all that apply)

• ❌ Paste Special

• ✅ Flash Fill

• ❌ Format Painter

• ✅ Text to Columns

Explanation:
Both Flash Fill and Text to Columns can separate first/last names into new columns.

---

🧾 Summary Table

---