Formulae and Functions in Calc - English

This is a sample video. To access the full content,
please Login

No questions yet

12

Outline:
Formulae and Functions in Calc

Usage of Conditional Operator in Calc
Usage of If.. Or statement in Calc 
Rounding off numbers
Usage of Function Wizard in Calc

Usage of following functions in Calc:

   SUM()
   PRODUCT()
   MIN()
   MAX()
   MEDIAN()
   COUNT()
   COUNTIF()

Width:	928	Height:	696
Duration:	00:16:13	Size:	13.2 MB

Show video info

Pre-requisite

Advanced Formatting and Protection in Calc

Assignment

Code files

Code-File/
Code-File/Personal-Finance-Tracker.ods

Script

Timed Script

Slides

slide/
slide/2-DC-Logo.jpg
slide/Formulae-and-Functions.tex
slide/st-logo.jpg
slide/Formulas-and-Functions.pdf
slide/Syntax.png

Spoken Tutorial, created on or before 31 Jan. 2025, by IIT Bombay is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License, except where stated otherwise
Based on a work at https://spoken-tutorial.org. Permissions beyond the scope of this license may be available at https://spoken-tutorial.org.

Spoken Tutorial, developed at IIT Bombay, is brought to you by EduPyramids Educational Services Private Limited (DBA: EduPyramids Educational Services Pvt Ltd.). EduPyramids Educational Services Private Limited is currently incubated at SINE IIT Bombay. All transactions will be processed under the name EduPyramids Educational Services Private Limited.