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.

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.