Symbols
goes before the parenthesis in a formula at the BEGINNING of a formula
= equal sign
This function adds all the numbers in a selected range of cells
SUM function
A function that allows the user to make a comparison between two values and then returns a true or false result.
IF function
must always start with a "="
a formula
a Microsoft Application that allows the user to create spreadsheets which are mathematical in nature and include formulas to automatically calculate answers.
Excel
/ - forward slash
This function adds a group of values, then divides the result by the number of values in the group
AVERAGE function
A function that returns the opposite of a result.
NOT Function
a default cell reference where the cell references in a formula or function will change to reflect the new location when moved or copied
Relative Cell Reference
ESC
represents multiplication in a spreadsheet formula
* - asterisk
This function used to provide a count of the number of cells containing numerical values within the selected range of cells.
COUNT function
A function that performs a horizontal lookup by searching for a value in the top row of a table and returning the value from the same column.
HLOOKUP Function
a cell reference that will not change to reflect a new location when moved or copied
Absolute Cell Reference
the small handle on the bottom right corner of a cell which allows the user to copy the contents of the selected cell to the adjacent cells
Fill Handle
The symbol required at the start and finish when writing functions in Excel.
Parenthesis ()
This function displays the highest value in a range
MAX function
A function used to calculate the payments of a loan.
PMT Function
a cell reference that combines an absolute reference and a relative reference.
Mixed Reference
must always start with a "="
formula
This symbol must be places on a cell reference row letter and column number in order to designate it as an absolute cell reference
$ Dollar sign
This function is a conditional statement that performs one action or value if the condition is true and a different action or value if the condition is false
IF / THEN function
A function that compares a value with a list of values, and then returns a result that corresponds with the first match.
SWITCH Function
This is what will happen if you copy a formula that contains a relative cell reference
It will change
a prewritten formula that makes it easy to perform common calculations especially when they involve too many cells to list separately
Function