Databases

Databases

1. general knowlegde

   • Databases are made up of columns and rows
   • we use databases to sort of data in a way that is visually pleasent
   • functions can be used to work out equations in a quick way

2. functions

   • singular cell functions
     • =C3 + D3 (add)
     • =C3 - D3 (subtract)
     • =C3 * D3 (multiply)
     • =C3 / D3 (division)
   • multi cell functions
     • =SUM(C3:F3)
       • This is for addition
     • =AVERAGE(C3:F3)
       • To find the average
     • =MAX(C3:F3)
       • To find the highest value
     • =MIN(C3:F3)
       • To find the lowest value

3. Conditional formatting

   • highlight the cells that you want to do this to
     • Go to the home tab, then styles and then pick conditional formatting
       • Find the cell rules option
         • click the option that says find more rules
           • then edit according to the instructions

4. IF statment

   • click on the cell
   • then hit the fx button at the top
   • find the option that says IF and click okay
   • fill out the rest according to the instructions