Lesson 2.1.3

2.1.3 User interface Quiz: OCR IT, Unit 2

20 questions

Written by Revision Ninja · Last reviewed 11 October 2026

In partnership with Revision Ninja

Lesson 2.1.3, User interface: 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.

Host this setFree Play

The 20 questions

  1. What is a button in a spreadsheet user interface typically used for?

    • Formatting cells
    • Triggering macros
    • Locking sheets
    • Storing formulas

  2. What is a spreadsheet macro?

    • Data filter
    • Chart template
    • Automated actions
    • Static formula

  3. What is the main purpose of a hyperlink on a spreadsheet menu sheet?

    • Calculating totals
    • Sorting rows
    • Navigating locations
    • Validating input

  4. Which interface element lets users enter data into a structured set of fields?

    • Form
    • Chart
    • Pivot table
    • Print area

  5. What action is needed to make a graphical button execute a macro?

    • Locking the cell
    • Naming the range
    • Assigning the macro
    • Protecting the sheet

  6. Which feature allows users to easily return to the main menu from any sheet?

    • Page break
    • Data validation
    • Navigation hyperlink
    • Conditional formatting

  7. A user must choose one of three exclusive options. Which control is suitable?

    • Tick boxes
    • Radio buttons
    • Hyperlink
    • Macro button

  8. Which component provides a dropdown list of options to save interface space?

    • Command button
    • Scroll bar
    • Combo box
    • Text box

  9. Where should a hyperlink direct a user to remain useful?

    • Deleted sheet
    • External website
    • Existing location
    • Unformatted cell

  10. Which interface element allows a user to type custom text into a field?

    • Text box
    • Drop-down list
    • Check box
    • Option button

  11. What defines a spreadsheet user interface that is fit for purpose?

    • Containing macros
    • Using bright colours
    • Having many sheets
    • Completing required tasks

  12. Why must users be able to navigate fully around a spreadsheet solution?

    • Speeding up macros
    • Accessing all areas
    • Reducing file size
    • Hiding raw data

  13. Which feature saves the most time when adding identical records repeatedly?

    • Pie chart
    • Spell check
    • Macro button
    • Grid lines

  14. Which configuration ensures the correct menu appears immediately when a file opens?

    • Start-up settings
    • Page setup
    • Print area
    • Grid line display

  15. Which feature helps reduce data entry errors on a form?

    • Cell shading
    • Chart wizard
    • Page borders
    • Validation rules

  16. What is the main advantage of using a macro for a repeated task?

    • Locks the sheet
    • Automates steps
    • Increases file size
    • Deletes old data

  17. What must a menu hyperlink contain to open an external website?

    • Macro code
    • URL address
    • File password
    • Cell reference

  18. Which button name is most meaningful for printing a monthly report?

    • Do Task
    • Click Here
    • Print Monthly Report
    • Button 1

  19. Why might a designer use a hyperlink instead of a macro button for navigation?

    • Secures cells
    • Formats data
    • Runs faster
    • No code needed

  20. Why protect a spreadsheet form so only specific cells can be edited?

    • Prevent accidental edits
    • Reduce file size
    • Speed up formulas
    • Enable macros

All OCR IT quizzes