A formula is composed of cell references, values and mathematical operators. A cell reference refers to the spreadsheet cell address, which is indicated by a column letter and a row number. The cell at the intersection of column C and row 50 is referred to as cell C50. A formula may contain a numeric value. Constants may be used in formluas when the value isn't stored in the spreadsheet.
Mathematical operators refers to the symbol used to indicate a mathematical function.
Mathematical Operators Operators are the method of mathematical function used to return the desired output such as Plus, Minus, Divided by, etc. In the Real Example column shown above there are values, but on a spreadsheet the formula can use cell references that change value with user input without having to edit the formula. A call reference is a placeholder, in this case a value entered into a cell. This means that instead of having to manually update the values in a formula every single time a user inputs data, the formula works with whatever data is stored in its reference or cell area. Excel sure does.