Computer
Applications – Mrs. Miñoso
Problem 1: Design a formula using Vlookup to place a Letter Grade in Column G
|
|
A |
B |
C |
D |
E |
F |
G |
|
1 |
|
Test |
Test |
Test |
Average |
Pass/Fail |
Letter Grade |
|
2 |
Amy |
98% |
98% |
88% |
95% |
|
|
|
3 |
Brian |
25% |
89% |
78% |
64% |
|
|
|
4 |
Mary |
56% |
87% |
85% |
76% |
|
|
|
5 |
Benny |
88% |
84% |
65% |
79% |
|
|
|
6 |
Cindy |
78% |
85% |
77% |
80% |
|
|
|
7 |
Sophie |
95% |
96% |
44% |
78% |
|
|
|
8 |
Chris |
78% |
25% |
65% |
56% |
|
|
|
9 |
David |
99% |
77% |
30% |
69% |
|
|
|
10 |
|
|
|
|
|
|
|
|
11 |
|
|
|
Lowest
Grade |
|
|
|
|
12 |
|
|
|
Highest
Grade |
|
|
|
|
13 |
Percentage |
Letter Grade |
|
|
|
|
|
|
14 |
0% |
F |
|
|
|
|
|
|
15 |
60% |
D |
|
|
|
|
|
|
16 |
70% |
C |
|
|
|
|
|
|
17 |
80% |
B |
|
|
|
|
|
|
18 |
90% |
A |
|
|
|
|
|
Problem 2:
Design a formula using Vlookup to place a Letter Grade in Column G
|
|
A |
B |
C |
D |
E |
F |
G |
|
1 |
Tax Amount |
6.50% |
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
3 |
|
Sale Price |
Quantity |
Revenue |
Markup Percentage |
Markup |
New Price |
|
4 |
Apples |
$ 0.50 |
1,000 |
$ 500.00 |
|
|
|
|
5 |
Kiwi |
$ 0.65 |
2,500 |
$ 1,625.00 |
|
|
|
|
6 |
Cherries |
$ 0.25 |
2,000 |
$ 500.00 |
|
|
|
|
7 |
Mango |
$ 0.95 |
1,500 |
$ 1,425.00 |
|
|
|
|
8 |
|
|
Total
|
|
|
|
|
|
9 |
Current Price |
Markup Percentage |
|
|
|
|
|
|
10 |
0 |
20% |
|
|
|
|
|
|
11 |
.25 |
30% |
|
|
|
|
|
|
12 |
.50 |
40% |
|
|
|
|
|
|
13 |
.75 |
50% |
|
|
|
|
|
|
14 |
1.00 |
60% |
|
|
|
|
|
Problem #3: Determine what the monthly payment would be for a $25,000 car financed over a five year period with an interest rate of 6.5%. And compare it to a $25,000 car financed over a 3 year period with an interest rate of 6.5%.
|
|
A
|
B
|
C
|
|
1 |
Car
Loan |
|
|
|
2 |
|
5 Year Loan
|
3 Year Loan
|
3 |
Principal
|
$
25,000.00 |
$
25,000.00 |
|
4 |
Rate |
6.50% |
6.50% |
|
5 |
Term |
60 |
36 |
|
6 |
|
|
|
|
7 |
Monthly
Payment |
|
|
|
8 |
|
|
|
|
9 |
Total
Paid |
|
|
|
10 |
Total
Interest |
|
|