Cbse, class, 7, It computer, Ch: 2 Functions and Charts in Calc

Cbse, class, 7, It computer, Ch: 2 Functions and Charts in Calc

Mathematical Functions:

·         ROUND() : This function rounds a number to the specified number of digits

Syntax: =ROUND(number; count)

 

·         LCM():This function finds the least common multiple of given numbers. Syntax: =LCM(Integer1;Interger 2;.......)

 

·         GCD() : This function finds the greatest common divisor of given numbers. Syntax: =GCD(Integer1;Interger 2;.......)

Text Functions

·         UPPER() : This function converts text to uppercase letters.

Syntax: =UPPER (text)

·         LOWER(): This function converts text to lowercase letters.

Syntax: =LOWER(text)

·         LEN() :This function finds the number of characters in text.

 Syntax: =LEN(text)

Date & Time functions

·         Date() This function displays the entered day, month and year in the mm/dd/yy date format.

Syntax: =DATE (year;month;day)

·         Time() This function converts the entered hours, minutes and seconds in 24-hour format

Syntax: =TIME(hour;minute;second)

·         Today() This function displays the current date.

Syntax: =TODAY ( ) returns the current system date in the mm/dd/yyyy format.

Logical functions :

 Logical functions are used to carry out comparison in your formulas or test multiple conditions. They return either True or False.

Syntax: =IF (logical_test, value_if_true, value_if_false)