4. Formatting Text and Numbers

The formatting features of a spreadsheet allow different fonts, sizes, styles, colour's etc. to be applied to the cells in a spreadsheet.

What you have to do!

Formatting Text and Numbers! Click to Go Larger Screen

1. Download the file Shop prices.xls.
   
   
   
   
2. Watch Movie 4 and using the methods shown:
   1. Change cells to display pound signs where required.
   2. Make VAT value a percentage displayed to one decimal place.
   3. Format the cells A1 to C1 with white text and a black background
3. Save your file.

Mark off Exercise 6 in your Progress Grids

What you should now be able to do!

• Use the formatting features to change the size, style, font and colour of text.

• Use the formatting features to change the format of numbers in the spreadsheet including currency and percent.

• Explain why its useful to use the formatting features in spreadsheets to make it easier to read.

Continue to Section 5: Sorting Data