To enable social distancing we've completely remodelled our classroom training, launched a full range of live online courses and now provide online training-cum-consultancy.

Click on a question number to change the question displayed. You have 19 minutes and 59 seconds of the original 20 minutes left.

 

Your answers
Question Answer
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Question 1 of 20 - Excel 2016 test

You want to get the average of a range of figures, and enter this formula:

Excel 2016 test - question 1 of 20

What will happen when you press the ENTER key?

If you know the answer, choose it below:

You'll see the correct average in the cell
You'll see an error (you can't refer to a range of cells using a : like this)
You'll see an error (the function name should be AVG, not AVERAGE)
You'll see an error (the function name should be MEAN, not AVERAGE)

Click here if you don't know the answer to this question.


If you see a mistake in this question, please let us know.