📌 Scenario 11
Question: Your manager asks you to calculate the total sales for only the "North" region. How would you do it?
Answer: Use SUMIF().
Example:
=SUMIF(A:A,"North",B:B)This adds all sales where the region is North.
📊 Scenario 12
Question: You need to count how many employees belong to the IT department. How do you do it?
Answer: Use COUNTIF().
Example:
=COUNTIF(C:C,"IT")This counts all rows where the department is IT.
📅 Scenario 13
Question: You have customer names entered multiple times. How do you create a unique list of customers?
Answer:
• Excel 365: Use
=UNIQUE(A:A) to generate a list of unique names. • Older versions: Use Data → Remove Duplicates or an Advanced Filter.
📈 Scenario 14
Question: You want to display "Target Achieved" if sales are ₹50,000 or more; otherwise, display "Target Not Achieved".
Answer: Use the IF() function.
Example:
=IF(B2>=50000,"Target Achieved","Target Not Achieved")🔎 Scenario 15
Question: Your manager wants to know which products have been sold more than once. How do you identify them?
Answer: Use COUNTIF().
Example:
=COUNTIF(A:A,A2)If the result is greater than 1, the product appears multiple times.
💬 Double Tap ♥️ For More!