Welcome to your free Excel 2007-2016 test


1)

I have an Excel 2003 file that uses the range names Qtr1, Qtr2 and Qtr3. Why does my file produce incorrect results in Excel 2007+?





excel-std-q1


2)

What formula would you enter in B16 to show the total for just the person selected on only the date entered?




excel-std-q2


3)

The Developer Ribbon is hidden by default. Where would you go to make it visible in Excel 2010+?




excel-std-q3


4) What has happened to Excel?
excel-std-q4


5)

Why is there such a big gap between the Ribbon and Excel cells?






6) (i) Why do these dots show in the Name Box and (ii) what can you do about it?
excel-std-q6


7)

The headings for columns A, B and C have been changed. How has this been done?




excel-std-q7


8) The range A2:C12 has consistent cell background and font formatting across all cells. Why do some cells appear different?
excel-std-q8


9)

How do you restore the fill handle? (the little + that is usually in the bottom right-hand corner of a cell)




excel-std-q9


10)

Even though the word “Heading” appears to be highlighted it is not showing up in the formula bar, why not?




excel-std-q10



Be sure to click the button below to check your answers!