spreadsheets

spreadsheets

1. spreadsheets are used to perform calculations using a computer

   • Data is the text or numbers you type in
   • labels are headings explaining the data
   • Formulas are automatic calculations

2. formatting techniques that can improve a spreadsheet

   • coloured borders, or lines, can be added to the edge of each cell
   • Cells can be formatted according to their data type, e.g. cells with money can automatically have a pound sign placed at the front by assigning a currency data type.
   • Cells can be merged or combined together, e.g. cells A1:C1 can merge to form one big cell of A1
   • The font can be changed, e.g. font style, colour, bold or italics