 |
Java Games: Flashcards, matching, concentration, and word search. |
 |
|
Spreadsheets Part 3-Calculations
|
| A | B |
|---|
| Begins a formula | = |
| order of operations | PEMDAS |
| + | Addition |
| - | subtraction |
| * | multiplication |
| / | division |
| ^ | exponents |
| =SUM(B4:B8) | function |
| =C2+C5 | formula |
| relative | formula changes when copied down/across |
| absolute | don't want formula to change when copied down/across |
| $A$2 | holds entire cell reference constsant |
| $B1 | hold column B constant but changes the row number |
| C$2 | hold row 2 constant but changes column |
| conditional formatting | looks at cell and tests it against a condition, if TRUE formatting of your choice applied |
|
|
|
|
|
Digital Information Technology Teacher |
SCFCS |
| Venice, FL |
|
|
|
|
|
| |
