Lesson details

Key learning points

  1. In this lesson, we will be taught that objects can be described using data. We will build a data set (a collection of related data that can be manipulated using a computer) within a spreadsheet application and apply appropriate number formats to cells.

Licence

This content is made available by Oak National Academy Limited and its partners and licensed under Oak’s terms & conditions (Collection 1), except where otherwise stated.

Loading...

4 Questions

Q1.
What are the headings in this spreadsheet?
Correct answer: All of above
Cost
Fruit
Number Sold
Subtotal
Q2.
How much do apples cost?
£2.40
4
Correct answer: 40p
Q3.
What is the third data heading in the table?
Fruit
Correct answer: Number sold
Sub-total
Q4.
What is the most expensive fruit on the spreadsheet?
Apples
Bananas
Correct answer: Grapefruit
Kiwi

4 Questions

Q1.
Which format is best for the data held in a column with the data heading Discount?
Date
Correct answer: Percent
Time
Q2.
Which format is best for the data held in a column with the data heading Number of items sold?
Currency
Date
Correct answer: Number
Q3.
Which of these would make suitable column headings in a spreadsheet for a local supermarket? (Tick all that apply)
£3.20
Apples
Correct answer: Cost
Correct answer: Item
Q4.
Which number format has been applied to this piece of data? 12:05:00
Currency
Date
Correct answer: Duration
Italics

Lesson appears in

UnitComputing / Spreadsheets

Computing