Spreadsheet Revision

Spreadsheet Revision

1. Goal Seek

2. Charts

   • Pie Charts
   • Bar Charts

3. Function

   • Min
   • Max
   • Average
   • Mround
   • Sum
   • If
   • Today

4. Conditional Formatting

5. Page Tabs

   • Rename

6. Common Terms

   • Cells
   • Column
     • Letters
   • Rows
     • Numbers
   • Labels

7. A Spradsheet Software is an application for Storing, Calculating and Displaying Data

8. Data

   • Sorting
     • Means to arrange data in order
       • Ascending going up in value
       • Descending going down in value
   • export
   • Import

9. Formulas and Functions

   • Formulas
     • They always start with equals = signs
     • It is like a small computer program which gives instructions to the spreadsheet to carry out a mathematical task

10. Page Layout