ACARA Digital Technologies Years 9–10 Crossword: Analysing and Visualising Data (Modules 378–412)
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
- 3. Word 4 of the term in 1 Down: ____, Columns, ______, _______ (7)
- 5. Finds Q1, the value 25% of the way up the data. Use 3 for Q3. IQR = Q3 - Q1. A value more than 1.5 times the IQR below Q1 or above Q3 is flagged as an outlier. Word 1 of: =________.INC(B2:B100,1) (8)
- 7. A pivot table option that changes what is calculated for each group, such as Sum, Count or Average. It can also show values as a % of column total and set the number format. Word 3 of: Value Field ________ (8)
- 9. ______ gives m and INTERCEPT gives c of the best-fit line, so a prediction can be written as y = m*x + c. Both functions take known_y first, then known_x. Word 1 of: _____ and INTERCEPT (5)
- 10. Word 1 of the term in 8 Down: =_______(value, value_if______) (7)
Down
- 1. The four areas of the PivotTable field list. Drag a field into one to lay out the summary: ______ and Columns label it, ______ calculates, ______ narrows the data. Word 3 of: ____, Columns, ______, _______ (6)
- 2. A chart linked to a pivot table. It updates whenever you change the pivot table's fields or filters. Create it with Insert > ______. (10)
- 4. Word 1 of the term in 1 Down: ____, Columns, ______, _______ (4)
- 6. A ______ slicer filters a pivot table by dragging along a date range. Pick months, quarters or years from the time level drop-down. It needs a date field. Word 2 of: Insert > ________ (8)
- 8. Runs a formula and shows your chosen value, like 0 or "Not found", if it gives an ______. Use it carefully, because it can also hide real mistakes. Word 5 of: =_______(value, value_if______) (5)
Answer Key
ACARA Digital Technologies Years 9–10 · Modules 378–412
1V
A
2P
L
3F
I
L
T
E
4R
S
U
V
O
5Q
U
A
R
6T
I
L
E
O
W
I
7S
8E
T
T
I
N
G
S
M
R
C
9S
L
O
P
E
R
H
L
O
A
10I
F
E
R
R
O
R
N
T
E
Across
3FILTERS — Word 4 of the term in 1 Down: ____, Columns, ______, _______
5QUARTILE — Finds Q1, the value 25% of the way up the data. Use 3 for Q3. IQR = Q3 - Q1. A value more than 1.5 times the IQR below Q1 or above Q3 is flagged as an outlier. Word 1 of: =________.INC(B2:B100,1)
7SETTINGS — A pivot table option that changes what is calculated for each group, such as Sum, Count or Average. It can also show values as a % of column total and set the number format. Word 3 of: Value Field ________
9SLOPE — ______ gives m and INTERCEPT gives c of the best-fit line, so a prediction can be written as y = m*x + c. Both functions take known_y first, then known_x. Word 1 of: _____ and INTERCEPT
10IFERROR — Word 1 of the term in 8 Down: =_______(value, value_if______)
Down
1VALUES — The four areas of the PivotTable field list. Drag a field into one to lay out the summary: ______ and Columns label it, ______ calculates, ______ narrows the data. Word 3 of: ____, Columns, ______, _______
2PIVOTCHART — A chart linked to a pivot table. It updates whenever you change the pivot table's fields or filters. Create it with Insert > ______.
4ROWS — Word 1 of the term in 1 Down: ____, Columns, ______, _______
6TIMELINE — A ______ slicer filters a pivot table by dragging along a date range. Pick months, quarters or years from the time level drop-down. It needs a date field. Word 2 of: Insert > ________
8ERROR — Runs a formula and shows your chosen value, like 0 or "Not found", if it gives an ______. Use it carefully, because it can also hide real mistakes. Word 5 of: =_______(value, value_if______)