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 2