Spreadsheets (formulas, charts, modelling)

Think of a spreadsheet like a giant, super-smart grid of boxes, called cells, on your computer screen. Each cell is like a tiny container where you can put numbers, words, or even special instructions.

• Formulas: These are like secret commands you type into a cell to tell the spreadsheet to do a calculation. For example, you could tell it to add two numbers together, find the average of a list, or even check if a number is bigger than another. It's like having a super-fast calculator built right into your grid!
• Charts (or Graphs): Imagine you have a long list of numbers, like how many ice creams were sold each day. Charts take these numbers and turn them into colourful pictures, like bar graphs or pie charts. This makes it super easy to see patterns, compare things, and understand the data much faster than just looking at rows and rows of numbers. It's like turning a boring book into an exciting comic strip!
• Modelling: This is like playing a 'what if' game with your numbers. You can change one number in your spreadsheet and immediately see how it affects all the other calculations and even your charts. For example, 'What if we sold 100 more ice creams? How much more money would we make?' Spreadsheets help you predict outcomes without actually having to do it in real life first.

Let's imagine you're running a small lemonade stand. You sell lemonade for $1 a cup, and it costs you 30 cents to make each cup.

1. Setting up the spreadsheet: You'd open your spreadsheet and label some columns like 'Cups Sold', 'Income (Money In)', 'Cost (Money Out)', and 'Profit (Money Left Over)'.
2. Using Formulas: If you sold 50 cups, you'd type '50' into the 'Cups Sold' cell. Then, in the 'Income' cell, you'd type a formula like =A2*1 (meaning, 'take the number in cell A2 and multiply it by 1'). In the 'Cost' cell, you'd type =A2*0.30. Finally, for 'Profit', you'd type =B2-C2 (meaning, 'take Income and subtract Cost'). The spreadsheet instantly calculates your income, cost, and profit!
3. Creating a Chart: You could then select your 'Cups Sold' and 'Profit' numbers and tell the spreadsheet to make a line chart. This chart would visually show you how your profit goes up as you sell more cups, making it super clear to understand.
4. Modelling ('What If'): Now for the fun part! What if you wanted to see what happens if you sell 70 cups instead of 50? You just change the '50' to '70' in the 'Cups Sold' cell, and instantly all your income, cost, profit, and even your chart update automatically! You don't have to do any calculations yourself. This helps you plan for the future without actually having to sell any more lemonade yet.

Here's how you generally use these cool features:

1. Enter Data: Type your numbers and text into the individual cells (the little boxes) of the spreadsheet grid.
2. Write Formulas: Start a formula with an equals sign (=), then use cell references (like A1 or B5) and mathematical operators (+, -, *, /) or functions (pre-built calculations like SUM or AVERAGE).
3. Copy Formulas: Once you have a formula, you can often drag a small square at the corner of the cell (the fill handle) to quickly copy it to other cells, automatically adjusting the cell references.
4. Select Data for Charts: Highlight the cells that contain the numbers and labels you want to turn into a picture.
5. Insert Chart: Go to the 'Insert' menu and choose the type of chart you want (e.g., Bar, Line, Pie). The spreadsheet will draw it for you.
6. Change Inputs for Modelling: To 'model' or play 'what if', simply change the original numbers that your formulas and charts depend on. Watch everything update automatically!*

Formulas are like instructions, and functions are like pre-written, super-smart instructions that do common tasks for you. Imagine you want to add up a whole column of numbers. Instead of typing A1+A2+A3+..., you can use a function!

• Basic Arithmetic: These are your everyday math operations.
  • =A1+B1 (Adds the numbers in cell A1 and B1)
  • =C3-D3 (Subtracts the number in D3 from C3)
  • =E4*F4 (Multiplies the numbers in E4 and F4)
  • =G5/H5 (Divides the number in G5 by H5)
• SUM Function: This adds up a range of numbers.
  • =SUM(A1:A10) (Adds all numbers from cell A1 down to A10).
• AVERAGE Function: This calculates the average of a range of numbers.
  • =AVERAGE(B1:B20) (Adds up all numbers from B1 to B20, then divides by how many numbers there are).
• MAX/MIN Functions: These find the largest or smallest number in a range.
  • =MAX(C1:C50) (Finds the biggest number in cells C1 to C50).
  • =MIN(D1:D50) (Finds the smallest number in cells D1 to D50).
• COUNT Function: This counts how many cells in a range contain numbers.
  • =COUNT(E1:E100) (Counts how many cells from E1 to E100 have numbers in them).*

These functions save you tons of time and help avoid mistakes!

Even spreadsheet wizards make mistakes sometimes! Here are some common ones and how to fix them:

• Mistake 1: Forgetting the Equals Sign
  • Why it happens: You type A1+B1 into a cell, expecting it to add, but it just shows A1+B1 as text.
  • How to avoid: ❌ A1+B1 ✅ =A1+B1. Always start your formulas with an equals sign (=) to tell the spreadsheet it's a calculation, not just text.
• Mistake 2: Incorrect Cell References
  • Why it happens: You mean to refer to cell B2 but accidentally type B3, leading to wrong answers.
  • How to avoid: ❌ =A1*C4 (when you meant C2) ✅ =A1*C2. Double-check your cell references carefully. When you click on cells to build your formula, the spreadsheet often highlights them, which helps a lot.
• Mistake 3: Choosing the Wrong Chart Type
  • Why it happens: You use a pie chart to show changes over time, which is confusing, instead of a line chart.
  • How to avoid: ❌ Using a pie chart for 'sales over 12 months' ✅ Using a line chart for 'sales over 12 months'. Think about what you want to show: Pie charts are for parts of a whole (like percentages of a budget). Bar charts are for comparing different items (like sales of different products). Line charts are great for showing trends over time (like how temperature changes each hour).
• Mistake 4: Not Understanding Relative vs. Absolute References
  • Why it happens: When you copy a formula, the cell references change automatically (this is relative referencing), which is usually good. But sometimes you want a reference to stay fixed (this is absolute referencing), and you forget to tell the spreadsheet.
  • How to avoid: ❌ Copying =A1*B1 down a column when B1 should always be the same tax rate. ✅ Use $ signs for absolute references: =A1*$B$1. The $ locks the row, the column, or both, so they don't change when you copy the formula.