Free Excel 2003 quiz - Test Your Skills!

Statistical functions

The aim of this quiz is to check your knowledge of Statistical functions in Excel 2003.

Please ensure that you read all questions carefully and spell all answers correctly! Once you have completed the quiz, please click the 'score my answers!' button to find out how you did.

If you like this quiz, there are plenty more where it came from! You can see the full list of subjects here.

You can learn more about our classroom, online and soft skills courses at our Happy websites.

Questions

  1. Using the COUNT function, how would you count all the cells that contain numbers in cells B5 to D6? Type the formula into the box below, exactly as you would type it into Excel (make sure to include the = sign):

  2. How would you count all the cells that contain both text and numbers in cells D12 to P51?

  3. How would you count all cells from A4 to D12 that are less than 25?

Top