VCE Spreadsheets, SQL & Visualisation Crossword: Descriptive statistics and Manipulating, validating and testing spreadsheet data (Modules 21–34)
Name:
Date:
Class:
✎
Crossword
Read each clue and write the matching term in the grid. Numbers in brackets show the letters in each word.
1
2
3
4
5
6
7
8
9
10
Across
- 1. A measure of how spread out values are around the mean. A small value means the data is clustered close to the mean. A large value means it is widely spread. It uses the same units as the data. Word 2 of: ________ _________ (9)
- 4. The answer you work out by hand using a few rows of data. Compare it with the formula's actual ______. If they match, the formula works. If not, check the formula and its range. Word 2 of: expected ______ (6)
- 8. A spreadsheet tool that changes a cell's colour or icon automatically when its value meets a rule, so highs, lows and outliers stand out. Word 1 of: ___________ formatting (11)
- 9. A message that pops up when someone enters data that breaks a validation rule. It can Stop the entry, Warn about it, or give Information, and a good message explains how to fix it. Word 1 of: _____ alert (5)
- 10. Returns the sample standard deviation of the numbers in a range, showing how spread out they are. Use ______.P if the range is the whole population. Word 1 of: =_____.S(B2:B30) (5)
Down
- 2. An automatic check that data is reasonable and allowed when it is entered, such as being in range or the right type, so typos and impossible values are caught. (10)
- 3. A text function that returns a tidy copy of the text in A2 with extra spaces removed. UPPER, LOWER and PROPER work the same way to fix capitals, e.g. =PROPER(A2) gives Mia Chen. Word 1 of: =____(A2) (4)
- 5. Word 1 of the term in 1 Across: ________ _________ (8)
- 6. Counts the numbers in a range that are at least the lower limit and less than the upper limit, giving the frequency of one bin. Equal-width bins must not leave gaps or overlap. Word 1 of: =________(B2:B30,">=10",B2:B30,"<20") (8)
- 7. A rule that only lets a cell accept a number between a minimum and maximum, like age 11 to 14. Numbers outside the range are rejected. Use Decimal for numbers with parts. Word 4 of: Data > Data __________ > _____ number between (5)
Answer Key
VCE Spreadsheets, SQL & Visualisation · Modules 21–34
1D
E
2V
I
A
T
I
O
N
3T
A
4R
E
5S
U
L
T
I
T
I
6C
7W
M
A
D
O
H
N
A
U
O
8C
O
N
D
I
T
I
O
N
A
L
A
I
T
E
9E
R
R
O
R
I
D
N
F
10S
T
D
E
V
Across
1DEVIATION — A measure of how spread out values are around the mean. A small value means the data is clustered close to the mean. A large value means it is widely spread. It uses the same units as the data. Word 2 of: ________ _________
4RESULT — The answer you work out by hand using a few rows of data. Compare it with the formula's actual ______. If they match, the formula works. If not, check the formula and its range. Word 2 of: expected ______
8CONDITIONAL — A spreadsheet tool that changes a cell's colour or icon automatically when its value meets a rule, so highs, lows and outliers stand out. Word 1 of: ___________ formatting
9ERROR — A message that pops up when someone enters data that breaks a validation rule. It can Stop the entry, Warn about it, or give Information, and a good message explains how to fix it. Word 1 of: _____ alert
10STDEV — Returns the sample standard deviation of the numbers in a range, showing how spread out they are. Use ______.P if the range is the whole population. Word 1 of: =_____.S(B2:B30)
Down
2VALIDATION — An automatic check that data is reasonable and allowed when it is entered, such as being in range or the right type, so typos and impossible values are caught.
3TRIM — A text function that returns a tidy copy of the text in A2 with extra spaces removed. UPPER, LOWER and PROPER work the same way to fix capitals, e.g. =PROPER(A2) gives Mia Chen. Word 1 of: =____(A2)
5STANDARD — Word 1 of the term in 1 Across: ________ _________
6COUNTIFS — Counts the numbers in a range that are at least the lower limit and less than the upper limit, giving the frequency of one bin. Equal-width bins must not leave gaps or overlap. Word 1 of: =________(B2:B30,">=10",B2:B30,"<20")
7WHOLE — A rule that only lets a cell accept a number between a minimum and maximum, like age 11 to 14. Numbers outside the range are rejected. Use Decimal for numbers with parts. Word 4 of: Data > Data __________ > _____ number between