Page 67 - TechPluse_C6_Flipbook
P. 67
AVERAGE(range) It gives the average of the given Input: =AVERAGE(16,21,18,7,13)
numbers in a range. Output: 15
COUNT(Number1, It returns the count of the number of Input: =COUNT(6,4,8,9,7)
Number 2, …) OR given values or values in the given Output: 5
COUNT(range)
range of cells.
Date Functions
Functions Purpose Example
DATE(YEAR, MONTH, DAY) It returns the date in DD/MM/ Input: =DATE(2019,13,12)
YY format. Output: 13/12/19
TODAY() It returns the current date of Input: =TODAY()
the computer. Output: 7/23/2020
MONTH(TODAY()) It returns the current month. Input: =MONTH(TODAY())
Output: 7
YEAR(TODAY()) It returns the current year. Input: =YEAR(TODAY())
Output: 2020
DAY(TODAY()) It returns the current day. Input: =DAY(TODAY())
Output: 23
Clickipedia
The common functions like SUM, AVERAGE, MAX, MIN and COUNT
can be used by using the down arrow of the Select Function
button on the Formula Bar.
To use other functions, click on Insert → Function option.
Select Function button
Tech
Funda
To open Insert Function dialog box: Ctrl +F2
Formulas, Functions and Charts in Calc 65

