Spreadsheets

Spreadsheets

1. Functions

   • Text Extraction
     • =LEFT(Cell,number of characters)
     • =RIGHT(Cell,number of characters)
     • =MID(Text,start_num,number of characters)
     • =MAX(Cell(s))
     • =MIN(Cell(s))
   • Others
     • =CONCATENATE(Cell(s))
     • =SUM(Cell(s))
       • What does it do
     • =AVERAGE(Cell(s))
       • What does it do
         • Finds the average of numbers

2. Formula

   • Multiply
     • Cell A * Cell B
   • Divide
     • Cell A / Cell B
   • Subtract
     • Cell A - Cell B
   • Add
     • Cell A + Cell B

3. Specialised Functions

   • =VLOOKUP
   • =HLOOKUP