Slides badge

Formulas

Learning Intentions

  • Understand what a formula is and how it is used in a spreadsheet

Success Criteria

  • Listening carefully to others views and ideas.

  • Be able to write formulas

Starter task - describe each word

Axis

Chart

Spreadsheet

X and Y labels

1

3

2

4

Activity 1 - load your spreadsheet

  • Open Microsoft Excel on your computer.
  • Reopen your shopping list spreadsheet from the last lesson.

Formulas

  • A formula in a spreadsheet is a mathematical or logical expression that performs calculations, manipulates data, or makes decisions based on the values present in the cells of the spreadsheet. 

  • Formulas are used to automate calculations and perform various tasks efficiently.

  • In Microsoft Excel and Google Sheets, they begin with an equal sign (=) followed by the expression you want to evaluate.

Examples - adding two numbers

  • Adding cells together can be done with the following formula:

 

= A1 + 4

= A1 + B2

Examples - calculating the total

  • Calculating the total of a range of cells can be done like this:

 

= SUM(A1 : A10)

= SUM(A1 : B3)

Demo

Activity 2 - ADD A TOTAL

On your shopping list spreadsheet, add a formula to calculate the total of your list.

Presentation Overview
Close
JB
Formulas
© 2020 - 2024 J Balfour
17:25 | 23-05-2024
Join Live Session
Start Remote
Save Progress
Slideshow Outline
Presenter Mode
Widget Screen
Canvas Controls
Random Selector
Timer
Volume Meter
Binary Converter
Python Editor
Show Knox 90
Provide Feedback
Help
!
Keywords
    DragonDocs Management
    Random selector
    Sections
      Binary conversion
      Denary to binary conversion
      Binary to denary conversion
      Feedback 👍
      Accessibility

      Apply a filter:

      ×
      All slideshow files