Excel 3 - CS170:MoreSpreadsheets Functions KristianStout

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

View Full Document Right Arrow Icon
CS 170:  More Spreadsheets  Functions  Kristian Stout [email protected]
Background image of page 1

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

View Full DocumentRight Arrow Icon
Expectations PMT =PMT(rate, NPER, PV, FV, type)  Calculate a periodic payment VLOOKUP VLOOKUP ( lookup_value , table_range , col_index_ num ,range_lookup) Use a lookup table to find a value Looking up to the “left” Uses index and match functions MATCH will find a row # for a value INDEX( TABLE_RANGE, ROW, COLUMN)
Background image of page 2
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 ?
Background image of page 3

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

View Full DocumentRight Arrow Icon
Problem 1 : Capital Goods We need to create a spreadsheet that will helps us record the capital goods we  consume in the course of production. We need fields and labels for 
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

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

Page1 / 5

Excel 3 - CS170:MoreSpreadsheets Functions KristianStout

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