Spreadsheet 1 mind map

Spreadsheet 1 mind map

1. Functions

   • =max()
   • =min()
   • =average()
   • =if()
   • =Today()

2. data

   • import
   • export
   • Create a table out of

3. Formatting

   • change colour
   • Change the font
   • Change font size
   • conditional formatting

4. worksheets

   • you can use more than one worksheet

5. Cells

   • worksheet
     • column
     • rows
     • a single page of worksheet is a spreadsheet

6. numbers (IOS)

   • operating systems have there own spreadsheet application
     • Microsoft excel (Windows)

7. Spread sheet software is a application for storing,calculating and displaying data in a organised file called spreadsheets

8. modelling

   • graphing
     • results can be compared visually
   • goal seek
   • so that results can be compared visually/trends indentified
   • you can changer figures to predict results

9. Auto update - allows users to change facts and figures and it will update automatically

10. uses

    • allows for calculations to be made
      • that can e entered by the user
        • using formulas and or functions
    • Data can be stored and muniplulated on this type of software
      • in a suitable format / for future use spread sheet has a set of formats
        • fractions
        • accounting
        • text
        • time / date
        • number
        • currency
        • percentages
        • formatting tools allows these to present data professionally