Free Excel 2003 quiz - Test Your Skills!

Logical Functions

The aim of this quiz is to check your knowledge of Logical 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. Cell B1 contains the number 27. If another cell contains the formula:

    =IF(B1>30,"Bonus",IF(B1>20,"Medium Bonus ","No Bonus"))

    what answer will the formula give?

  2. Which of these statements is correct?

    A: The AND function looks at cells - if any of them are true then it shows the value TRUE. If they're all false, then it says FALSE. B: The AND function looks at cells - if any of them are false then it shows the value FALSE. If they're all true, then it says TRUE. C: The OR function looks at cells - if any of the arguments are true then it says TRUE. If they're all false, then it says FALSE. D: The OR function looks at cells - if any of the arguments are false then it says FALSE. If they're all true, then it says TRUE.

Top