{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

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

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

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

View Full Document
e25ba5dd60d7856180dd7ecbdde7de21ebc6a899.xls, RangeLookups Outstanding Invoices Amount Note 1 130 \$475.43 \$11.89 \$487.32 Send warning notice. 2 75 \$321.43 \$4.82 \$326.25 3 174 \$543.98 \$16.32 \$560.30 Send to collection agency.
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}