A Student 1 2 Jack Smith 3 Rina Lowan 4 Louise Rank 5 Charlotte Drew 6 Caitlynn Marsh 7 Laura Budden 8 Percival Craig 9 Lambert Smith 10 James Dawkins 11 Caitlynn Marsh 12 Carla Becker 13 John Dorian B Score 58 37 94 48 90 63 75 71 75 O-IF(B2>50,"yes") IF(C2-"yes") -IF(B2-C2, "yes") O-IF(B2-50, "yes") 73 70 65 C Pass Study the screenshot above. Which of the following functions, when inserted in the highlighted cell (C2) above, will return the word "yes"?

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
100%

7

A
Student
1
2 Jack Smith
3 Rina Lowan
4
Louise Rank
5
Charlotte Drew
6 Caitlynn Marsh
7 Laura Budden
8
Percival Craig
9 Lambert Smith
10 James Dawkins
11 Caitlynn Marsh
12 Carla Becker
13 John Dorian
B
Score
58
37
94
48
90
63
75
71
75
73
70
65
O-IF(B2>50,"yes")
-IF(C2-"yes")
-IF(B2-C2, "yes")
-IF(B2-50, "yes")
C
Pass
Study the screenshot above. Which of the following functions, when inserted in the highlighted
cell (C2) above, will return the word "yes" ?
Transcribed Image Text:A Student 1 2 Jack Smith 3 Rina Lowan 4 Louise Rank 5 Charlotte Drew 6 Caitlynn Marsh 7 Laura Budden 8 Percival Craig 9 Lambert Smith 10 James Dawkins 11 Caitlynn Marsh 12 Carla Becker 13 John Dorian B Score 58 37 94 48 90 63 75 71 75 73 70 65 O-IF(B2>50,"yes") -IF(C2-"yes") -IF(B2-C2, "yes") -IF(B2-50, "yes") C Pass Study the screenshot above. Which of the following functions, when inserted in the highlighted cell (C2) above, will return the word "yes" ?
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Processes of 3D Graphics
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.
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