ACARA Digital Technologies Years 9–10 Word Scramble: Analysing and Visualising Data (Modules 413–424)
Name:
Date:
Class:
🔤
Word scramble
Unscramble the letters and write each key term on the line.
1
ORTERP IOSNCONCTNE
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.
2
=AABD!T2
Pulls the value from cell B2 on the sheet named Data. Write the sheet name, then !, then the cell. Names with spaces need quotes: ='Sales Data'!B2.
3
DMAEN ARGNE
A readable name given to a cell or range, like Selected_Year, which formulas and charts can use instead of cell addresses such as B2:B30.
4
TADA DILATINOAV ISLT
A drop-down in one cell, made with Data Validation, that lets the user pick an item from a range; formulas read that cell so the chart shows only the chosen item.
5
RMOF OLOTRNC
A Developer tab control, such as an option button or combo box, that writes the user's choice into a linked cell so formulas and charts can react.
6
CLRSOL ARB
A form control that changes a linked cell's number between a minimum and maximum, in steps, so a chart can move through values like years. A spin button does the same.
7
="LESSA ORF "&1B
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.
8
LPOT BSIVLIE SCELL NYLO
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.
9
AOARSDHBD UAYOTL
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.
Answer Key
ACARA Digital Technologies Years 9–10 · Modules 413–424
1ORTERP IOSNCONCTNE → Report Connections — 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.
2=AABD!T2 → =Data!B2 — Pulls the value from cell B2 on the sheet named Data. Write the sheet name, then !, then the cell. Names with spaces need quotes: ='Sales Data'!B2.
3DMAEN ARGNE → Named range — A readable name given to a cell or range, like Selected_Year, which formulas and charts can use instead of cell addresses such as B2:B30.
4TADA DILATINOAV ISLT → Data Validation List — A drop-down in one cell, made with Data Validation, that lets the user pick an item from a range; formulas read that cell so the chart shows only the chosen item.
5RMOF OLOTRNC → form control — A Developer tab control, such as an option button or combo box, that writes the user's choice into a linked cell so formulas and charts can react.
6CLRSOL ARB → Scroll bar — A form control that changes a linked cell's number between a minimum and maximum, in steps, so a chart can move through values like years. A spin button does the same.
7="LESSA ORF "&1B → ="Sales for "&B1 — 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.
8LPOT BSIVLIE SCELL NYLO → Plot visible cells only — 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.
9AOARSDHBD UAYOTL → Dashboard layout — 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.