ACARA Digital Technologies Years 7–8 Crossword: Acquiring and Storing Data and Analysing and Visualising Data (Modules 261–300)
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
Across
- 2. Shows ______ if B2 is below 0 or above 100, otherwise OK. OR needs just one true test, so it catches both ends. AND would never work because no value is both below 0 and above 100. Word 7 of: =IF(OR(B2<0,B2>100),"_____","OK") (5)
- 4. Word 1 of the term in 3 Down: =_____(______, digits) (5)
- 6. Match the key words in a question to a function: total is SUM, how many is COUNT, typical is ______, lowest is ______, highest is ______. Word 4 of: SUM COUNT _______ ___ ___ (3)
- 8. Word 3 of the term in 6 Across: SUM COUNT _______ ___ ___ (7)
Down
- 1. A spreadsheet tool (Ctrl+H) that finds every cell with one spelling and changes them all to the correct spelling in one step, like turning Sydeny into Sydney. Word 3 of: Find and _______ (7)
- 2. ______ counts every cell in a range that is not empty, including text. Use it to count survey responses. COUNT only counts numbers. Word 1 of: =______(A2:A100) (6)
- 3. Rounds a ______ to a set ______ of decimal places. Use 1 for one decimal place or 0 for a whole ______, e.g. =______(AVERAGE(B2:B9),1). It changes the value itself, not just how it looks. Word 2 of: =_____(______, digits) (6)
- 5. A quality summary counts problems with formulas like this one. It counts cells flagged Check. COUNTBLANK counts empty cells. Each problem count should reach 0 after cleaning. Word 3 of: =COUNTIF(D2:____,"_____") (4)
- 6. Word 5 of the term in 6 Across: SUM COUNT _______ ___ ___ (3)
- 7. An untouched copy of the original data, made by duplicating the worksheet or using Save As before cleaning, so you clean only the copy and never lose the original. Word 1 of: ___ data copy (3)
Answer Key
ACARA Digital Technologies Years 7–8 · Modules 261–300
1R
2C
H
E
C
K
O
P
3N
U
L
4R
O
U
N
5D
6M
I
N
A
M
1
A
T
C
7R
B
0
X
8A
V
E
R
A
G
E
0
W
R
Across
2CHECK — Shows ______ if B2 is below 0 or above 100, otherwise OK. OR needs just one true test, so it catches both ends. AND would never work because no value is both below 0 and above 100. Word 7 of: =IF(OR(B2<0,B2>100),"_____","OK")
4ROUND — Word 1 of the term in 3 Down: =_____(______, digits)
6MIN — Match the key words in a question to a function: total is SUM, how many is COUNT, typical is ______, lowest is ______, highest is ______. Word 4 of: SUM COUNT _______ ___ ___
8AVERAGE — Word 3 of the term in 6 Across: SUM COUNT _______ ___ ___
Down
1REPLACE — A spreadsheet tool (Ctrl+H) that finds every cell with one spelling and changes them all to the correct spelling in one step, like turning Sydeny into Sydney. Word 3 of: Find and _______
2COUNTA — ______ counts every cell in a range that is not empty, including text. Use it to count survey responses. COUNT only counts numbers. Word 1 of: =______(A2:A100)
3NUMBER — Rounds a ______ to a set ______ of decimal places. Use 1 for one decimal place or 0 for a whole ______, e.g. =______(AVERAGE(B2:B9),1). It changes the value itself, not just how it looks. Word 2 of: =_____(______, digits)
5D100 — A quality summary counts problems with formulas like this one. It counts cells flagged Check. COUNTBLANK counts empty cells. Each problem count should reach 0 after cleaning. Word 3 of: =COUNTIF(D2:____,"_____")
6MAX — Word 5 of the term in 6 Across: SUM COUNT _______ ___ ___
7RAW — An untouched copy of the original data, made by duplicating the worksheet or using Save As before cleaning, so you clean only the copy and never lose the original. Word 1 of: ___ data copy