Ch.2: Excell as a Calculator Flashcards
1
Q
Functions
A
- A word that gets Excel to do something special
- Put equal sign to activate it
2
Q
Colon and a comma
A
Colon : will select all of the cells whereas a comma , will only select two
3
Q
Relative reference
A
Will change with the cell
4
Q
Absolute reference
A
Locks in the cell $B$4 use F4 key
5
Q
Value vs. formula
A
Value is th enumber, formula is +A1*$A$6
6
Q
Cell format
A
General: 5-Mar
Number: .60
Text: 3/5
Currency $0.60
