Alternatively, depending on the Excel version and requirement, I could use functions such as SORT, FILTER, or LARGE.”

9️⃣ What is the difference between relative and absolute cell references?

Sample Answer:

“A relative reference changes when a formula is copied to another cell.

For example:

=A2**B2

An absolute reference remains fixed when the formula is copied.

For example:

=A2**$B$1

Absolute references are particularly useful when applying a calculation using a fixed assumption, tax rate, exchange rate, or target value.”

🔟 How would you clean a large dataset in Excel?

Sample Answer:

“I would first understand the structure and identify data-quality issues.

My process would typically include:

• Removing or investigating duplicates

• Handling missing values

• Standardizing text and date formats

• Correcting inconsistent values

• Checking data types

• Identifying invalid or unusual values

• Using formulas or Power Query for repeatable transformations

• Validating the cleaned dataset before analysis

For a large or recurring dataset, I would prefer Power Query rather than manually cleaning the data every time.”

Double Tap ❤️ For Part-6