3.1 Test the user interface and the technical aspects of the spreadsheet solution Quiz: OCR IT, Unit 2

The 20 questions

1. Which column in a test plan records what the solution actually did?

   • Remedial action
   • Test number
   • Expected result
   • Actual result

2. What information is recorded in the expected result column of a test plan?

   • Bug fix
   • Tester name
   • Actual outcome
   • Planned outcome

3. What is recorded in the remedial action column when a test fails?

   • The test date
   • The error code
   • The fix applied
   • The original data

4. When should a failed test be repeated in the test plan?

   • During planning
   • Before testing
   • Without changes
   • After applying fix

5. Which test data uses the largest allowed value, such as 100 for a 0-100 range?

   • Valid
   • Default
   • Extreme
   • Random

6. Which test data would enter text into a numeric-only field?

   • Invalid (erroneous)
   • Extreme boundary value
   • Valid numeric entry
   • Normal data entry

7. A cell accepts ages from 16 to 65. Which value is valid test data?

   • 15
   • abc
   • 30
   • 66

8. Which activity is an example of technical testing?

   • Choosing colours
   • Designing layout
   • Asking user opinions
   • Checking formula results

9. Which activity is an example of usability testing?

   • Running extreme data
   • Observing user navigation
   • Counting total sheets
   • Checking formula syntax

10. What should technical testing of navigation check?

    • User satisfaction
    • Font readability
    • Colour scheme appeal
    • Links work correctly

11. When is iterative testing carried out during software development?

    • Before planning stage
    • After final release
    • While building solution
    • During maintenance only

12. Where should actual test results and remedial actions be recorded?

    • In user manual
    • In formula bar
    • In test plan
    • In macro code

13. Why does a test plan assign a unique number to each test?

    • For easy identification
    • To calculate totals
    • To sort alphabet
    • To hide errors

14. Entering 10 and 20 to expect 30 tests which spreadsheet aspect?

    • Calculations
    • Navigation
    • Formatting
    • Validation

15. Which test data best checks a range check from 1 to 100?

    • 0, 1, 100 and 101
    • 50 only
    • Letters only
    • A blank cell only

16. What should technical testing of spreadsheet output content verify?

    • File size
    • Hardware speed
    • User satisfaction
    • Correct figures

17. Which test plan column specifies the target of a given test?

    • Test data
    • Test result
    • What is being tested
    • Actual outcome

18. Why is extreme test data used in a spreadsheet test plan?

    • To check normal values
    • To check range limits
    • To test formatting
    • To find file size

19. What term describes the inputs used to check if a solution behaves correctly?

    • Test data
    • Output data
    • Metadata
    • Source code

20. A new user struggles to find the print button. Which type of testing has identified this?

    • Usability testing
    • Calculation testing
    • Technical testing
    • Extreme data testing

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
• Techniques to generate the outputs Quiz · 2.1.2 · 20 questions
• User interface Quiz · 2.1.3 · 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