20.3

Topic 20

Present data

  • IGCSE I.C.T 0417
  • 1 min read
  • Syllabus 2026, 2027 and 2028

Objectives

  1. 1

    Adjust the display features

    • aDisplay either formulae or values
    • bAdjust row height, column width and cell sizes so that all data, labels, and formulae is fully visible
    • cWrap text within cells so that all data is fully visible
    • dHide and display rows and columns
  2. 2

    Format a spreadsheet

    • aEnhance a spreadsheet including text colour, cell colour, bold, underline, italic, shading
    • bFormat numeric data appropriately including to display the number of decimal places, different currency symbols, percentages
    • cUse conditional formatting to change the display format depending on the contents of a cell
  3. 3

    Set page layout

    • aSet the orientation to portrait or landscape
    • bControl the page layout to print including specified number of pages, print area, display or hide gridlines, display or hide row and column headings

Cambridge IGCSE ICT 0417 syllabus 2026-2028, 20.3 Present data (copied for internal use as permitted by Cambridge)

Detailed · Deep study

1Display features and formatting

FeatureNotes
formulae or values viewshow the formulae (e.g. for evidence) or the results
row height / column widthadjust so that all data, labels and formulae are fully visible (no ##### or cut-off text)
wrap textlong text continues on a new line inside the cell
hide/display rows and columnshide working columns without deleting them
enhancementstext colour, cell colour, bold, underline, italic, shading
number formatsnumber of decimal places, currency symbols (e.g. $, €, KSh), percentages
conditional formattingchanges the format of a cell depending on its contents, e.g. red fill if a value is below 50

2Page layout

  • Set the orientation to portrait or landscape.
  • Fit the printout to a specified number of pages (e.g. 1 page wide).
  • Set a print area to print only part of the sheet.
  • Display or hide gridlines and row and column headings on the printout.

3Exam focus

Key words: formulae view; column width; wrap text; hide; conditional formatting; print area; gridlines; row and column headings.

Quick self-check

Answer in your head first, then reveal.

  1. Changes the format of a cell (1) depending on its value/contents (1).

  2. Any two: formulae view; widen columns; fit to one page; landscape; show row/column headings (2).

Finished this subtopic? Track it on your subject page.