*Important Excel interview questions with answers* 🧩 1️⃣ *Q: How can you extract the domain name from an email address in Excel?* *A:* Use `=RIGHT(A1, LEN(A1) - FIND("@", A1))` to get everything after the "@" symbol if the email is in cell A1. 2️⃣ *Q: Explain the difference between absolute and relative cell references with an example.* *A:* Absolute references (like `$A$1`) stay fixed when copied, while relative references (like `A1`) change based on where you paste them. For example, copying `=A1+B1` from row 1 to row 2 becomes `=A2+B2`, but `=$A$1+$B$1` always refers to row 1. 3️⃣ *Q: How do you lock a worksheet so no one can edit it?* *A:* Go to the Review tab, click "Protect Sheet," and set a password. This prevents unwanted changes to your data. 4️⃣ *Q: What are wildcards in Excel and how do you use them?* *A:* Wildcards like `*` (any characters), `?` (single character), and `~` (escape) are used in functions like `COUNTIF` or filters. Example: `=COUNTIF(A1:A10, "*test*")` counts cells containing "test" anywhere in the text. 5️⃣ *Q: What’s an Excel Macro and why use it?* *A:* Macros automate repetitive tasks, saving time and reducing errors. You can record or write them using VBA to boost productivity. *React ❤️ for more*