formulas and functions(notes)

formulas and functions(notes)

formulas are the predefined or inbuilt formulas that comes with ms excel

a formula establishes a relationship between two or more cells

constants are the value that contains numbers or place value that do not change.

compound formula is used when more than one operator is used to perform calculations.

to use the absolute formula you need to put the $ symbol before the operator.

functions are the predefined formulas in excel used to perform simple and complexed calculations.

input values of functions are called as arguments

to copy the formula of the selected range press the F2 key and press the ctrl+enter key.

the auto sum option is found on the editing group on the home tab

function accepts arguuments and return values.

all functions are clubbed in function library group on the formula tab

insert function is one of the function in the function library group in the function library group that helps us create the formula.

answer in one word:

1. a cell or a range of cells that you want to insert in your calculation by inserting formula

• refrences

2. a term used for the group of cells adjacent to each other in a worksheet

• range

a term used for the addition of two or more text value is called :

concatenation

a type of reference used when we don't want to change the cell reference while copying the cell to another cell

absolute refrence

this reference occurs when a formula or text value when a formula refers to its own cell directly or indirectly

circular refrance

the tool in quick analysis button that helps in using various functions

total

the thing that occurs when a formula has a invalid argument

#value!

keyboard shortcuts

to modify the formula in a cell: F2

to copy the cell from the above cell: ctrl='

to get the total from the adjacent cells: Alt+=