GCD returns the greatest common divisor of two or more integers. The greatest common divisor is the largest integer that divides both number1 and number2 without a remainder.
LCM function returns the least common multiple of integers. The least common multiple is the smallest positive integer that is a multiple of all integer arguments.
You can change the text case in excel with easy steps.
PROPER - Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts
...
The COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments. Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. Syntax
...
The SUM function is useful when you want to add or subtract values from different ranges or combine number values with ranges of numbers.
Format: Sum(Range, Range)
Each argument can be a range, a cell reference, or a positive or negative
...