ACARA Digital Technologies Years 9–10 Crossword: Analysing and Visualising Data (Modules 413–424)
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. Arranging charts, slicers and key figures on one sheet, neatly aligned and sized, with gridlines hidden, so the main message is easy to see at a glance. Word 2 of: _________ ______ (6)
- 4. Pulls the value from cell B2 on the sheet named ______. Write the sheet name, then !, then the cell. Names with spaces need quotes: ='Sales ______'!B2. Word 1 of: =____!B2 (4)
- 6. Word 1 of the term in 3 Across: _________ ______ (9)
- 8. A chart built from a filtered table plots only the visible rows, so applying or clearing a filter updates the chart. Hidden rows stay out unless Show data in hidden rows is on. Word 3 of: Plot visible _____ only (5)
- 10. A chart title linked to a cell. Click the title, type = then a cell or text joined with &, and the title updates when the cell changes, such as a drop-down choice. Word 1 of: ="_____ for "&B1 (5)
Down
- 1. A drop-down in one cell, made with Data ______, that lets the user pick an item from a range; formulas read that cell so the chart shows only the chosen item. Word 2 of: ____ __________ ____ (10)
- 2. A slicer setting that links one slicer to many pivot tables. Tick each pivot table to connect; they must share the same source data. One click then updates every linked chart. Word 2 of: Report ___________ (11)
- 5. ______ finds the row of the item chosen in the selector cell A13. INDEX returns that whole row into a helper range, and the chart plots the helper range, so it updates when the choice changes. Word 4 of: =INDEX(B2:M10,_____(A13,A2:A10,0),0) (5)
- 7. A readable name given to a cell or ______, like Selected_Year, which formulas and charts can use instead of cell addresses such as B2:B30. Word 2 of: Named _____ (5)
- 9. Word 3 of the term in 1 Down: ____ __________ ____ (4)
Answer Key
ACARA Digital Technologies Years 9–10 · Modules 413–424
1V
A
L
I
D
2C
A
3L
A
Y
O
U
T
N
I
N
O
E
N
C
4D
A
T
A
5M
I
6D
A
S
H
B
O
A
7R
D
T
N
A
8C
E
L
9L
S
N
H
I
G
10S
A
L
E
S
T
Across
3LAYOUT — Arranging charts, slicers and key figures on one sheet, neatly aligned and sized, with gridlines hidden, so the main message is easy to see at a glance. Word 2 of: _________ ______
4DATA — Pulls the value from cell B2 on the sheet named ______. Write the sheet name, then !, then the cell. Names with spaces need quotes: ='Sales ______'!B2. Word 1 of: =____!B2
6DASHBOARD — Word 1 of the term in 3 Across: _________ ______
8CELLS — A chart built from a filtered table plots only the visible rows, so applying or clearing a filter updates the chart. Hidden rows stay out unless Show data in hidden rows is on. Word 3 of: Plot visible _____ only
10SALES — A chart title linked to a cell. Click the title, type = then a cell or text joined with &, and the title updates when the cell changes, such as a drop-down choice. Word 1 of: ="_____ for "&B1
Down
1VALIDATION — A drop-down in one cell, made with Data ______, that lets the user pick an item from a range; formulas read that cell so the chart shows only the chosen item. Word 2 of: ____ __________ ____
2CONNECTIONS — A slicer setting that links one slicer to many pivot tables. Tick each pivot table to connect; they must share the same source data. One click then updates every linked chart. Word 2 of: Report ___________
5MATCH — ______ finds the row of the item chosen in the selector cell A13. INDEX returns that whole row into a helper range, and the chart plots the helper range, so it updates when the choice changes. Word 4 of: =INDEX(B2:M10,_____(A13,A2:A10,0),0)
7RANGE — A readable name given to a cell or ______, like Selected_Year, which formulas and charts can use instead of cell addresses such as B2:B30. Word 2 of: Named _____
9LIST — Word 3 of the term in 1 Down: ____ __________ ____