VCE Spreadsheets, SQL & Visualisation Word Scramble: Descriptive statistics and Manipulating, validating and testing spreadsheet data (Modules 21–34)
Name:
Date:
Class:
🔤
Word scramble
Unscramble the letters and write each key term on the line.
1
=0ES2S.3(BT:VBD)
Returns the sample standard deviation of the numbers in a range, showing how spread out they are. Use STDEV.P if the range is the whole population.
2
ASDNTRAD ODVINEIAT
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.
3
=RAM2(IT)
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.
4
ILNOIADAVT
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.
5
TLIS LVNIOATADI
A rule that lets a cell accept only items from a set list, shown as a drop-down. Items can be typed in or taken from a range of cells, which keeps spelling consistent.
6
RROER TLEAR
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.
7
XTEEEDCP TUERSL
The answer you work out by hand using a few rows of data. Compare it with the formula's actual result. If they match, the formula works. If not, check the formula and its range.
Answer Key
VCE Spreadsheets, SQL & Visualisation · Modules 21–34
1=0ES2S.3(BT:VBD) → =STDEV.S(B2:B30) — Returns the sample standard deviation of the numbers in a range, showing how spread out they are. Use STDEV.P if the range is the whole population.
2ASDNTRAD ODVINEIAT → standard deviation — 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.
3=RAM2(IT) → =TRIM(A2) — 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.
4ILNOIADAVT → validation — 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.
5TLIS LVNIOATADI → List validation — A rule that lets a cell accept only items from a set list, shown as a drop-down. Items can be typed in or taken from a range of cells, which keeps spelling consistent.
6RROER TLEAR → Error alert — 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.
7XTEEEDCP TUERSL → expected result — The answer you work out by hand using a few rows of data. Compare it with the formula's actual result. If they match, the formula works. If not, check the formula and its range.