Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,198,777 members, 7,969,291 topics. Date: Tuesday, 08 October 2024 at 02:20 AM |
Nairaland Forum / Science/Technology / Computers / Excel Tutorials: How To Make A Result Sheet In Excel (381 Views)
Excel Tutorials: How To Calculate Percentage Increase And Decrease In Excel / MS Excel Help Needed (come In Excel Gurus) / Photoshop Video tutorials 2018 Learn how to use Photoshop for FREE (2) (3) (4)
(1) (Reply)
Excel Tutorials: How To Make A Result Sheet In Excel by clintonty(m): 8:33pm On Jun 21, 2020 |
Are you a Teacher of Office manager? This could be helpful. This will assist you in computing Continuous Assessment given in 100% to 40% while the Exam given in 100% is to be converted to 60%. Addition will give a result of 100%. Using Microsoft excel to calculate results and make result sheet requires the knowledge of excel arithmetic formulas especially multiplication and addition. Step 1 1. To convert continuous assessment 100% to 40%, multiply the cell by 0.4 e.g. D2 = B2*0.4 2. To convert examination score of 100% to 60%, multiply the cell by 0.6 e.g. E2 = C2*0.6 3. For total score in 100%, add the CA and the examination cells i.e. F2 = D2 + E2 You can learn more here https://www.youtube.com/watch?v=WTI8pgtrmEY&t=1s Thank you. |
(1) (Reply)
The Complete Review Of Hp Pavilion 15 For Every Computer Geek / Hp Compaq CQ42 AMD Athlon(tm) P340 Dual-core 320gb 2gb Ram, 40k / V.neat Macbook Pro For Sale
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 8 |