Learning objective
Present data effectively. Students should be capable of: Adjusting display features to show either formulas or values, modifying row heights, column widths, and cell sizes to ensure all data, labels, and formulas are visible, wrapping text within cells for full visibility, hiding and displaying rows and columns, enhancing spreadsheet appearance through text color, cell color, bold, underline, italic, and shading, formatting numeric data correctly to show the desired number of decimal places, various currency symbols, and percentages, using conditional formatting to alter display based on cell content, and setting page layout by choosing portrait or landscape orientation, managing print layout including specifying the number of pages, print area, and whether to display or hide gridlines and row and column headings.
Read the explanation, check the common trap, then practise with flashcards and questions.
Exam focus
- Read the explanation.
- Check key terms.
- Practise with linked questions.
Cambridge IGCSE Information and Communication TechnologySpreadsheets