Spreadsheets

10 different things that microsoft excel could be used for:

-Maths calculations
-Collecting data
-Graphs
-Shopping list
-Contact list
-Charts
-Counting
 -Calculating data
-Surveys
-Planning

 Describe which different subjects in school you might need to use a spreadsheet for, and what you would use it for in that subject.
1.Maths-Graphs, Counting, Maths calculations, Collecting data, Calculating data, Surveys
2.Science-Planning, Graphs, Collecting data,
3.iTech-Survey
4.English-Planning, Contact list, Shopping list
5.Social Studies-Graphs, Collecting data, Surveys, Planning.

Watch the powerpoint, and explain what each of the following things are on the spreadsheet:
  • Letters at the top -tells you which letter column your on
  • Numbers down the side -tells you which number column your on
  • Cell reference -if u put the letter and the number together e.g. D3
  • Active cell -is a blank cell and it is where you put the total amount.
  • formula -something that you calculate
  • = -all formula must start with
  • + -to add something
  • - -to subtract something
  • * -to multiply something
  • / -to divide something