Lesson 1.2.2
1.2.2 Types of outputs that clearly present information for an organisation Quiz: OCR IT, Unit 2
20 questions
In partnership with Revision Ninja
Lesson 1.2.2, Types of outputs that clearly present information for an organisation: 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 output shows trends in data most clearly as a visual image?
- Invoice
- Chart
- Worksheet
- List
-
Which output presents records one below another for easy scanning?
- Report
- Invoice
- List
- Chart
-
Which output would a shop send to a customer to request payment?
- Chart
- Invoice
- Stock list
- Worksheet
-
Which output summarises information for a client, drawing data from several sources?
- Report
- Data list
- Invoice
- Worksheet
-
Which output type is best suited for notifying a customer of a dispatched order?
- Spreadsheet
- Delivery note
- Dashboard
- Payslip
-
Which spreadsheet output is best for a quick visual comparison of sales regions?
- Invoice
- Chart
- List
- Worksheet
-
Which page layout property sets whether a page prints tall or wide?
- Guidelines
- Print area
- Orientation
- Scaling
-
What action does setting a print area perform in a spreadsheet?
- Changes font size
- Locks the workbook
- Deletes hidden rows
- Restricts printed cells
-
A worksheet is slightly too wide to print on one page. Which property helps?
- Guidelines
- Cell comments
- Footers
- Scaling
-
What item is typically placed in the footer of a printed report?
- Company logo
- Page numbers
- Main chart title
- Primary formula
-
Which element forms part of an organisation house style for an invoice?
- Raw data dump
- Company logo
- Random font size
- Unstyled table
-
Which cell formatting option is used to show money values?
- Date
- Currency
- Boolean
- Percentage
-
Why should a chart include a clear title and labelled axes?
- Speeds up sorting
- Shows units
- Saves paper space
- Locks cell values
-
What does a fit for purpose spreadsheet output mean?
- Uses maximum RAM
- Prints in portrait
- Contains no macros
- Meets user needs
-
What is the primary purpose of a report output in an organisation?
- Test macro code
- Enter daily data
- Present information
- Store raw formulas
-
Why might a designer choose a worksheet output instead of a report?
- To display final results
- For client presentations
- For data calculations
- To print official invoices
-
Which page layout property sets the paper size, such as A4?
- Print area
- Page size
- Guidelines
- Scaling
-
What is the main purpose of page guidelines in output design?
- Align elements
- Format formulas
- Calculate totals
- Encrypt data
-
Which is a valid reason to place a company logo on an invoice?
- Sorts line items
- Validates passwords
- Calculates tax
- Supports branding
-
What output format is typically used by HR to detail monthly staff earnings and deductions?
- Payslip
- Invoice
- Receipt
- Catalog
Related quizzes
- Design tools Quiz · 1.1 · 20 questions
- Functionality Quiz · 1.2.1 · 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