Boolean data
Name:
Date:
Class:
A
Quick Questions
Shade in the A or B circle for each question.
1. Which set of values can a Boolean field store?
2. Which database field is best stored as a Boolean?
3. What does a spreadsheet show for the formula =5>3?
4. What does a spreadsheet show for the formula =2=7?
5. Which of these is a Boolean value in a spreadsheet cell?
B
Match the Pairs
Draw a line connecting each item on the left to its match on the right.
| Left column | Right column | |
|---|---|---|
| 1=B2>=50 | AA comparison returns a Boolean value (TRUE or FALSE), not a number. It should return TRUE or FALSE. | |
| 2Member? = Yes/No | B=5>3 | |
| 3A spreadsheet formula that tests a condition and returns a Boolean result | CA comparison that returns TRUE or FALSE depending on whether the value in B2 is at least 50 | |
| 4The result of the comparison 5>3 is the Boolean value TRUE | D=C5="Melbourne" | |
| 5Boolean values: TRUE, FALSE, MAYBE | EA yes/no field in a database, which stores a Boolean value with only two options | |
| 6=A1>10 returns 15 | FA Boolean can only be one of two values, TRUE or FALSE. MAYBE is a third option, so it is not Boolean. |
C
Definitions
Boolean
D
Fill in the Blanks
Complete each line of code by filling in the missing parts.
1.
A1: =5_3
Result: TRUE
2.
Field: IsMember
Data type: _______
3.
B3: =B2__18
Result: TRUE when B2 is 18 or more
4.
=___(B2>50,C2>50)
Result: TRUE only if both are TRUE
5.
A2: =2>9
Result: _____
E
Spot the Error
Shade in the letter of the line that contains an error.
Question 1
A
Field: Member (Yes/No/Maybe)
B
Type: Boolean
C
Values: TRUE or FALSE
Question 2
A
A1: 72
B
B1: =A1+50
C
Result in B1: TRUE
Question 3
A
Field: Is_Paid
B
Type: Integer
C
Example: TRUE
Question 4
A
A2: 8
B
B2: =A2<5
C
Result in B2: TRUE
Question 5
A
A1: 20
B
B1: =A1>=18
C
C1: =IF(B1,"Adult","Minor"
Answer Key
Boolean data
Section A: Quick Questions
Q1
B — TRUE or FALSE
Q2
A — IsMember (yes or no)
Q3
B — TRUE
Q4
A — FALSE
Q5
A — TRUE
Section B: Match the Pairs
Q1
=B2>=50 → A comparison that returns TRUE or FALSE depending on whether the value in B2 is at least 50
Q2
Member? = Yes/No → A yes/no field in a database, which stores a Boolean value with only two options
Q3
A spreadsheet formula that tests a condition and returns a Boolean result → =C5="Melbourne"
Q4
The result of the comparison 5>3 is the Boolean value TRUE → =5>3
Q5
Boolean values: TRUE, FALSE, MAYBE → A Boolean can only be one of two values, TRUE or FALSE. MAYBE is a third option, so it is not Boolean.
Q6
=A1>10 returns 15 → A comparison returns a Boolean value (TRUE or FALSE), not a number. It should return TRUE or FALSE.
Section C: Definitions
Q1
Boolean — A data type with only two possible values: true or false (yes or no). Used for yes/no fields, TRUE and FALSE in a spreadsheet, and the result of a comparison such as 5>3.Section D: Fill in the Blanks
Q1
A1: =5>3
Result: TRUEQ2
Field: IsMember
Data type: BooleanQ3
B3: =B2>=18
Result: TRUE when B2 is 18 or moreQ4
=AND(B2>50,C2>50)
Result: TRUE only if both are TRUEQ5
A2: =2>9
Result: FALSESection E: Spot the Error
Q1
A — A Boolean yes/no field has only two possible values. Maybe is a third option, so the field should be Member (Yes/No).
Q2
B — A comparison gives a Boolean result. =A1+50 gives the number 122, not TRUE or FALSE. It should be =A1>50.
Q3
B — A field that only holds TRUE or FALSE (paid or not paid) has the Boolean data type, not Integer.
Q4
C — 8 is not less than 5, so the comparison =A2<5 gives FALSE, not TRUE.
Q5
C — The closing bracket is missing. The IF formula uses the Boolean result in B1 and must end with ), so it should be =IF(B1,"Adult","Minor").