Excel interview questions
50 questionsLookups, SUMIFS, text and date formulas, and dynamic arrays such as FILTER and UNIQUE. Answers are checked against Microsoft Excel.
Sums and counts
- Total revenueEasy
- Customers in the SouthEasy
- Customers with an emailEasy
- Customers missing an emailEasy
- Revenue from one customerEasy
- Corporate customers in the SouthEasy
- Names starting with AEasy
- Average price of Travel productsEasy
- Highest price in FurnitureEasy
- Discounted revenue in 2024Medium
- Revenue before discountMedium
- Count with two conditions using SUMPRODUCTMedium