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

You've read 0 of your 5 free revision notes this week
Sign up now. It’s free!
Did this page help you?