Page 26 - Touchpad_Plus_V3.2_Class 7
P. 26
Date Functions
Some of the date functions are given in the table below:
Functions Purpose Example
DATE(YEAR, MONTH, DAY) It returns the date in DD/MM/ Input: =DATE(2024,23,7)
YY format. Output: 23/7/2024
TODAY() It returns the current date of Input: =TODAY()
the computer. Output: 7/23/2024
MONTH(TODAY()) It returns the current month. Input: =MONTH(TODAY())
Output: 7
YEAR(TODAY()) It returns the current year. Input: =YEAR(TODAY())
Output: 2024
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 functions from the properties pane.
To use other functions, click on Insert → Function option.
Select Function button
Tech Funda
To open Insert Function dialog box: Ctrl +F2
CHARTS IN CALC
A chart is an effective way to display data in a pictorial form. It makes it easier to draw comparison
and analyse the growth, relationship and trends among the values in a table.
Components of a Chart
A char has the following components:
Chart Title: Chart title describes the main aim and content of the chart, which represents
your chart.
X-axis: X-axis is the horizontal axis of the chart. It is also called the category axis.
24 Plus (Ver. 3.2)-VII

