Fun Excel Quiz

Quick Excel tips and tricks in a quiz format. You can earn points while you learn, register a free account .

3 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. Which of the following problems do merged cells give?

Makes editing the data difficult

you cannot unmerge cells

Makes copy and paste very hard

2. From the number formats available in Excel, which format is pre programmed to only align right (you cannot make it align left or centre)?

Number

Accounting

Currency

3. If, on a South African machine, you try to refer to column R and you start your formula with a + e.g. +R100 meaning get the information from cell R100, Excel will

It will change the formula to =R100 and refer to whatever is in cell R100

Run the R macro

Lose the cell reference and make your cell equal 100