Free Excel 2003 quiz - Test Your Skills!

Mathematical functions

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

We've detected that you don't have Javascript enabled in your browser - you can still try the Quiz, but clickable 'image map' questions won't work. Please enable Javascript and refresh this page. If you can't, you can follow this link for a version which converts image questions to multiple-choice. You may also prefer to use the multiple-choice version if you use screen reading software, like JAWS, to browse.

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

Look at the image below. Using the SUMIF function, how would you create the formula that adds the values under Cheese, where their Smell figure is greater than 25?

$Screen shot for question 1$

Please select an answer...
- =SUMIF(A2:B6,">25")
- =SUMIF(">25",B2:B6)
- =SUMIF(B2:B6,">25")
- =SUMIF(B2:B6,">25",A2:A6)
Using the SUMIF function, how would you create the formula that adds the values under Cheese, where their Rating figure is greater than 0?

$Screen shot for question 2$

Please select an answer...
- =SUMIF(C2:C6, "<0", A2:A6)
- =SUMIF(A2:A6, ">0", C2:C6)
- =SUMIF(C2:C6, >0, A2:A6)
- =SUMIF(C2:C6, ">0", A2:A6)
In a cell on your worksheet is the formula =ROUND(4.1283,2). What answer will this return?

Please select an answer...
- 412.83
- 4.12
- 4.13
- 413

Top