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

Unlock more revision notes. It's free!
By signing up you agree to our Terms and Privacy Policy.
Already have an account? Log in
Did this page help you?