CS 105 Lecture 3: cs 105 9/21

• School: University of Illinois
• Department: Computer Science
• Course: CS 105
• Professor: Albert F Harris

Document Summary

I(cid:374) the (cid:862)if(cid:863) fu(cid:374)(cid:272)tio(cid:374)s (cid:894)e. g. countif, umif (cid:895: the criteria could be matching a string, or a substring- part of a string, wildcard character- , note: e(cid:454)(cid:272)el does(cid:374)(cid:859)t (cid:449)orr(cid:455) after (cid:272)ase p(cid:455)tho(cid:374) (cid:449)ill! String matching example: bbob, bob, bbobbb joe jimmy. Lookup/reference functions: a new type of reference: the index, a relative coordinate, based on a range of cells. Index- return a value at an index: think of this as the inverse of match, give it an index and it returns a value. Nested functions: nesting: important concept in computer science, basic idea: put a function as the input to another function, functions in functions, easiest way to build them in excel- one step at a time, take it slow first. By default, it is approximate match: approximate returns the next smaller value, false== exact match. Graph challenge: how to choose the right visualization technique, takes i(cid:374)tuitio(cid:374) (cid:271)uilt fro(cid:373) e(cid:454)perie(cid:374)(cid:272)e, they are not hard to make, so experiment.