Using the IF/Else Statement Use the IF/Else statement in cell C71-C77 to display whether a student passed or failed their exam based on their scores in the table below. The passing test score for this table is 60 and above. Enter a formula in column C that will display either "PASS" or "FAIL" based on scores received on test. Last Name Scores Pass/ Fail Grant 55 Adams 65 Sully 95 Bain 75 Turner 83 Williams 49.99 Harper 81
Using the IF/Else Statement Use the IF/Else statement in cell C71-C77 to display whether a student passed or failed their exam based on their scores in the table below. The passing test score for this table is 60 and above. Enter a formula in column C that will display either "PASS" or "FAIL" based on scores received on test. Last Name Scores Pass/ Fail Grant 55 Adams 65 Sully 95 Bain 75 Turner 83 Williams 49.99 Harper 81
Chapter6: Managing Multiple Worksheets And Workbooks
Section: Chapter Questions
Problem 3.10CP
Related questions
Question
Using the IF/Else Statement | |||||||
Use the IF/Else statement in cell C71-C77 to display whether a student passed or failed their exam based on their scores in the table below. | |||||||
The passing test score for this table is 60 and above. Enter a formula in column C that will display either "PASS" or "FAIL" based on scores received on test. | |||||||
Last Name | Scores | Pass/ Fail |
|||||
Grant | 55 | ||||||
Adams | 65 | ||||||
Sully | 95 | ||||||
Bain | 75 | ||||||
Turner | 83 | ||||||
Williams | 49.99 | ||||||
Harper | 81 |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 2 images
Knowledge Booster
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
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
C++ for Engineers and Scientists
Computer Science
ISBN:
9781133187844
Author:
Bronson, Gary J.
Publisher:
Course Technology Ptr