Study Guides (248,619)
Canada (121,639)
CS 100 (27)
Final

Exam Review Package EXAM!

21 Pages
290 Views

Department
Computer Science
Course Code
CS 100
Professor
Barbara Csima

This preview shows pages 1,2,3,4. Sign up to view the full 21 pages of the document.
Description
Review Package Winter 2011OverviewThe 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 VLOOKUPINDIRECTCONCATENATECS100 Review Package Winter 2011 Page 1 of 21IFSEARCH2 Explain the difference between a relative address and an absolute address Why would it be useful to name a particular cell or cell rangeSpreadsheet Exercises Gym Memberships The following spreadsheet calculates the annual cost of a gym membershipFee 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 chargedCS100 Review Package Winter 2011 Page 2 of 21
More Less
Unlock Document

Only pages 1,2,3,4 are available for preview. Some parts have been intentionally blurred.

Unlock Document
You're Reading a Preview

Unlock to view full version

Unlock Document

Log In


OR

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


OR

By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.


Submit