202X2 Formulae Xtras (for Spreadsheets)

 |  No Comments

Complete this 1st!

LINKING SHEETSCALENDAR
  1. create a new sheet in your spreadsheet from part 1
  2. copy the sheet below into your new sheet 2
  3. link the missing cells with the instructions from sheet 1 (? marks)
  4. do the calculations again (practise)
5 ? 7 formulae goes here
5 ? 7 formulae goes here
5 ? 7 formulae goes here
5 ? 7 formulae goes here
3 ? 7 ? 2 formulae goes here
15 ? 5 ? 3 formulae goes here
30 ? 50 ? 5 formulae goes here
20 ? 30 ? 2 plus 6 formulae goes here
18 ? 12 ? 6 plus 12 formulae goes here
9 ? 6 ? 3 times 6 formulae goes here

 

  • halved means divided by 2
  • quartered means divided by 4

Dates are numbers, so can be used in calculations

  1. create a title, write in the name of this month, and year
  2. make up 7 column headings, for each day Monday – Sunday
  3. look up the current month calendar
    which day was the first?
    put 1 in under the day that was the first of the month
  4. in the day / cell following, use a formula to increase 1 by 1
  5. repeat the the end of the month
  6. give your table an attractive design
  7. how else could you do this by week rather than by day?