Tuesday, October 25, 2011
Reading assignment:
Lecture book, ch 5
Do the quickchecks
CSS - cascading style sheets
http://www.w3schools.com/css/default.asp
CSS rules
selector { declarations; declarations;}
declaration is property:value
selectors which are tags
id and class selectors
we are up to CSS how to
excel
rows
cols
cells
name box tells you name of the cell
in cells, can store values, formulas
we call these values literals
formulas begin with =
formula bar will display the formula
operators and operands
+ - / * ^
PEMDAS
how to "debug" formulas
1) stare blankly at screen; think hard
2) use debugging tools
Formula Auditing / Evaluate formula
excel is smart! it adjusts relative refs for you. increment, decrement rows and cols
functions are basically operators without the symbols
pass in 'operands' as parameters
diff number of arguments
A1:B6 means all the cells from A1 to B6
is called a range
Ctrl plus and minus
refer to diff sheets
diff books
magic number
isolate assumptions
using names and the name box
Names
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment