Clipboard E22 ✓ fx v Font Ex Alignment ly Number Б Styles Cells Editing Sensitivity Add-ins A B C E F G H I J K L M N O P Q R S T U Numerical Grade Credits Quality Points Letter Grade с 9 6666226680 12 3333333333333331331 В 0000000400000CBAC00 4 6 6 6 6 6 6 6 12 6 6 1 Course 2 Acct 2101 3 Acct 2102 4 Acct 3118 5 BuAd 2220 6 BuAd 2231 7 BuAd 2280 8 BuAd 3223 9 BuAd 3281 10 BuAd 3283 11 BuAd 3351 12 BuAd 3361 13 BuAd 3381 14 BuAd 3371 15 BuAd 3568 2345678901231CARPAN22222222 16 BuAd 4559 17 BuAd 4600 18 Econ 2000 19 Econ 2100 20 Math 1170 30 31 32 วา Sheet1 +
Clipboard E22 ✓ fx v Font Ex Alignment ly Number Б Styles Cells Editing Sensitivity Add-ins A B C E F G H I J K L M N O P Q R S T U Numerical Grade Credits Quality Points Letter Grade с 9 6666226680 12 3333333333333331331 В 0000000400000CBAC00 4 6 6 6 6 6 6 6 12 6 6 1 Course 2 Acct 2101 3 Acct 2102 4 Acct 3118 5 BuAd 2220 6 BuAd 2231 7 BuAd 2280 8 BuAd 3223 9 BuAd 3281 10 BuAd 3283 11 BuAd 3351 12 BuAd 3361 13 BuAd 3381 14 BuAd 3371 15 BuAd 3568 2345678901231CARPAN22222222 16 BuAd 4559 17 BuAd 4600 18 Econ 2000 19 Econ 2100 20 Math 1170 30 31 32 วา Sheet1 +
Chapter7: Input/output Technology
Section: Chapter Questions
Problem 3VE
Related questions
Question
100%
Could you please use VLOOKUP function to automatically convert letter grades to numerical grades using VLOOKUP. Automatically calculate quality points for each course. Automatically calculate major GPA from the information based in the picture? thanks!

Transcribed Image Text:Clipboard
E22
✓
fx v
Font
Ex
Alignment
ly
Number
Б
Styles
Cells
Editing
Sensitivity Add-ins
A
B
C
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
Numerical Grade Credits
Quality Points
Letter Grade
с
9
6666226680
12
3333333333333331331
В
0000000400000CBAC00
4
6
6
6
6
6
6
6
12
6
6
1 Course
2 Acct 2101
3 Acct 2102
4 Acct 3118
5 BuAd 2220
6 BuAd 2231
7 BuAd 2280
8 BuAd 3223
9 BuAd 3281
10 BuAd 3283
11 BuAd 3351
12 BuAd 3361
13 BuAd 3381
14 BuAd 3371
15 BuAd 3568
2345678901231CARPAN22222222
16 BuAd 4559
17 BuAd 4600
18 Econ 2000
19 Econ 2100
20 Math 1170
30
31
32
วา
Sheet1
+
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 2 images

Recommended textbooks for you

Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning

Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage

Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning

Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage

Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning

Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning

Enhanced Discovering Computers 2017 (Shelly Cashm…
Computer Science
ISBN:
9781305657458
Author:
Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:
Cengage Learning