Working with formulas! Flashcards
What is the difference between formulas and functions?
Formulas are user-defined instructions to perform calculations, whereas, functions are the pre-defined or in-built formulas that come with Excel.
What are formulas used for?
Formulas are used to perform calculations involving addition, subtraction, division and multiplication.(arithmetic operations)
What does a formula establish in a spreadsheet?
A formula establishes a relationship between two or more cells.
What can be included in a formula?
A formula is an expression that can include cell addresses, numbers, arithmetic operators, and parenthesis.
What types of calculations can formulas be used for?
Formulas can be used to perform both simple and complex calculations.
What must formula begin with and then what can it be followed by?
Formula must begin with equal to(=) sign followed by cell references and operators.
What are the elements that a formula may include in Excel?
The elements that a formula may include are references, operators, constants, functions.
What are references?
A cell or range of cells that you want to include in your calculation
What are operators?
Symbols(+,-,*,/,$,#, etc.)that specify the operation to be performed.
What are constants?
Number or text values that do not change
What are function?
Predefined formulas in excel
In the formula =A2+B2*5-SUM(E3:E5), identify all the elements.
The = sign at the beginning. The cell addresses A2, B2, E3, and E5. The mathematical/arithmetic operators +, * and -. The constant 5. The function SUM. The range (E3:E5)
What is an example of a formula?
An example of a formula is =A2+B2*5-SUM(E3:E5)
