The Grade 10 students have started the Term off with learning about Microsoft Excel. This is such a powerful programme, as it allows us to preform basic calculations on worksheets using preset functions which can help us work out Personal Budgets etc.

9a07545f-2b7d-410e-a857-03ce2360cf5e ccb38380-90bf-4cb8-9236-3bf69934106c WhatsApp Image 2018-07-25 at 14.49.44 (1) WhatsApp Image 2018-07-25 at 14.49.44

The following functions are a few must knows for Excel:

  • SUM – This is used to calculate the sum of a range of data. The following operators may be used in a sum formula [+,-,/ and *]. The formula may be applied as follows:=SUM(A1:D1) or = SUM(A1+B1)
  • MIN – This formula is used to return the minimum value from a set of data. For example, out of the following set of data (12,23,23,45), 12 would be returned. This formula may be applied as follows:=MIN(A1:D1)
  • MAX – This formula is used to return the maximum value from a set of data. For example, out of the following set of data (12,23,23,45), 45 would be returned. This formula may be applied as follows:=MAX(A1:D1)
  • AVERAGE – This formula will return the average of a set of data. This formula may be applied as follows:=AVERAGE(A1:D1)

The wonderful thing about using these formulas to calculate results, should new data be added (or old data be changed), the SUM, MIN, MAX and AVERAGE would automatically be updated as soon as the information has been.

Comments are closed.