Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I am working on an Excel Spreadsheet assignment and I am stuck at the part where I have to write a Formula for the Final
I am working on an Excel Spreadsheet assignment and I am stuck at the part where I have to write a Formula for the Final Percentage on the spreadsheet attached below. The first percentage 84.40% is what I am supposed to get with my formula, but the numbers I get every time are different than the sample solution. I wasn't sure which formula using the absolute cell reference will get 84.4%. Help would be much appreciated, thanks.
20 19 16 20 17 20 18 84.40% 15 15 17 18 Student Number 300456789 301902348 300196359 300428736 301200084 301603782 301402178 Student Name Smith, John Watson, Tom Adams, Sandra Lock, Joe Rawson, Tony Green, Randy Matthews, Sam 20 18 14 17 19 12 20 20 30 27 23 21 26 20 26 28 50 44 46 40 45 39 42 48 16 19 13 19 20 100 78 65 73 84 66 70 91 100 82 75 70 78 70 65 84 20 13 19 20 19 14 19 19Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started