1. Question 1

If you have multiple filters set, how can you clear all of them at once?

• ❌ You must clear each filter separately

• ❌ Turn sorting off

• ❌ Refresh the column

• ✅ Data tab > Sort & Filter group > Clear

Explanation:
The Clear button removes all filters in one step.

---

2. Question 2

After enabling Filtering, where do the filter controls appear?

• ❌ Only selected cells

• ❌ Each row

• ❌ Must manually select data

• ✅ Each column header now has a filter control

Explanation:
Filter dropdown arrows appear in every column header of the selected table or range.

---

3. Question 3

The IF function handles one or two conditions. What if you need multiple?

• ✅ Use the nesting capabilities of the IF function

• ❌ Use the IF-Then function

• ❌ Use the IF OR function

• ❌ Use separate IF functions

Explanation:
Multiple conditions are handled by nested IF statements or by combining IF with AND/OR.

---

4. Question 4

When using nested functions, what is required for each function?

• ❌ Alphabetical order

• ❌ Semi-colon between functions

• ❌ =IF to begin each function

• ✅ A set of parentheses for each function

Explanation:
Each nested function must have its own parentheses so Excel understands the structure.

---

5. Question 5

How do HLOOKUP, VLOOKUP, and XLOOKUP look for data?

• ❌ HLOOKUP = in all directions; VLOOKUP = column; XLOOKUP = row

• ❌ HLOOKUP = row; VLOOKUP = all directions; XLOOKUP = column

• ❌ HLOOKUP = column; VLOOKUP = row; XLOOKUP = all directions

• ✅ HLOOKUP = by row; VLOOKUP = by column; XLOOKUP = all directions

Explanation:

• HLOOKUP searches horizontally (across rows)

• VLOOKUP searches vertically (down columns)

• XLOOKUP searches both ways and is more flexible

---

🧾 Summary Table

---