← All printables
VCE Spreadsheets, SQL & Visualisation · Modules 4–20

Tip: Choose Save as PDF in the print dialog to download. Use A4 paper size.

A free printable VCE Spreadsheets, SQL & Visualisation crossword with 10 clues, built from the key terms of Spreadsheet structure, formulas and functions and Descriptive statistics (Modules 4–20) — Naming worksheets consistently, Header labels for rows and columns, Relative and absolute cell references, The COUNTIF function, The SUMIF function, The IF function in a spreadsheet and more. Print it or save it as a PDF — the answer key starts on its own page. No login needed.

VCE Spreadsheets, SQL & Visualisation Crossword: Spreadsheet structure, formulas and functions and Descriptive statistics (Modules 4–20)

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

  1. 3. A ______ in the first row or column that names the data below or beside it. Use one per column, add units like Height_cm, and keep capitalisation consistent. Word 2 of: ______ _____ (5)
  2. 4. Adds only the numbers in _______range whose matching cell in range meets the criteria, such as the total of all sales for one category. Word 4 of: =SUMIF(_____, ________, _________) (3)
  3. 7. Word 5 of the term in 1 Down: =IF(test, value_if_____, value_if______) (4)
  4. 8. A short, clear worksheet tab name that describes what the sheet holds. Use one consistent style with no spaces, and keep ______ ______ on a separate tab from analysis, such as Summary. Word 2 of: ________ (4)
  5. 9. Word 1 of the term in 8 Across: ________ (3)
  6. 10. Word 2 of the term in 2 Down: =COUNTIF(_____, ________) (5)

Down

  1. 1. Checks a test, like B2>=50. Shows the second value if the test is ______ and the third if it is ______. Text results go in quotes, e.g. =IF(B2>=50,"Pass","Fail"). Word 8 of: =IF(test, value_if_____, value_if______) (5)
  2. 2. Counts how many cells in a ______ match a value or condition, such as "Yes" or ">10". Example: =COUNTIF(C2:C30,"Yes") counts every Yes in C2 to C30. Word 3 of: =COUNTIF(_____, ________) (8)
  3. 5. Returns the middle value of the numbers in B2:B30 once ordered. With an even count it averages the middle two. You do not need to sort the cells first. Word 1 of: =______(B2:B30) (6)
  4. 6. Word 1 of the term in 3 Across: ______ _____ (6)

Answer Key

VCE Spreadsheets, SQL & Visualisation · Modules 4–20
1F
2C
3L
A
B
E
L
R
L
I
4S
U
5M
6H
7T
R
U
E
E
E
E
8D
A
T
A
9R
A
W
I
D
I
10R
A
N
G
E
A
N
R
Across
3LABEL — A ______ in the first row or column that names the data below or beside it. Use one per column, add units like Height_cm, and keep capitalisation consistent. Word 2 of: ______ _____
4SUM — Adds only the numbers in _______range whose matching cell in range meets the criteria, such as the total of all sales for one category. Word 4 of: =SUMIF(_____, ________, _________)
7TRUE — Word 5 of the term in 1 Down: =IF(test, value_if_____, value_if______)
8DATA — A short, clear worksheet tab name that describes what the sheet holds. Use one consistent style with no spaces, and keep ______ ______ on a separate tab from analysis, such as Summary. Word 2 of: ________
9RAW — Word 1 of the term in 8 Across: ________
10RANGE — Word 2 of the term in 2 Down: =COUNTIF(_____, ________)
Down
1FALSE — Checks a test, like B2>=50. Shows the second value if the test is ______ and the third if it is ______. Text results go in quotes, e.g. =IF(B2>=50,"Pass","Fail"). Word 8 of: =IF(test, value_if_____, value_if______)
2CRITERIA — Counts how many cells in a ______ match a value or condition, such as "Yes" or ">10". Example: =COUNTIF(C2:C30,"Yes") counts every Yes in C2 to C30. Word 3 of: =COUNTIF(_____, ________)
5MEDIAN — Returns the middle value of the numbers in B2:B30 once ordered. With an even count it averages the middle two. You do not need to sort the cells first. Word 1 of: =______(B2:B30)
6HEADER — Word 1 of the term in 3 Across: ______ _____

Modules this crossword covers

Every module has its own free printable worksheet with an answer key, and students can practise the same terms interactively on Cloodit.

Part of: VCE Applied Computing - U1O1 - Data analysis, VCE Data Analytics - U3O1 - Data Analytics, VCE Data Analytics - U3O2 - Analysis and Design, VCE Data Analytics - U4O1 - Development and Evaluation, 7-8 Digital Technologies: Analysing and visualising data, 9-10 Digital Technologies: Acquiring, storing and validating data, ACARA Digital Technologies Years 7–8 — Acquiring and Storing Data, ACARA Digital Technologies Years 7–8 — Analysing and Visualising Data, ACARA Digital Technologies Years 9–10 — Acquiring and Validating Data, ACARA Digital Technologies Years 9–10 — Analysing and Visualising Data, ACARA Digital Technologies Years 9–10 — Cyber Security Threats and Vulnerabilities

More VCE Spreadsheets, SQL & Visualisation printables

This printable is free — no login needed.

Make a free class, give it a journey, and you also get:

Create a free teacher account →

No credit card. No setup fee. Make a class and invite students in under three minutes.