Question 1 (6 points) A B C D Possible Outcome Range Average Pass 50% or more Rewrite Less than 60% but greater than or equal to 50 % Fall Less than...
This is for my introductory computer science class, these are excel related, i'm new to the course so thank you in advance :)
- Attachment 1
- Attachment 2
- Attachment 3
Question 1 (6 points)ABCDPossible OutcomeRangeAveragePass50% or moreRewriteLess than 60% but greater than or equal to 50 %FallLess than 50%NamPercentage ScoreOutcomeXin99%Harry82610Isla60%11Hanxiao12Abode50%%13Chad10%14Brad10%15Alfie78%16Isabella86%17Mohommed84%In the above spreadsheet, create a formula using the IF Excel function in cell D8 that willdetermine the outcome of the percentage scores, based on the possible outcomes and theirranges. You should be able to fill down through cells D8:D17. You may also use the AND Excelfunction.Do not use any spaces within your answer.Using the AVERAGEIF Excel function, create a formula to be filled down through cells D3:D5.The formula should display the average of the percentage scores, based on the outcomesachieved.Do not use any spaces within your answer.A/
Show more
