Data Science and Analytics

It includes two or more references. It is separated by a comma.

• formula

• function

• union

• range

Count cells containing any type of information including error values.

• count

• countblank

• counta

• countif

Convert text to capital letters.

• Upper

• Lower

• Trim

• Mid

Returns the highest value found within the range?

• Sum

• Count

• Max

• Min

Adds values within the range of cells.

• Sum

• Count

• Max

• Min

Here you can reference the cell when you perform mathematical calculations such as addition, subtraction, multiplication, or division..

• formula

• function

• union

• range

Counts cells of a given range based on one or multiple condition (criteria).

• sumif

• sumifs

• countif

• countifs

Refers to all the cells between and including the reference. It is separated by a colon.

• formula

• function

• union

• range

Here you can quickly and easily make many useful calculations, such as finding an average, the highest number, the lowest number, and a count of the number of items in a list.

• formula

• function

• union

• range

Use to normalize all spacing.

• Upper

• Lower

• Trim

• Mid