Spread Sheets

Spread Sheets

1. Features

   • Perform calculations & recalculations automatically
     • Allow results to be displayed in a table or graph
       • Consists of a table split into rows and tables to produce cells
         • Each cell has a column reference (letter) and a row reference (number)
           • Active cell is highlighted
           • contents of the active cell is displayed in data entry bar
     • Consists of a number of worksheets

2. You can format data into a specific category

   • Able to specify different aspects like font, style and number of decimals this is conditional formatting
     • Can add boarding a shading to cells

3. Data validation- able to control the values input into a cell

   • You can select the input message tab and enter a message to guide the users.

4. Arithmetic functions

   • sum function-