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
An equation that calculates a new value from values currently in a worksheet.
Textjoin
A Text function used to combine the text values of cells including defining the delimiter character to use between cell values.
Formula Bar
A command-line above the worksheet that displays and where text, numbers, and formulas are entered into a worksheet.
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
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.
Arithmetic Operators
The symbols +, -, *, /, %, and ^ used to denote addition, subtraction (or negation), multiplication, division, percentage, and exponentiation in an Excel formula.
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
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