Lecture+27

Lecture+27 - CS 170 Lecture 27 Final Review Kristian Stout

This preview shows pages 1–5. Sign up to view the full content.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: CS 170 Lecture 27 Final Review Kristian Stout stouty@rci.rutgers.edu Breakdown Part 1: Multiple Choice 20 Questions / 40 Points Part 2: True/False 15 Questions / 15 Points Part 3: Spreadsheets 15 Questions / 30 Points Part 4: HTML 1 Question / 5 Points Part 5: Javascript 1 Question / 5 Points Freebie 5 Points Spreadsheets Cells Basic unit of the spreadsheet Rows Horizontal grouping of cells Columns Vertical grouping of cells Cell References: Absolute vs Relative What types of cell content can be copied to other cells ? Spreadsheets (cont) How do cell ranges work ? Whats the diff between a worksheet and a workbook ? Basic functions that handle common, summary applications: Count() CountA() PMT() Average() Max() Min() IF() VLOOKUP() Be aware of the Bubble Chart Be aware of the 2 functions we use to do a lookup to the left Spreadsheets (cont)...
View Full Document

This note was uploaded on 11/17/2011 for the course BUSINESS 198:170 taught by Professor Staff during the Spring '09 term at Rutgers.

Page1 / 15

Lecture+27 - CS 170 Lecture 27 Final Review Kristian Stout

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online