Be able to display either formulae or values

20 Spreadsheets: Displaying Formulae or Values 📊

What is a Spreadsheet?

A spreadsheet is like a digital notebook with rows and columns. Each cell can hold a number, text, or a formula that calculates something automatically. Think of it as a calculator that remembers everything you’ve typed.

Formulae vs. Values 🔢

  • Formula: A rule that tells the spreadsheet how to calculate a result, e.g., =A1+B1 or =SUM(C1:C10).
  • Value: The actual number or text that appears in a cell after the formula has been evaluated, e.g., 15.

How to Show Formulae in a Cell

  1. Click the cell you want to edit.
  2. Type an apostrophe (') before the equal sign: '=A1+B1.
  3. Press Enter. The cell will display the formula text instead of the result.

This is handy when you want to show students how the calculation works.

How to Show Values in a Cell

  1. Enter the formula normally, e.g., =A1+B1.
  2. Press Enter. The cell will show the calculated value.
  3. If you later want to see the formula again, click the cell and look at the formula bar at the top.

Practical Example: Calculating a Total Score

Suppose you have exam scores in cells A2 to A5. To find the total:

Cell Content
A2 88
A3 92
A4 75
A5 85
A6 =SUM(A2:A5)

The cell A6 will display the total 340 after calculation. If you want to show the formula instead, type '=SUM(A2:A5).

Quick Reference Table of Common Functions

Function What It Does Example
SUM Adds a range of numbers. =SUM(B1:B10)
AVERAGE Calculates the mean. =AVERAGE(C1:C5)
IF Tests a condition and returns one value if true, another if false. =IF(D1>90,"A","B")
VLOOKUP Looks up a value in a table and returns a related value. =VLOOKUP(E1,Sheet2!A1:B10,2,FALSE)

Tips for Students

  • Always start a formula with an equal sign (=).
  • Use the formula bar to see or edit the formula behind a value.
  • Press F2 to edit a cell in place.
  • Use Ctrl + ` (backtick) to toggle between showing formulas and values for the whole sheet.

Remember: the beauty of spreadsheets is that they can do the heavy lifting for you, but you must decide whether to see the recipe (formula) or the final dish (value). Happy calculating! 🚀

Revision

Log in to practice.

3 views 0 suggestions