placeholder image to represent content

Year 7 Modelling Data (NCCE): Assessment

Quiz by Stuart Smith

Key stage 3
Computing (ARCHIVED)
English National Curriculum

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
20 questions
Show answers
  • Q1

    What is data?

    The understanding that we gain from raw numbers and figures

    Raw numbers and figures

    45s
    KS3.C.7
  • Q2

    We use a spreadsheet to c _ _ _ _ _ _, log and interpret data.

    Users re-arrange answers into correct order
    Jumble
    60s
    KS3.C.7
  • Q3

    A spreadsheet's purpose is to organise

    Users re-arrange answers into correct order
    Jumble
    60s
    KS3.C.7
  • Q4

    "Spreadsheets are particularly useful for powerful c _ _ _ _ _ _ _ _ _ _ _"

    Users enter free text
    Type an Answer
    60s
    KS3.C.7
  • Q5

    Name a spreadsheet program

    Microsoft Word

    Microsoft Excel

    Google Sheets

    Google Docs

    Microsoft PowerPoint

    30s
    KS3.C.7
  • Q6

    A spreadsheet can contain more than one ...

    Users re-arrange answers into correct order
    Jumble
    60s
    KS3.C.7
  • Q7

    The row number and column letter for a cell is called the...

    Cell reference

    Cell recommendation

    Cell direction

    Cell citation

    30s
    KS3.C.7
  • Q8

    We can type data into a cell by...

    Double-clicking in the cell

    Selecting the cell

    Using the formula bar

    30s
    KS3.C.7
  • Q9

    "To organise our data in a spreadsheet, we can use s____ and f______ " Pick one of these words from the list.

    Format

    Sort

    Size

    Filter

    30s
    KS3.C.7
  • Q10

    To create a mathematical calculation in a spreadsheet we can use a...

    Users re-arrange answers into correct order
    Jumble
    60s
    KS3.C.7
  • Q11

    Link together the follow calculation formula symbols. PLAN YOUR ANSWER FIRST AS YOU CANNOT CHANGE THE LINK ONCE MADE!

    Users link answers
    Linking
    60s
    KS3.C.7
  • Q12

    Which one of these is the correct way to make a formula?

    =D1xD2

    =d1*d2

    =1D*2D

    =D1*D2

    30s
    KS3.C.7
  • Q13

    By moving your mouse to the right-hand corner of a cell with a formula in (like the picture shows), so that it changes to a cross shape, then dragging to replicate your formulas, is called...

    Question Image

    Create cells

    Move cells

    Fill cells

    Highlight cells

    30s
    KS3.C.7
  • Q14

    Match the named function to its purpose. PLAN YOUR ANSWER FIRST AS YOU CANNOT CHANGE THE LINK ONCE MADE!

    Users link answers
    Linking
    60s
    KS3.C.7
  • Q15

    To change the cell colour or font I would ________ the cell

    Users re-arrange answers into correct order
    Jumble
    60s
    KS3.C.7

Teachers give this quiz to your class