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

Question 1

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

❌ Turn sorting off
✅ Data tab > Sort & Filter group > Clear
❌ Refresh the column
❌ You must clear each filter separately

Explanation:
Using Data → Sort & Filter → Clear removes all applied filters at once.

Question 2

After enabling Filtering, where can you see and access the filter controls?

❌ Only selected cells have filter controls
❌ You must manually select data for filtering
✅ Each column header now has a filter control
❌ Each row has filter controls

Explanation:
When filtering is enabled, drop-down arrows appear in each column header.

Question 3

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

❌ Use the IF or function
❌ Use the IF-Then function
❌ Use separate IF functions
✅ Use the nesting capabilities of the IF function

Explanation:
Multiple conditions are handled by nesting IF functions (IF inside another IF).

Question 4

When you use nested functions, what is required for each function?

✅ A set of parentheses for each function
❌ Semi-colon between each function
❌ Each function must be alphabetically ordered
❌ =IF to begin each function

Explanation:
Each function must have its own parentheses to define arguments correctly.

Question 5

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

✅ HLOOKUP = by row
VLOOKUP = by column
XLOOKUP = all directions
❌ HLOOKUP = by row, VLOOKUP = all directions, XLOOKUP = by column
❌ HLOOKUP = all directions, VLOOKUP = by column, XLOOKUP = by row
❌ HLOOKUP = by column, VLOOKUP = by row, XLOOKUP = all directions

Explanation:

• HLOOKUP searches horizontally (rows)

• VLOOKUP searches vertically (columns)

• XLOOKUP works both horizontally and vertically

🧾 Summary Table