Function that count the number of cell that fits with the criteria within the range

Function that counts the number of cell containing a number within a range

Function that joins x and y

Function that removes extra spaces in x

Function that returns the absolute value of x

Function that returns the average of x and y

Function that returns the characters of x specified by y (from the left)

Function that returns the characters of x specified by y (from the right)

Function that returns the column number of x

Function that returns the current date

Function that returns the current date and time

Function that returns the difference of x subtracted by y

Function that returns the largest number between x and y

Function that returns the largest number within the range

Function that returns the length of characters in x

Function that returns the product of x and y

Function that returns the product of x and y

Function that returns the proper casing of x

Function that returns the quotient of x divided by y

Function that returns the quotient of x divided by y

Function that returns the row number of x

Function that returns the smallest number between x and y

Function that returns the smallest number within the range

Function that returns the square root of x

Function that returns the sum of x and y

Function that returns the sum of x and y or (all the numbers within the range)

Function that returns the value of pi

Function that returns the value of x raised to the power of y

Function that returns true if x is a number

Function that returns true if x is a text

Function that returns true if x is an even number

Function that returns true if x is an odd number

Function that returns x if the condition is true, else it returns y

Function that returns x in all capital form

Function that returns x in non- capital form

Function that rounds x to a specified number of digits (y)

It allows users to organize data in rows and columns and perform calculations on the data

It is a highly innovative and versatile program that can ensure a successful communication whether you’re presenting in front of potential investors, a lecture theatre or simply in front of your colleagues.

It is an expression which calculates the value of a cell.

It is the bar that displays the contents of a cell

It is the box at the top of each column containing a letter

It is the cell address of the cell usually combine letter and number (ex. A1, B4, C2)

It is the combining or joining two or more cells

It is the horizontal line of entries in a table.

It is the place where information is held in a spreadsheet

It is the row number

It is the selected cell.

It is the vertical line of entries in a table.

These are predefined formulas and are already available in Excel

To present information and ideas in an interactive and interesting way