!
Understand what a formula is and how it is used in a spreadsheet
Listening carefully to others views and ideas.
Be able to write formulas
Axis
Chart
Spreadsheet
X and Y labels
1
3
2
4
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.
Adding cells together can be done with the following formula:
= A1 + 4
= A1 + B2
Calculating the total of a range of cells can be done like this:
= SUM(A1 : A10)
= SUM(A1 : B3)
Demo
On your shopping list spreadsheet, add a formula to calculate the total of your list.
The following are key shortcuts for using DragonSlides and reveal.js.
| Key combination | Action |
|---|---|
| →, PAGE DOWN, SPACE | Next slide |
| ←, PAGE UP | Previous slide |
| SHIFT + → | Last Slide |
| SHIFT + ← | First slide |
| B | Whiteboard |
| W | Widget Board/White Screen |
| C | Toggle Notes Canvas |
| DEL | Clears Whiteboard/Notes Canvas |
| S | Show Presenter Mode |
| SHIFT + D | Toggle Dark Mode |
| H | Goes to the Home Slide |
| META + P | Show Print options window |
In order to use the 'Start Remote' feature, you'll need to download JB Slide Controls from the Apple App Store. Once you have this you'll be able to control the slides using the app from you Apple Watch.
DragonSlides and jamiebalfour.scot are copyright © Jamie B Balfour 2017 - 2024, 2010 - 2024. Content is copyright © Jamie B Balfour