202R1/2 Simple Maths with Spreadsheets

 |  No Comments

The greatest power of spreadsheets is that they can be programmed (the formula) to do the maths as you update the data

The most basic calculations are:

  • add +
  • subtract (minus) –
  • multiply *
  • divide /
VIDEOPOINT & CLICKDOWNLOADS

https://www.youtube.com/watch?v=xc14gFFyiTw

  • under 4 min
  • Mathematical operators
  • Understanding cell references
  • Creating formulas
  • Copying and editing formulas

Another example of Point & Click, rather than typing in cell references

<iframe width=”1536″ height=”609″ src=”https://www.youtube.com/embed/RgvdCHjOKYg?start=0&end=33″ title=”Excel 2010 Tutorial For Beginners #3 – Calculation Basics &amp; Formulas (Microsoft Excel)” frameborder=”0″ allow=”accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share” referrerpolicy=”strict-origin-when-cross-origin” allowfullscreen></iframe>

  1. Worksheet
  2. Practice Spreadsheet (simple maths and example)

You need to be logged in to view the rest of the content. Please . Not a Member? Join Us

Share this by:

Share on SMS Share on WhatsApp Share on LinkedIn
Tags: ,