Lesson 3 Microsoft excel

AVERAGE function

An Excel function that adds a group of values, and then divides the result by the number of values in the group.

Formula Bar

A command-line above the worksheet that displays and where text, numbers, and formulas are entered into a worksheet.

Arithmetic Operators

The symbols +, -, *, /, %, and ^ used to denote addition, subtraction (or negation), multiplication, division, percentage, and exponentiation in an Excel formula.

Left Function

returns the specified number of characters starting at the left (beginning) of a text string

RIGHT function

returns the specified number of characters starting at the right (end) of a text string

Textjoin

A Text function used to combine the text values of cells including defining the delimiter character to use between cell values.

Function

A computational procedure that performs a specific operation.

AutoSum

A feature that automatically performs a calculation, like addition, used on a group of numbers.

LOWER function

A function that converts all uppercase letters to lowercase

UPPER function

A function that converts text to uppercase letters

Count Blank

A function that counts the number of blank cells in a range.

TODAY function

A function that returns the current date in a worksheet.

NOW function

A function that returns today's date and the current time, in the default format of mm/dd/yyyy hh:mm.

SUM function

Adds all the numbers in a range of cells

Formula

An equation that calculates a new value from values currently in a worksheet.

Count

Counts the number of cells in a range that contain numbers, no blank cells

Concat

Joins two or more strings, and returns a copy of the joined strings

Count A

Returns the number of cells in a range that contains a number or text.

Len

Returns the number of characters in a text string

MID Function

The MID() function is used to extract characters from a text field. SELECT MID(column_name,start,length) AS some_name FROM table_name;

Function Arguments

The cell references and values placed in parentheses and on which a function acts to perform a calculation.

AutoSum

a function that automatically adds the values in the cells directly above or to the left of the active cell

PROPER function

capitalizes the first letter of a word in a column example: =PROPER(A1)

MEDIAN function

identifies the midpoint value in a set of values