Introduction to Formulas
An equation that is entered in a cell.
Formula
A way to point to a cell location on the spreadsheet.
Cell Reference
A formula that only contains one type of operator
Simple Formula
is a predefined formula that performs a calculation based on values that are entered in the function.
Function
: Finds the largest value included in a range of cells
MAX
Why do formulas make spreadsheets more powerful?
Formulas allow you to calculate additional information
Explain how the color coding of cell references in a formula works and why it is useful.
Colors are used to highlight the cell references in the formula and the referenced cell in the spreadsheet
A formula that contains more than one type of operator.
. Complex Formula
Name three parts of a function
Equal Sign
Arguments
Function Name
Finds the smallest value included in a range of cells.
MIN
Describe the three parts of a formula
Equal sign
Operator
Operand
Describe one of the two ways you can enter cell references into a formula.
(Point-and-click method).
List the order of operations.
1. Parentheses
2. Exponents
3. Multiplication and division, working left to right
4. Addition and subtraction, working left to right
Adds all the values in a range of cells.
SUM
What is a mathematical equation used in Excel to perform calculations.
Formula
. How can you see the formula in the cell?
You can select the cell
Determines which parts of a complex formula to calculate first.
Order of Operations
Calculates the average of the values in a range of cells by summing the cells and dividing by the number of cells used to find the sum
Average
What are three parts of a formula in Excel?
Equal sign
operand
operator
. What is the benefit of entering or editing a formula using the Formula Bar?
The Formula Bar allows you to see more of the formula.
How can you force a certain order of operations in a formula?
parentheses
Counts the cells with numerical values in a range of cells.
COUNT
What are two types of cell reference?
Relative and Absolute