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
![An Excel spreadsheet listing subjects, number of candidates and pass rates for the years 2021 and 2022, along with totals, arranged in a table format.](https://cdn.savemyexams.com/cdn-cgi/image/f=auto,width=3840/https://cdn.savemyexams.com/uploads/2024/06/15018_adjustdisplayfeatures-ezgif-com-optiwebp.webp)
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.)
![Spreadsheet showing various school subjects, candidate numbers, and pass rates for years 2021, 2022, and 2023. Columns include subjects, candidate numbers, and pass rates.](https://cdn.savemyexams.com/cdn-cgi/image/f=auto,width=3840/https://cdn.savemyexams.com/uploads/2024/06/21715_formataspreadsheetp1-ezgif-com-optiwebp.webp)
Formatting numeric data
Formatting numeric data includes:
Adjusting number of decimal places
Using different currency symbols as appropriate
Dealing with percentages
![Excel spreadsheet budgeting income and expenses. Categories include salary, housing, utilities, groceries, transportation, insurance, phone, entertainment, and savings goals.](https://cdn.savemyexams.com/cdn-cgi/image/f=auto,width=3840/https://cdn.savemyexams.com/uploads/2024/06/28289_formataspreadsheetp2-ezgif-com-video-to-webp-converter.webp)
Using conditional formatting
Conditional formatting means dynamically changing the format of a cell based on it's contents
![Spreadsheet displaying subjects with data on candidates (in thousands) and pass rates (percent) for 2021 to 2023 in English Language, Literature, Mathematics, Sciences, and other subjects.](https://cdn.savemyexams.com/cdn-cgi/image/f=auto,width=3840/https://cdn.savemyexams.com/uploads/2024/06/64044_formataspreadsheetp3-ezgif-com-video-to-webp-converter.webp)
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
![Spreadsheet displaying data on candidates and pass rates for various subjects from 2019 to 2022, including totals at the far-right column. The subjects are listed in rows.](https://cdn.savemyexams.com/cdn-cgi/image/f=auto,width=3840/https://cdn.savemyexams.com/uploads/2024/06/37330_setpagelayoutorientation-ezgif-com-video-to-webp-converter.webp)
Controlling print layout
![Spreadsheet showing data on candidate numbers and pass rates for various subjects between 2020-2022, including totals and averages. Columns highlighted in green.](https://cdn.savemyexams.com/cdn-cgi/image/f=auto,width=3840/https://cdn.savemyexams.com/uploads/2024/06/65329_setpagelayoutpagelayout-ezgif-com-video-to-webp-converter.webp)
You've read 0 of your 5 free revision notes this week
Sign up now. It’s free!
Did this page help you?