Module 1.2
Task 1 - Entering Spreadsheet Data


A.M.D.G.

The power of a spreadsheet program is its ability to store vast amounts of numbers and to perform calculations upon these numbers. In this task you will create your first spreadsheet document by entering values and your first formula.

  • Start Microsoft Excel
  • Click on cell A1
  • Type the word 'Item'
  • Click on cell B1
  • Type the word 'Price'
  • Below these headings enter the following information
 
A
B
C
D
E
1
 Item Price      
2
 Coke
50
      
3
 Crisps
30
      
4
 Mars Bar
35
      
5
 Polos
25
      
6
 TOTAL        
  • Notice that the text in Column A are left aligned (remember this from Task 3?).
  • In cell B6 enter the formula =B2+B3+B4+B5
  • Save this file as Module 1.2

Answer the following questions in your jotter.

1. Describe two ways of moving from one cell to another.

2. When text is entered in a cell, what is the default alignment?

3. When values are entered in a cell, what is the default alignment?

4. How can the formula in cell B6 be entered quickly using the mouse?