Simple IF functions The teacher promised the class a pizza party if their final grade averages were 85 or better. Name Score Grade Catherine Donald 98 57 Doug Faye Jamal Jonathan 78 95 100 86 Kelly Leo 88 84 Marian 91 Ruthann 78 Terry 85 Average Class Score: Pizza? Nested IF functions Determine letter grades for the students: 100-90 is an A, 89-80 is a B, 79-70 is a C, 69-65 is a D, below that is an F.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
A
B
D
E
G
H
1 Simple IF functions
3The teacher promised the class a pizza party if their final grade averages were 85
4 or better.
Name
Score
Grade
Catherine
3 Donald
98
57
e Doug
LO Faye
1 Jamal
78
95
100
2 Jonathan
86
_3 Kelly
88
_4 Leo
84
_5 Marian
91
L6 Ruthann
78
17 Terry
85
18
19 Average Class Score:
20 Pizza?
21
22
23 Nested IF functions
24
25 Determine letter grades for the students: 100-90 is an A, 89-80 is a B, 79-70 is a
26 C, 69-65 is a D, below that is an F.
27
28
Transcribed Image Text:A B D E G H 1 Simple IF functions 3The teacher promised the class a pizza party if their final grade averages were 85 4 or better. Name Score Grade Catherine 3 Donald 98 57 e Doug LO Faye 1 Jamal 78 95 100 2 Jonathan 86 _3 Kelly 88 _4 Leo 84 _5 Marian 91 L6 Ruthann 78 17 Terry 85 18 19 Average Class Score: 20 Pizza? 21 22 23 Nested IF functions 24 25 Determine letter grades for the students: 100-90 is an A, 89-80 is a B, 79-70 is a 26 C, 69-65 is a D, below that is an F. 27 28
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Function Arguments
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education