Study Guides (390,000)
CA (150,000)
UW (7,000)
CS (400)
CS100 (40)
Final

CS100 Study Guide - Final Guide: Zydrunas Ilgauskas, Small Forward, Shooting Guard


Department
Computer Science
Course Code
CS100
Professor
Barbara Csima
Study Guide
Final

This preview shows pages 1-3. to view the full 21 pages of the document.
CS100 Review Package Winter 2011 Page 1 of 21
Review Package
Winter 2011
Overview
The$tutors$of$CS$100$created$this$review$package.$It$is$based$on$all$the$course$
material,$some$of$which$may$have$been$used$in$previous$assignments.$Make$sure$to$
study$the$material$before$you$start$on$this$package.$Also,$be$sure$to$note$that$this$
package$is$not$intended$to$be$a$sample$or$practice$exam,$but$to$supplement$your$
own$studying.$We$strongly$encourage$you$to$try$to$complete$this$package$without$
any$outside$help.$
Excel Review
1)$Provide$a$brief$explanation$of$the$purpose$and$list$the$parameters$for$the$
following$functions:$
VLOOKUP:$
$
INDIRECT:$
$
CONCATENATE:$
$

Only pages 1-3 are available for preview. Some parts have been intentionally blurred.

CS100 Review Package Winter 2011 Page 2 of 21
IF:$
$
SEARCH:$
$
2)$Explain$the$difference$between$a$relative$address$and$an$absolute$address.$Why$
would$it$be$useful$to$name$a$particular$cell$or$cell$range?$
$
Spreadsheet*Exercises*
Gym$Memberships:$
The$following$spreadsheet$calculates$the$annual$cost$of$a$gym$membership.$$
Fee$Breakdown:$
1) Members$are$charged$monthly$based$on$their$membership$type$
2) Members$are$charged$monthly$for$a$fitness$class$
3) Members$can$pay$to$have$a$fitness$test$
4) Members$who$are$under$18$or$over$65$receive$a$discount$
5) HST$is$charged$
$

Only pages 1-3 are available for preview. Some parts have been intentionally blurred.

CS100 Review Package Winter 2011 Page 3 of 21
You're Reading a Preview

Unlock to view full version