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

No comments:

Post a Comment