Module 1.2
Task 7 - Formatting Spreadsheet Contents


A.M.D.G.

The spreadsheet toolbar gives you formatting tools, just like in word processing.


  • Open Module 1.2
  • Enter the following information in a new worksheet
 
A
B
C
D
E
1
  Le Restaurant de Paris       
2
  Table 2        
3
 Cappuccino
1.75
      
4
 Croissant 
1.25
      
5
 Espresso
1.50
      
6
 Danish
1.80
      
7
          
8
  TOTAL        
9
  Service Charge Not Included      
  • Enter a formula to calculate the total charge
  • Use each of the formatting tools to produce an attractive bill
  • Save your work

Answer the following questions in your jotter.

1. Describe three types of border.

2. What are the two ways of altering colours in a spreadsheet.

3. List the default font, size, alignment, text colour and background colour in Excel.