Spreadsheets 2

Spreadsheets 2 - CS 170: Spreadsheets 2 Kristian Stout...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

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

Unformatted text preview: CS 170: Spreadsheets 2 Kristian Stout [email protected] Functions Expectations • Functions ▫ Sum, Product ▫ IF ▫ Count, CountA, CountIF ▫ Round, Trunc ▫ Average, Median, Min, Max ▫ Today • Combining Functions into formulae ▫ also: nesting functions • naming cells & naming ranges Planning Spreadsheets 1) What is our scenario ? ▫ Database or Data Analysis ? 2) What inputs and outputs will we need ? ▫ What is being “grouped” or examined ? What is our subject ? 3) What tasks need to be performed ? 4) What built in functions will be necessary to perform this task ? Problem / Solution 1 For this problem you will use a single spreadsheet to help you keep track of your current inventory at different warehouses. Your sheet will need to track the Warehouse Name (a text input), Qty on Hand (a numeric input), Cost Per Unit (a currency input),...
View Full Document

This note was uploaded on 02/21/2012 for the course 198 170 taught by Professor Kristianstout during the Fall '10 term at Rutgers.

Page1 / 6

Spreadsheets 2 - CS 170: Spreadsheets 2 Kristian Stout...

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

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