Week%205-ACC381 - CollegeofBusiness Information Systems...

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

View Full Document Right Arrow Icon
Name College of Business Information Systems Management / Accounting Information Systems Lab - Retrieving Data for Analysis Samantha Kleitsch / Lise Urbaczewski
Background image of page 1

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

View Full DocumentRight Arrow Icon
Today, we will set up and refer to a lookup table… When would we use this?? We might have ‘ranges’ of data, for example: - discounts for larger quantities - shipping rates based on speed of delivery - sales tax by state - grades determined by score! Property of L. Urbaczewski / S. Kleitsch
Background image of page 2
If we set up Excel using IF statements… We might need to use nested IF statements: - e.g. IF item type is A [or B or C….] IF quantity is less than X but greater than Y…. IF customer selects MI [ or IL, OH, …] IF grade is greater than 50 but less than 60…. Greater than… Bottom line, VERY confusing with lots of options (read: too many possibilities for errors!) Property of L. Urbaczewski / S. Kleitsch
Background image of page 3

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

View Full DocumentRight Arrow Icon
Determining the Grade (last populated column) – refer to the Grade Table… Property of L. Urbaczewski / S. Kleitsch
Background image of page 4
Grade Table tells us… The logic is pretty simple, right? Percentage: - 0% receives a grade of F - 60% receives a D - 70% C - 80% B - 93% A Note: the table is written in ascending order - what if it was in descending order? - what if it was not even sorted (i.e. random) Property of L. Urbaczewski / S. Kleitsch
Background image of page 5

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

View Full DocumentRight Arrow Icon
Focus Today: 1. Understand VLOOKUP and HLOOKUP 2. Analyze / retrieve data 3. Using multidimensional tables 4. **** PREVENTING ERRORS in data retrieval**** 5. Assignment 5, Create and use lookup tables to calculate totals Property of L. Urbaczewski / S. Kleitsch
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/07/2011 for the course ACC 381 taught by Professor Samanthakleitsh during the Spring '11 term at University of Michigan-Dearborn.

Page1 / 21

Week%205-ACC381 - CollegeofBusiness Information Systems...

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

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