Lesson 2.1.1
2.1.1 Data handling and manipulation Quiz: OCR IT, Unit 2
20 questions
In partnership with Revision Ninja
Lesson 2.1.1, Data handling and manipulation: 20 multiple choice questions for the OCR IT (J836), Unit 2: Data manipulation using spreadsheets, written with Revision Ninja.
Host it live on the board and students join with a game code on their own devices, or revise alone with Free Play. The answers are revealed in the game.
The 20 questions
-
Which validation type checks that a value matches an entry in a list held elsewhere?
- Range check
- Lookup
- Text length
- Conditional check
-
Which validation checks a number lies between 1 and 12?
- Lookup
- Limited choice
- Range check
- Text length
-
Which validation ensures a product code has exactly 6 characters?
- Limited choice
- Text length
- Range check
- Lookup
-
Which validation restricts input to options such as Yes or No?
- Text length
- Range check
- Limited choice
- Lookup
-
Which control suits choosing one item from a long list of options in a small space?
- Radio buttons
- Drop-down list
- Tick list
- Text box
-
Which control lets a user choose several options at once?
- Tick list
- Radio buttons
- Single text box
- Drop-down list
-
Which operator checks that two values are not equal?
- =
- >=
- <=
- <>
-
Which formula returns 'Pass' if the mark in B2 is 40 or more?
- =IF(B2>40,"Pass","Fail")
- =IF(B2=40,"Pass","Fail")
- =IF(B2<40,"Pass","Fail")
- =IF(B2>=40,"Pass","Fail")
-
Which security measure stops users accidentally changing spreadsheet formulae?
- Renaming worksheets
- Sorting ranges
- Locking cells
- Clearing filters
-
A formula in C1 is =A1*B1 and copied down to C2. What does C2 contain?
- =A2*B2
- =A1*B1
- =A3*B3
- =A1*B2
-
Which reference keeps a tax rate in cell F1 fixed when copied down?
- =F1
- =$F$1
- =F$1
- =$F1
-
What is the main benefit of naming a cell range TaxRate?
- Clearer formulas
- Higher resolution
- Smaller file size
- Faster printing
-
How do you refer to cell B4 on a sheet named Sales in a formula?
- Sales:B4
- Sales!B4
- Sales.B4
- Sales/B4
-
Which function returns the highest value in a range?
- MAX
- AVERAGE
- COUNT
- MIN
-
Which function counts cells in a range that meet one condition?
- SUM
- COUNTIF
- AVERAGE
- COUNT
-
A column holds region names and sales. Which function totals sales for only the North region?
- SUMIF
- SUBTOTAL
- COUNTIF
- VLOOKUP
-
Which lookup searches down the first column of a table?
- AND
- VLOOKUP
- DATE
- HLOOKUP
-
What does the spreadsheet error code #DIV/0! indicate?
- Division by zero
- Invalid cell name
- Missing text format
- Column too narrow
-
Which modelling tool changes an input to see how a result changes?
- Conditional formatting
- What-if analysis
- Data validation
- Pivot table
-
Which error shows a formula uses a name the spreadsheet does not recognise?
- #NAME?
- #DIV/0!
- #REF!
- #VALUE!
Related quizzes
- Design tools Quiz · 1.1 · 20 questions
- Functionality Quiz · 1.2.1 · 20 questions
- Types of outputs that clearly present information for an organisation Quiz · 1.2.2 · 20 questions
- Human Computer Interface (HCI) Quiz · 1.2.3 · 20 questions
- Techniques to generate the outputs Quiz · 2.1.2 · 20 questions
- User interface Quiz · 2.1.3 · 20 questions
- Test the user interface and the technical aspects of the spreadsheet solution Quiz · 3.1 · 20 questions
- Methods used to evaluate the success of the spreadsheet solution Quiz · 4.1 · 20 questions
- Types of design tools Quiz · 1.1 · 20 questions
- Purpose and uses of Augmented Reality (AR) Quiz · 1.1 · 20 questions