Lesson 2.1.2
2.1.2 Techniques to generate the outputs Quiz: OCR IT, Unit 2
20 questions
In partnership with Revision Ninja
Lesson 2.1.2, Techniques to generate the outputs: 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 chart type is best for showing change over time?
- Pie chart
- Line chart
- Doughnut chart
- Radar chart
-
Which chart shows each part's share of a whole?
- Line chart
- Pie chart
- Scatter plot
- Histogram
-
Which setting repeats chosen rows at the top of every printed page?
- Scaling
- Print area
- Print titles
- Gridlines
-
How do you show a hidden column again?
- Lock the column
- Unhide the column
- Sort the column
- Delete the column
-
Which feature expands a column so all text is visible?
- Conditional formatting
- Data validation
- Autofit column width
- Protect sheet
-
Which feature ensures all outputs follow the agreed house style?
- Sorting alphabetically
- Adding data filters
- Using a template
- Hiding gridlines
-
Why check a finished spreadsheet output against the design plan?
- Speeding up macros
- Checking user needs
- Updating software
- Reducing file size
-
Why might a designer hide specific rows in a spreadsheet output?
- Encrypting the workbook
- Deleting raw data
- Focusing user attention
- Fixing formula errors
-
What essential elements must be checked after creating a chart?
- Cell passwords
- Validation rules
- Axes and titles
- Macro buttons
-
What must every spreadsheet chart be based upon?
- Selected data range
- File metadata
- Printer settings
- Locked worksheet
-
Why adjust row height in a printed table?
- Sorting data alphabetically
- Changing formula syntax
- Improving text readability
- Enabling macro execution
-
Why keep column headings visible when scrolling a large table?
- Speeding calculations
- Maintaining data context
- Securing formulas
- Reducing print time
-
Which technique automatically updates a summary when data changes?
- Static text entries
- Manual typing
- Using formulas
- Hiding gridlines
-
Which chart element explains the units on the vertical axis?
- Gridline
- Chart title
- Axis title
- Chart legend
-
Which chart element shows the exact value next to each bar?
- Legend
- Axis scale
- Gridlines
- Data labels
-
When is a chart legend strictly required?
- Blank spreadsheet
- Locked cell range
- Multiple data series
- Single data row
-
What is the main risk of starting a chart vertical axis at 50 rather than 0?
- Inverted trends
- Exaggerated differences
- Hidden data
- Corrupted formulas
-
What does page break preview primarily help a user check?
- Cell formatting
- Macro execution
- Formula errors
- Print page splits
-
A report's date field must always show today's date. Which function is used?
- TIME
- TODAY
- SUMIF
- DATE
-
Which chart type is best suited for comparing values across discrete categories?
- Pie chart
- Flowchart
- Scatter graph
- Bar chart
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
- Data handling and manipulation Quiz · 2.1.1 · 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