Present Data (Edexcel IGCSE ICT): Revision Note

Display Features

What are the display features of a spreadsheet?

• Display features of a spreadsheet include:

  • Displaying either formulas or values

  • Adjusting height and width of rows/columns

  • Wrapping text

Formatting Spreadsheets

How can you format a spreadsheet?

• Formatting a spreadsheet can be split in to three parts:

  • Enhancing the look

  • Formatting numeric data

  • Using conditional formatting

Enhancing the look

• To enhance the look of a spreadsheet it involves changing:

  • Text colour

  • Cell colour

  • Cell emphasis (Bold, italic, underline etc.)

Formatting numeric data

• Formatting numeric data includes:

  • Adjusting number of decimal places

  • Using different currency symbols as appropriate

  • Dealing with percentages

Using conditional formatting

• Conditional formatting means dynamically changing the format of a cell based on it's contents

Page Layout

How can you set the page layout of a spreadsheet?

• Changing the page layout of a spreadsheet includes:

  • Changing orientation (portrait/landscape)

  • Controlling the print layout

Changing orientation

Controlling print layout