Formulas
Displaying Formulas
Order of Operations
100
what symbol comes before a formula
=
100
what is the symbol for mutliplcation
*
100
what is a nested parenthesis
(())
200
what is a variable example
a=6
200
what is a constant
a text value entered directly into a formula
200
What is the order of operations?
a specific order that Excel follows to calculate a formula
300
Is this correct: =5+6=
Not correct
300
how do you edit a cell with a formula in it
double clicking it
300
Is this a correct order?- Division, subtraction, addition
no, addition is before subtraction
400
=5+9-7
7
400
what is the symbol for an exponent called
caret
400
What order does the order of operations come in?
pemdas
500
is sum a formula
No its a function
500
Name two things that a value can be in a formula
number, cell address, date, text, Boolean data
M
e
n
u