Lecture 27

Lecture 27 - Computer Applications for Business CS170 Fall...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
CS170 Computer Applications for Business Fall 2008 Instructor: Kristian Stout Lecture 27 Exam 3 Review
Background image of page 1

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

View Full DocumentRight Arrow Icon
Breakdown Part 1: Multiple Choice 25 Questions / 50 Points Part 2: True/False 15 Questions / 15 Points Part 3: Spreadsheets 10 Questions / 30 Points 2 Questions / 20 Points Freebie 5 Points
Background image of page 2
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 ?
Background image of page 3

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

View Full DocumentRight Arrow Icon
Spreadsheets (cont) How do cell ranges work ? What’s the diff between a worksheet and a workbook ? Basic functions that handle common, summary applications: - Count() - CountA() - PMT() - Average() - Max() - Min() - IF() - VLOOKUP()
Background image of page 4
Spreadsheets (cont) Sorting - Single sorting and multi-sorting Filtering - Autofilter & advanced filter - Cell visibility Charts - Data series - How do axes work in charts
Background image of page 5

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

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/07/2011 for the course COMP 178 taught by Professor Stout during the Fall '08 term at Rutgers.

Page1 / 11

Lecture 27 - Computer Applications for Business CS170 Fall...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online