Lesson 1.2.1
1.2.1 Functionality Quiz: OCR IT, Unit 2
20 questions
In partnership with Revision Ninja
Lesson 1.2.1, Functionality: 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
-
What action does filtering perform in a spreadsheet solution?
- Reorders table rows
- Deletes duplicate data
- Hides unmatched rows
- Locks cell formats
-
What does sorting sales figures from largest to smallest achieve?
- Lowest value first
- Alphabetical sorting
- Random row order
- Highest value first
-
What is the main purpose of a spreadsheet data entry message?
- Formatting cell borders
- Guiding user input
- Locking spreadsheet formulas
- Deleting invalid sheets
-
Which two features are classified as user aids in spreadsheet design?
- Rows and columns
- Data entry messages
- SUM and AVERAGE
- Charts and graphs
-
Which functionality restricts cell input and shows a custom warning?
- Absolute referencing
- Data validation
- Cell merging
- Conditional formatting
-
What flowchart symbol is used to check a target value in a calculation?
- Decision step
- Input terminal
- Process box
- Connector circle
-
How does spreadsheet filtering fundamentally differ from sorting?
- Creates new charts
- Calculates totals
- Hides unmatching rows
- Changes font size
-
Which spreadsheet feature acts as a user aid to restrict choices?
- VLOOKUP function
- Drop-down list
- Gridlines
- Pie chart
-
Why should a spreadsheet designer include data validation?
- To sort columns
- To speed printing
- To add graphics
- To reduce errors
-
What must a designer specify when planning a calculation functionality?
- File extension
- Inputs and outputs
- Printer margins
- Font and colour
-
A stock sheet must show only items with fewer than 10 units. Which functionality is needed?
- Calculations
- Sorting
- Filtering
- Data entry messages
-
A list of students must be arranged by surname from A to Z. Which functionality is needed?
- Filtering
- Sorting
- User aids
- Data validation
-
A form must stop an age being entered as a negative number. Which functionality best matches?
- Calculations
- Data validation
- Sorting
- Filtering
-
What is the primary purpose of spreadsheet calculation functionality?
- Creating pie charts
- Formatting cell borders
- Filtering text lists
- Processing input values
-
Which spreadsheet feature allows finding records matching two specific rules?
- Multiple-criteria filter
- Single sort rule
- Conditional fill
- Data validation
-
Why is sorting and filtering planned prior to building a spreadsheet?
- To meet user needs
- To choose monitors
- To select hardware
- To reduce file size
-
What is the main benefit of sorting a customer list alphabetically?
- Enhanced security
- Smaller file size
- Automatic emailing
- Quick visual scanning
-
Where should a helpful data entry message appear on a spreadsheet?
- At top of chart
- In printer footer
- On separate sheet
- Near input cell
-
Which functionality changes the order of rows without removing any?
- Data validation
- User aids
- Sorting
- Filtering
-
What symbol shape in a flowchart shows a yes/no decision?
- Oval
- Arrow
- Diamond
- Rectangle
Related quizzes
- Design tools Quiz · 1.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
- Data handling and manipulation Quiz · 2.1.1 · 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