Present Data (Edexcel IGCSE ICT)
Revision Note
Author
Robert HamptonExpertise
Computer Science Content Creator
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
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 0 free revision notes
Get unlimited access
to absolutely everything:
- Downloadable PDFs
- Unlimited Revision Notes
- Topic Questions
- Past Papers
- Model Answers
- Videos (Maths and Science)
Did this page help you?