ÌÇÐÄVlog

Please consent to cookies to view content.

' ); iframeDoc.close(); } } } } } const observer = new MutationObserver(switchSrc); observer.observe(document.documentElement, { childList: true, subtree: true, }); })();

ÌÇÐÄVlog

Last updated

3 November 2026

docx, 203.44 KB
docx, 203.44 KB
pptx, 4.46 MB
pptx, 4.46 MB

R060 Formatting Data – Lesson Slides (OCR Cambridge Nationals IT J836)

These ready-to-teach slides show learners how to choose the right format for different types of data in a spreadsheet. A key point throughout is that formatting changes how data looks but not the value stored. They also cover how the right format improves usability and helps the spreadsheet process data correctly.

The slides cover:

What formatting data means and why it matters for the user interface (HCI)
Finding the format options on the Home tab
Number: general values such as quantities and scores, and changing decimal places
Currency: displaying the £ symbol with two decimal places
Percentage: entering values as decimals (0.25 shows as 25%)
Date: entering dates as DD/MM/YYYY and changing how they’re displayed
Text: keeping leading zeros and spaces, using a phone number as a worked example
Common pitfalls, such as Text format stopping a formula from calculating

The slides are fully editable and work well for whole-class teaching, independent work or catch-up lessons.

This resource is not endorsed by OCR.

Reviews

Something went wrong, please try again later.

This resource hasn't been reviewed yet

To ensure quality for our reviews, only customers who have purchased this resource can review it

to let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.