Microsoft computer training and software development


Use our newer skills assessment site instead. It has more exams, better questions, better reports and a much better user interface.

Test your Microsoft Excel IQ

Data, lists and pivot tables in Microsoft Excel

You can sort and filter lists in Excel, as well as subtotalling them and creating pivot tables.

To help you decide whether you want to take this test, below is a typical question showing the sort of question that you might be asked.

Consider the list below. 


How many columns is this person currently using in their filter? 

  A.   3
  B.   2
  C.   1
  D.   0

To continue, click on one of the links below.

Return to Excel topics   |  Start Excel test  |  Home page 


IQ test home page