wd DemoLes 15 - A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17...

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

View Full Document Right Arrow Icon
e25ba5dd60d7856180dd7ecbdde7de21ebc6a899.xls, RangeLookups Name Quiz1 Quiz2 Quiz3 Average Grade Comment Margaret 92 78 90 87 C OK Joe 73 92 69 78 D More Work Thelma 93 87 75 85 C OK Jane 75 79 85 80 D More Work George 83 92 97 91 B Great Grade Criteria for Excel 0 F Needs Help 75 D More Work 81 C OK 88 B Great 94 A Outstanding Loan Fees for Customer Loans Name Loan Amount Fee (%) Fee ($) Jones $120,000 1.5% $1,800.0 Smith $90,000 1.0% $900.0 Lee $210,000 2.0% $4,200.0 Barajas $350,000 3.0% $10,500.0 Lookup Table Amount Loan Fee 0 1.0% $100,000 1.5% $200,000 2.0% $300,000 3.0% Class Grades é lowest value of interval, ascending order Enter the formulas needed to calculate (a) the correct loan fee as a percentage and (b) the correct loan fee in dollars (percentage * loan amount). Grading Criteria 94–100 A 88–93 B 81–87 C 75–80 D 0–74 F A B C D E F G 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
Background image of page 1

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

View Full DocumentRight Arrow Icon
e25ba5dd60d7856180dd7ecbdde7de21ebc6a899.xls, RangeLookups Outstanding Invoices Amount Note 1 130 $475.43 $11.89 $487.32 Send warning notice.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/30/2010 for the course FINANCE Excel taught by Professor Vahn during the Spring '10 term at City College of San Francisco.

Page1 / 6

wd DemoLes 15 - A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17...

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

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