• Need Help? Visit our FAQ section or email support

Fun Excel Quiz

A fun quiz.

5 questions based on our popular Excel hacks in 2 minutes series on YouTube.

Try answer the question first (very important- too much learning is just reading the answer and assuming you would have got it right if you tried), and then see the correct answer and the relevant YouTube video.

1. What do you type into the Text to column tool to use a line break as a delimiter?

2. Which combination of functions can you use to automatically sort a list without any VBA macros

3. In which tab on the Excel ribbon do you find the ungroup option in Excel?

4. Instead of VBA which Excel tool can you use to copy filenames into Excel

5. Which is the more controlled way of clearing conditional formatting?