{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Lecture 27

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

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

CS170 Computer Applications for Business Fall 2008 Instructor: Kristian Stout Lecture 27 Exam 3 Review

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

View Full Document
Breakdown Part 1: Multiple Choice 25 Questions / 50 Points Part 2: True/False 15 Questions / 15 Points Part 3: Spreadsheets 10 Questions / 30 Points Part 4: HTML & Coding 2 Questions / 20 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 ?

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

View Full Document
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()
Spreadsheets (cont) Sorting - Single sorting and multi-sorting Primary & Secondary keys Filtering - Autofilter & advanced filter - Cell visibility Charts - Data series - How do axes work in charts

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

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

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern