Question: I am working in Microsofts Excel and need to know how to solve this problem in Excel. QUESTION: Calculate the student award as Fail, Pass,

I am working in Microsofts Excel and need to know how to solve this problem in Excel.

QUESTION:

Calculate the student award as Fail, Pass, or Distinction based on their score using a nested =IF function.

Student Suzi Claire Emily Nate Sarah Caroline Score 59 or below Fail 60 to 79 Pass Score 61 84 Award 52 41 98 Award Note Award designations are subject to So or above Distinction change PAss or Distinction based Calculate the student award as Fail, Pass, or Distinction based on their score

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

According to the January theory, if the stock market is up at the end of January, it will be up for the year. If it is down at the end of January, it will be down for the year. Within the last 34...

Please read the question Question : What strategies have you used to communicate in a language you were acquiring? What strategies do you think emergent bilinguals use? 3 How Do People Learn and How...

******ebook converter DEMO Watermarks******* ******ebook converter DEMO Watermarks******* ******ebook converter DEMO Watermarks******* ******ebook converter DEMO Watermarks******* Also by Marcus...

Please write the selecting tools and approaches (according to the subject R esearch Method ) for this topic SECOND LANGUAGE ACQUISITION: LEVEL OF INTEREST IN LEARNING MANDARIN CHINESE LANGUAGE AS A...

Structure your organization's work to encourage wise choices. by John Beshears and Francesca Gino Leaders as Decision Architects ALL li"PLOYEES, from CEOs to frontline workers, commit preventab}e...

Essay Motivation at New United Motor Manufacturing, Inc (NUMMI) By Gary Convis Origins of NUMMI. The Fremont plant of General Motors opened in 1965, and after experiencing nearly decades of...

just only 2 questions ,please read the requirment word by word and be careful about the style of the reference(APA) , file 3.1 is for question 2..BTW,please focus the every step FINANCE SPOTLIGHT...

I got this big assignmnet for Quantitative methods for business i really need help Azimi, Hamida - azihy004 AH Share Comments Delete this page before submission Q-Constructions - building your future...

I'm an undergrad accounting student in an introduction to forensic accounting course.I need help getting started on a final project for this class over a fictitious company called the Grand Teton...

StanfordSOCIAL INNOVATION REVIEW Up For Debate When Can Impact Investing Create Real Impact? By Paul Brest & Kelly Born With Responses From Audrey Choi, Sterling K. Speirn, Alvaro Rodriguez Arregui &...

2017/4/11 Section 5.7 (Part A) [43 points] WebAssign Section 5.7 (Part A) [43 points] (Homework) Current Score : - / 43 Huizhi Liu MA 114, section 601, Spring 2017 Instructor: Lavon Page Due :...

Assume that your bank is not obligated to pay taxes. Calculate your bank's 1) ROA, 2) ROE, and 3) its ratio of bank assets to bank capital.Show your calculations for each of these three measures ...

Table 1 : Temperature and volume data Trial Temperature (Celsius) Volume (mL) Starting Volume Room Temperature = Hot Water Trial 1 Hot Water Trial 2 Cold Water Trial 1 Cold Water Trial 2 PLOT AREA...

We are evaluating a project that costs $ 9 8 3 , 0 0 0 , has a life of eleven years, and has no salvage value. Assume that depreciation is straight - line to zero over the life of the project. Sales...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

How do Dimensional Database Models differ from Relational Models?

What type of processing do Relational Databases support?

Describe several aggregation operators.