This episode looks at the creating and using formulas in spreadsheets.
Hosted by Ahuka on 2014-04-25 is flagged as Clean and is released under a CC-BY-SA license.
Tags: LibreOffice, Calc, Spreadsheet, formulas.
Listen in ogg,
mp3 format. | Comments (1)
In this in-depth series on LibreOffice we examine Writer, Calc and Impress
Since the main purpose of a spreadsheet is to perform calculations it is appropriate that we consider just how this is done.
In general, a cell of a spreadsheet can contain one of three things:
All calculations are done using formulas. A formula occurs whenever a cell has contents that begin with an equals sign, which is the signal to Calc that it needs to perform a calculation. For instance, if a cell contains "A3+B3", Calc would examine this, see the letters and the plus sign, and decide that the contents of the cell were a text string. After all, it cannot be a pure number with those other things there. But place an equals sign in front, so that the contents now read "=A3+B3" and Calc knows that this is formula, and will perform the calculation. And one of the best ways to interact with a cell that contains a formula is to use the Formula Bar, which normally appears just above the cells of the spreadsheet proper:
For the remainder of the show notes please read: http://www.ahuka.com/?page_id=723
Comment #1 posted on 2014-04-25T19:18:03Z by anon
This guy sounds like a teacher. He should produce online video courses.
<< First, < Previous, Next >, Latest >>
Note to Verbose Commenters
If you can't fit everything you want to say in the comment below then you really should record a response show instead.
Note to Spammers
All comments are moderated. All links are checked by humans. We strip out all html. Feel free to record a show about yourself, or your industry, or any other topic we may find interesting. We also check shows for spam :).