Module 1.2
Task 3 - Currency


A.M.D.G.

You can change the way that numbers are displayed in spreadsheet cells.

When entering amounts of money, type only the number and then press the currency button on the toolbar, .


  • Open Module 1.2 Task 1
  • Enter the following information on a new worksheet

 
A
B
C
D
E
1
  I started with
 50
      
2
 I bought a CD at 
11.99 
      
3
 My gran gave me
25.99 
      
4
 I bought jeans at 
20 
      
5
 I gave my brother 
15 
      
6
 In the lottery I won 
10 
      
7
 I now have         
  • Use the currency tool to make all numbers look like amounts of money
  • By adding and subtracting the values, enter a formula to calculate how much money he has now
  • Save this spreadsheet

Answer the following questions in your jotter.

1. Open up microsoft excel. type in the following values and convert them to currency. Write down what you get for each one:

(a) 1

(b) 0.1

(c) 0.11

(d) 1.001

(e) 11.111

2. Copy and complete the following table:

Tool
Name
Description