Spreadsheet Revision

Spreadsheet Revision

1. Insert Row

   • Click on certain row,click insert tab then click on row

2. Filtering

   • Click a column, press filter,Select desired data
   • To show only a certain type of data and hide the rest

3. Sum - Addition

   • =A6+C7

4. MAX- Highest value

   • =Max(E3:E12)

5. MIN - Lowest Value

   • =Min(F3:F12)

6. Minus - Subtraction

   • =G9-H2

7. Column Chart

   • Highlight data necessary, go to insert tab, click column, choose desired chart, need to add a title afterwards

8. Change colour of column