Spreadsheets

1) Make a list of 10 different things that a spreadsheet like Microsoft excel could be used for.

  1. Track your bank account transactions.
  2. Create an Invoice or any kind of form.
  3. Determine profit and loss for a small business.
  4. Track trends of stock prices.
  5. Develop a business balance sheet.
  6. Track expenses for a rental unit.
  7. Track personnel information and sort or filter by birth month.
  8. Create a decision matrix to evaluate various options and help determine best course of action.
  9. Develop a complex schedule matrix to determine who works when.
  10. Estimate number of personnel required, hours required, and total cost of a project.

2) Describe which different subjects in school you might need to use a spreadsheet for, and what you would use it for in that subject.

  • maths to make graph and culacations
  • science to record results
  • computer to do stuff on
  • social studies to make graphs and stuff
3)
  • Letters at the top are columns
  • Numbers down the side are the rows
  • Cell reference the column followed by the row
  • Active cell is the cell that is selected
  • formula is what you want it to do IE: hit enter and it will calculate the vale of profits form that week
  • = all formulas must sart with a =
  • + to add the numbers use this
  • - to subtract the numbers use this
  • * to times the numbers use this
  • / to didvide the numbers use this