Excel Problems & Challenges
If you are looking for a quick challenge in Excel, then you have come to right place. Train your Excel muscles by answering these questions & quizzes.
- Can you calculate vacation days in a period?
- Can you find that pattern?
- Check if two dates are in same month
- Check if few cells have same value
- How many values are common in 2 lists?
- Waiter friendly pricing & round to nearest Monday
- Can you extract dates from text?
- Highlight employees by performance
- An IF formula challenge for you
- Finding next Friday the 13th…
- Calculate Payment Schedule
- Check if a word or phrase is palindrome…
- Writing bit-wise AND, OR & XOR formulas
- Amount donated vs. pledged
- Calculating sum of digits in a number
- Make nuts without going nuts
- Find the average of closest two numbers
- Mutant cell modeling problem
- When does next thanksgiving day occur on same date?
- VLOOKUP Formula challenges + a joke
- How to lookup values to left?
- Show zebra lines when values change
- How to calculate working hours between 2 dates?
- How many hours did Johnny work?
- Find out days overlapped between 2 ranges of dates?
- Calculate average of top 5 values
All the best! 🙂