Spreadsheet Formatting
Enhance a spreadsheet using various formatting tools.
- Text colour, cell colour, bold, underline, italic, shading
- These features make your spreadsheet visually appealing and easier to read
Format numeric data appropriately.
- Display the number of decimal places, different currency symbols, percentages
- Proper formatting ensures accurate representation and interpretation of data
Use conditional formatting to change the display format depending on the contents of a cell.
- This helps to highlight important information or identify patterns and trends in the data
Worked example
Explain the steps that need to be taken to display cell H4 as US dollars.
[2]
2 of:
Highlight/select cell H4 [1]
Select format cells [1]
Select currency/accounting [1]
Select dollar/USD icon [1]