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

Formulae and range names in Microsoft Excel

You can combine functions and formulae in Excel to create calculations, or use range names to label cells and make your formulae easier to read.

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.

The spreadsheet below shows a list of daily activities for a person. 


What is the formula in cell D3 likely to be? 

  A.   =PRODUCT(B3,C3)
  B.   =B3+C3
  C.   =B3*C3
  D.   =SUM(B3:C3)

To continue, click on one of the links below.

Return to Excel topics   |  Start Excel test  |  Home page 


IQ test home page